Your Cart

Shopping Cart Items: 0   Sub-Total : $0.00    View Cart    Checkout
Welcome, Guest ( Customer Panel | Login )


Home | Profile | Register | Active Topics | Members | Search | FAQ


Forgot your Password?
 All Forums
 VPCart Forum
 Customization
 Upgrading from Access database to SQL server		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sakk
Starting Member

Canada
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.

Sakk

support
Administrator

4679 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.

http://www.vpasp.com/virtprog/vpaspcustomer.htm#addons

Hope this helps.

Thank you.

Cam Flanigan
VP-ASP Cart Support

Follow us on Twitter:
http://www.twitter.com/vpasp

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000
0 Item(s)
$0.00
  • Your Cart Is Empty