Database Xfer: MS Access to MS SQL

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   We are running ProductCart v4.7Ms (parent paths enabled).
We want to add the QuickBooks integration, but one of the requirements is that we need to have our store on a MS SQL database and ours was originally set up with an MS Access database.  Our hosting provider can run MS SQL, but I have NO idea how to switch the databases.  I don't want to lose the over 2,100 product records, over 3,500 sales order/invoice records and the hundreds of customers we have in the MS Access database.

Is there a way that I can transfer data from one database to the other on my own through ProductCart and is there a detailed step-by-step instructions (know NOTHING about MS SQL!) on how to accomplish this?

-OR-

Is there a person/service company that we can hire to do the transfer for us?  Any recommendations?

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
MGatESS Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 12-July-2006 Location: United States Status: Offline Points: 73	Post Options Post Reply Quote MGatESS Report Post Thanks(0) Quote Reply Topic: Database Xfer: MS Access to MS SQL Posted: 04-April-2014 at 12:31pm
	We are running ProductCart v4.7Ms (parent paths enabled). We want to add the QuickBooks integration, but one of the requirements is that we need to have our store on a MS SQL database and ours was originally set up with an MS Access database. Our hosting provider can run MS SQL, but I have NO idea how to switch the databases. I don't want to lose the over 2,100 product records, over 3,500 sales order/invoice records and the hundreds of customers we have in the MS Access database. Is there a way that I can transfer data from one database to the other on my own through ProductCart and is there a detailed step-by-step instructions (know NOTHING about MS SQL!) on how to accomplish this? -OR- Is there a person/service company that we can hire to do the transfer for us? Any recommendations?
	~ Mark G. ESS, Inc. - www.endoscopy.com

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Posted: 04-April-2014 at 1:49pm
	Mark Shipp - 214 206 8910 Mark is the expert on this subject. There is nobody other than him that I even consider when this is needed.

cognecy Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 18-March-2006 Location: United States Status: Offline Points: 8	Post Options Post Reply Quote cognecy Report Post Thanks(0) Quote Reply Posted: 04-April-2014 at 2:01pm
	Mark G. Definitely do not attempt this yourself as it is not something you just switch to and there is no easy way to go about it (e.g. no step by step instructions). I have been doing Access to MSSQL Conversion/Migration for the ProductCart community for the better part of the last 8-9 years and can certainly get this taken care of for you quickly with very little downtime and 0 data loss. I have sent you a private message with all my contact details. Mark Shipp
	Mark Shipp Cognecy Solutions, LLC Hosting/Design/Customization/Database Migration www.cognecy.com www.cognecy.co.uk