Site Status
If you see this message. The move to a new host has completed
Most Recent Posts
Banning AIWEBDEVELOPMENTS.CO
M

by Ruben - 11/22/2024 1:39 PM
MAINE PEDIATRICIAN
by Bert - 11/22/2024 10:58 AM
TO THE DEVELOPERS
by ChrisFNP - 11/20/2024 12:01 PM
AC Billing Software
by tcosta - 11/14/2024 12:14 PM
How to edit diagnosis codes
by ChrisFNP - 11/12/2024 5:41 PM
More difficult to prescribe these days
by Tomastoria - 11/12/2024 12:15 PM
Total Deleted Items Record
by Bert - 11/07/2024 8:17 AM
Member Spotlight
ryanjo
ryanjo
Central Florida
Posts: 2,084
Joined: November 2006
Newest Members
girlfromwebpage, thomastommy12312, Dr M @ EmmFamPr, Stella, BritbikeMorgan
4,588 Registered Users
Previous Thread
Next Thread
Print Thread
Rate Thread
#79407 01/22/2024 10:10 AM
Joined: Oct 2012
Posts: 116
ffac Offline OP
Member
OP Offline
Member
Joined: Oct 2012
Posts: 116
My local hosted AC has a 2012 SQL that is 32bit. I have not been able to upgrade to 2016. There were many different instructions when this was a thing. I just gave up at the time. I now would like to fix this. I now find out the problem is the 32bit SQL. I pay for support ever year. Is this something AC support is supposed to fix or will I get nickel and dimed? I wanted to just do a new VM install and move my database over to fix this issue but support said that costs extra. Any suggestions?

Joined: Nov 2009
Posts: 661
Likes: 15
Member
Online Content
Member
Joined: Nov 2009
Posts: 661
Likes: 15
Sorry, can't help, hopefully James will see this and help you out.

Joined: Oct 2012
Posts: 116
ffac Offline OP
Member
OP Offline
Member
Joined: Oct 2012
Posts: 116
Bump.

Joined: Dec 2009
Posts: 1,194
Likes: 8
Member
Offline
Member
Joined: Dec 2009
Posts: 1,194
Likes: 8
@ffac,

Your solution is to indeed stand up a new virtual machine with SQL Server 2016 64-bit. The work of standing up the new virtual machine with Windows Server 2019 is your responsibility. AC will move your database over for you and take care of the rest for a fee of about $500. Pointing your workstations to the new AC server is also your responsibility as well as coordinating with any interfaces (LabCorp, etc.) for them to move their stuff over to the new server.

In short, this will cost you about a day's downtime and some money. If you are comfortable with all the things that are your responsibility, then paying AC is about all you have to do as most of the interface guys move their stuff for free. If you are not comfortable working with AC or standing up your own VM, pointing workstations, etc. then you can reach out to me to work with AC to turnkey it all for you. My rate is $95/hour.

Note that being comfortable handling such a migration yourself means also having the skill to solve any unforeseen technical issues that crop up as well. Handling the migration yourself with the idea that should something go wrong you can just email me or post on the forum and we will all drop what we are doing to save your hide then and there is not feasible. Such upgrades/migrations need to be well planned events rather than "I'll jump from the plane and ask for a parachute later if my idea doesn't work."

NOTE: I do not support peer-to-peer networks. At all. Also, I do not support any version of Windows older than Windows Server 2019 on the server side and Windows 10 on the client side. If you have older stuff, I can help upgrade it all but that will need to be factored into your costs and time.

James


James Summerlin
My personal site: http://www.dataintegrationsolutions.net
james@dataintegrationsolutions.net
Joined: Nov 2009
Posts: 661
Likes: 15
Member
Online Content
Member
Joined: Nov 2009
Posts: 661
Likes: 15
Thanks James, glad to see you back on the board.

1 member likes this: JamesNT
Joined: Oct 2012
Posts: 116
ffac Offline OP
Member
OP Offline
Member
Joined: Oct 2012
Posts: 116
Since my SQL server was 32-bit on my AC server, I was not able to update to SQL server 2016 myself. I had to schedule the update to be done by tech support. It took multiple agents nearly 2 hours and it forced me to AC v11.5 from v11.1.4. The update also forced my x-ray SQL server to have to be uninstalled and I had to move it to its own VM. I spent the whole weekend reconfiguring my server that runs all my VMs. I hope v12 doesn't introduce a whole set of new unforeseen problems. This is why I hate updates/upgrades. Ugh. /r

Joined: Nov 2009
Posts: 661
Likes: 15
Member
Online Content
Member
Joined: Nov 2009
Posts: 661
Likes: 15
Thanks for the update. Hopefully Tech support took note of the issues for the upcoming V12 change. I will say that going from 11.1.4 to 11.5 has been a significant improvement in both speed and prescribing issues. I still have some lag for prescribing and other small things but overall 11.5 has been more stable and I don;t see the "prescribing gremlins" I used to have.

Joined: Sep 2003
Posts: 12,849
Likes: 32
Member
Offline
Member
Joined: Sep 2003
Posts: 12,849
Likes: 32
A little of a hijacking, but I still would like an answer as to why the initial query for the eRx has to bring over all of the inactive meds. I don't know how their table and query works, but I don't need to go into the 20 drugs that are inactive except maybe every 8th to 10th time. I could wait then for AC to bring over the inactive.

JamesNT could comment here.

Yes, we had support try to install the latest version, and it just wasn't going to happen so we stayed with 11.1.4.


Bert
Pediatrics
Brewer, Maine

Joined: Dec 2009
Posts: 1,194
Likes: 8
Member
Offline
Member
Joined: Dec 2009
Posts: 1,194
Likes: 8
There is no reason why the query in AC should bring over active and well as inactive meds other than someone else thought it was a good idea to do so. One possible reason is seeing the med history may affect a doctor's thought process on what to give the patient next. For example, 6-month follow-up and the doctor decides to give the patient a new med, pulls up the chart and sees, "Wait, I tried that one two years ago. Never mind."

I'm completely making that up, but you get the point. Active and Inactive meds can be separated. My process to convert AC databases to PDF does so. You get two meds lists. One for active, one for inactive.

JamesNT

Last edited by JamesNT; 03/18/2024 8:08 PM.

James Summerlin
My personal site: http://www.dataintegrationsolutions.net
james@dataintegrationsolutions.net

Moderated by  ChrisFNP, DocGene, JBS, Wendell365 

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Who's Online Now
0 members (), 23 guests, and 15 robots.
Key: Admin, Global Mod, Mod
Top Posters(30 Days)
Bert 17
serene 5
JBS 4
Ruben 3
Top Posters
Bert 12,849
JBS 2,973
Wendell365 2,362
Sandeep 2,316
ryanjo 2,084
Leslie 2,002
Wayne 1,889
This board is dedicated to the memory of Michael "Indy" Astleford. February 6, 1961 -- April 16, 2019




SiteLock
Powered by UBB.threads™ PHP Forum Software 7.7.5