VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-ASP Shopping Cart Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 Upgrading from Access database to SQL server
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

21 Posts

Posted - July 12 2010 :  04:43:11  Show Profile  Reply with Quote
Hi there,

I have developed my store using VPASP back in 2007 and used MS Access that time, but now I want to upgrade my database to MS SQL Server.

Can you please confirm how can I do this, do I need to upgrade from Access to MSSQL or I need to install MSSQL and switch connection details in shop$db.asp file? Also I do not want to loose all the orders I have received uptill and now and they are stored in access database which is live. I want all data to be migrated as well with migration from access to MSSQL.

Please advise and thank you in advance.



4263 Posts

Posted - July 15 2010 :  08:13:08  Show Profile  Visit support's Homepage  Reply with Quote
Hi Sakk,

We have a module that will allow you to convert from Access to SQL Server in our download center.

You need to create a blank SQL database and then use our module to migrate your data.

Do not use the SQL migration tools as your site will hit many issues due to field types not being picked up corectly.

You need to use our scripts to firstly create the blank database and then the module to move your data across.


Hope this helps.

Thank you.

Cam Flanigan
VP-ASP Cart Support

Follow us on Twitter:

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000