Welcome, Guest ( Customer Panel | Login )




 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-CART New User

USA
114 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
1904 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-CART New User

USA
114 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
1904 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
0 Item(s)
$0.00