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
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 VP-ASP 7.0 Questions
 Upgrade from Access to MS SQL 2008 - Best Practice
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Neilt
Starting Member

44 Posts

Posted - April 12 2011 :  06:03:07  Show Profile  Reply with Quote
What is the best method to upgrade from an Access database to SQL Server Express 2008

I have used the Microsoft SQL Server Migration Assistant 2008 for Access (http://www.microsoft.com/downloads/en/details.aspx?FamilyID=5abe098d-c7e1-46c6-994a-09a2856eef0b&displaylang=en)

I have a few oddities that I am investigating but wanted to be sure the above method was best practice for avoiding any problems?

Thanks

support
Administrator

4266 Posts

Posted - April 12 2011 :  06:26:43  Show Profile  Visit support's Homepage  Reply with Quote
Hi Neil,

We have an Access to SQL module on our site.

I would recommend only using this as using the SQL migration tool does cause certain table and field properties to go a bit wonky.

This can be downloaded from:
http://www.vpasp.com/sales/addons700.asp

Thank you.

Cam Flanigan
VP-ASP Cart Support

Follow us on Twitter:
http://www.twitter.com/vpasp
Go to Top of Page

Neilt
Starting Member

44 Posts

Posted - April 12 2011 :  07:23:14  Show Profile  Reply with Quote
Thanks for the quick reply Cam.

Does this cater for any columns we've added ourselves?

Thanks.
Go to Top of Page

support
Administrator

4266 Posts

Posted - April 12 2011 :  07:26:44  Show Profile  Visit support's Homepage  Reply with Quote
Hi Neil,

You will need to update the SQL creation scripts to add any database4 structure changes.

The way it works is firstly you create a blank SQL database that is a match for the Acess database.

The code will match the fields between the 2 databases and move the data for you.

if a field is missing in the SQL db then it will stop.

Thank you.

Cam Flanigan
VP-ASP Cart Support

Follow us on Twitter:
http://www.twitter.com/vpasp
Go to Top of Page

Neilt
Starting Member

44 Posts

Posted - April 12 2011 :  07:35:58  Show Profile  Reply with Quote
Thanks Cam,

can you confirm is that just the script "create700sqlserver.txt"

from within installation\sqlscripts

And is that the only file I need to change?

Thanks

Neil
Go to Top of Page

support
Administrator

4266 Posts

Posted - April 12 2011 :  07:51:15  Show Profile  Visit support's Homepage  Reply with Quote
That is correct.

Thank you.

Cam Flanigan
VP-ASP Cart Support

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

Go to Top of Page

Neilt
Starting Member

44 Posts

Posted - April 12 2011 :  09:15:11  Show Profile  Reply with Quote
Thanks for your help Cam.

Our situation was a little more complex as we'd done some development work in Access so had to manually add our new tables/columns into the standard SQL database. But it appears to be working now and the major problem (products being added to the cart with a blank description and price of 0) has been fixed.

Can I suggest this page be updated: http://www.vpasp.com/virtprog/info/faq_databases.htm

As it refers to: "SQL Server comes with migration tool that will allow you to move data from your Access database to the SQL Server Database." whereas your module seems the better solution.

Thanks again for your speedy and helpful responses.

Neil
Go to Top of Page

support
Administrator

4266 Posts

Posted - April 13 2011 :  01:10:34  Show Profile  Visit support's Homepage  Reply with Quote
Hi Neil,

Good point. I have updated this FAQ now so it is more relevant.

Cheers and glad I could help!

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