Most Recent Posts
AC Version 12.3
by ChrisFNP - 04/24/2025 6:51 PM
An automated process failed: MedsUdates
by ChrisFNP - 04/24/2025 6:00 PM
New Feature?
by ChrisFNP - 04/22/2025 6:37 PM
Here is a new one
by ChrisFNP - 04/22/2025 6:20 PM
I won't get help because I am I
by Bert - 04/22/2025 9:09 AM
Pharmacy Request Counter Issues
by Headcase - 04/08/2025 7:04 PM
phantom printer
by imcffp - 04/08/2025 10:26 AM
AC v12 mandatory upgrade
by ChrisFNP - 04/01/2025 9:47 AM
Member Spotlight
bmdubu
bmdubu
Tampa
Posts: 34
Joined: August 2010
Newest Members
It's me, Paradise Family, MedCode, MZ Medical Billi, girlfromwebpage
4,593 Registered Users
Previous Thread
Next Thread
Print Thread
Rate Thread
#57100 09/26/2013 10:57 PM
Joined: Sep 2011
Posts: 65
slater Offline OP
Member
OP Offline
Member
Joined: Sep 2011
Posts: 65
We are looking to possibly merge with a larger group for various reasons. My key question for anyone out there is can our data (they are my patients and all) be exported over to another EHR? Specifically GE Centricity (I've used it before and no it's not as good as AC).

I know AC has decided to lock down the database (which can be bypassed from what I've read) but is there a simple way to simply export all the encounters in a useful form that's not a complete nightmare (I want the discrete data, not PDFs)?

Is the CSV file created in the admin panel useful at all for this? I'm going to be handing the database file over to the IT team to help with this and they can mount it to another instance of SQL but that still leaves a fair amount of work. Anyone have any thoughts?

Thanks!!

Joined: Aug 2012
Posts: 196
Member
Offline
Member
Joined: Aug 2012
Posts: 196
The AC database can be easily opened in another instance of SQL.
My IT help has been successfully been able to do this. Had to upgrade the SQL version after AC upgraded to 6.5.
Not a lot of work can be accomplished in less than an hour.

Joined: Sep 2011
Posts: 65
slater Offline OP
Member
OP Offline
Member
Joined: Sep 2011
Posts: 65
The IT department will probably know but is mapping the database over to another system from that point fairly 'simple'?

I may give this a try with a backup of my database and see what I can poke around and see.

What did you guys do to copy the database? Detach - copy - reattach? or backup/restore? I'd prefer not to have much downtime during the day today (not that I'll have much opportunity to play with the DB with a full schedule).

Joined: Dec 2009
Posts: 1,197
Likes: 8
Member
Offline
Member
Joined: Dec 2009
Posts: 1,197
Likes: 8
You can mount the database in another instance of SQL Server that is installed on the machine. Once done, you can use Access or another tool to pull the data out into CSV files then hand it off to the integration team to import the data into GE Centricity.

JamesNT


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
1 members (ChrisFNP), 88 guests, and 36 robots.
Key: Admin, Global Mod, Mod
Top Posters(30 Days)
ffac 7
koby 5
imcffp 5
JBS 3
Bert 2
tcosta 2
Top Posters
Bert 12,873
JBS 2,982
Wendell365 2,363
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