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
 General help me questions
 Step by step Access to SQL conversion
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jayceew
VP-ASP New User

USA
111 Posts

Posted - April 27 2007 :  10:17:22  Show Profile  Reply with Quote
Hi All,
I know this has been a topic many times, But here goes......Can anyone give me step by step instruction for converting my access DB to Microsoft SQL?

I'm using VP-ASP version 6.09
I have approx 25,000 products in my access DB, but will eventually have up to 125,000 products or more.
MS SQL is part of my hosting package, so I'm thinking I should convert now before I set up my server and upload my site.

Any help would be greatly appreciated.

Thanks

Jack

devshb
Senior Member

United Kingdom
1898 Posts

Posted - April 28 2007 :  01:45:10  Show Profile  Visit devshb's Homepage  Reply with Quote
This might help:

Got any detailed steps/notes/warning for converting vpasp from access to sqlserver? -
http://www.bigyellowzone.com/support/issue_view.asp?ID=702

Simon Barnaby
Developer
[email protected]
www.BigYellowZone.com
Web Design, Online Marketing and VPASP addons
Go to Top of Page

jayceew
VP-ASP New User

USA
111 Posts

Posted - April 28 2007 :  09:20:26  Show Profile  Reply with Quote
Hi Simon,
WOW, you are awesome. Thanks so much that was exactly what I needed.
Thank You, Thank You, Thank You,
Jack

PS.
I'm interested in your domain tools bolt on. Does it work in 6.09 and will it work in 6.5 ?

Thanks Again
Jack
Go to Top of Page

devshb
Senior Member

United Kingdom
1898 Posts

Posted - April 28 2007 :  17:36:23  Show Profile  Visit devshb's Homepage  Reply with Quote
The domain tool does work on 6.0x. We haven't specifically flagged it as 6.5-compliant yet, but that's just because we haven't finished testing it for 6.5; there's nothing in it that I can see which would need to be changed to cater for 6.5, especially as it's not effected by shopfileio.asp (which is now included in shop$db.asp in 6.5).

Simon Barnaby
Developer
[email protected]
www.BigYellowZone.com
Web Design, Online Marketing and VPASP addons
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000