ProductCart Shopping Cart Software Forums : Database Xfer: MS Access to MS SQL https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 03:41:32 +0000 Fri, 04 Apr 2014 14:01:48 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=5867 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Database Xfer: MS Access to MS SQL : Mark G.Definitely do not attempt...]]> https://forum.productcart.com/database-xfer-ms-access-to-ms-sql_topic5867_post22018.html#22018 Author: cognecy
Subject: 5867
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]]> Fri, 04 Apr 2014 14:01:48 +0000 https://forum.productcart.com/database-xfer-ms-access-to-ms-sql_topic5867_post22018.html#22018 <![CDATA[Database Xfer: MS Access to MS SQL : Mark Shipp - 214 206 8910Mark...]]> https://forum.productcart.com/database-xfer-ms-access-to-ms-sql_topic5867_post22017.html#22017 Author: Greg Dinger
Subject: 5867
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.


]]> Fri, 04 Apr 2014 13:49:53 +0000 https://forum.productcart.com/database-xfer-ms-access-to-ms-sql_topic5867_post22017.html#22017 <![CDATA[Database Xfer: MS Access to MS SQL : We are running ProductCart v4.7Ms...]]> https://forum.productcart.com/database-xfer-ms-access-to-ms-sql_topic5867_post22016.html#22016 Author: MGatESS
Subject: 5867
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?
]]> Fri, 04 Apr 2014 12:31:50 +0000 https://forum.productcart.com/database-xfer-ms-access-to-ms-sql_topic5867_post22016.html#22016