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
 General help me questions
 SQL Server		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

edhabal
Starting Member

USA
1 Posts
Posted - August 19 2020 :  12:13:49  Show Profile  Visit edhabal's Homepage  Reply with Quote
I moved from Access to SQL Server (with SQL Server Management Studio) and it is much better, seemed to go ok except the autonumber fields in Access tables did not convert to identity fields in MS SQL Server. Is there a process for doing this? Any other steps needed?
Thanks! Ed

Ed Habal

support
Administrator

4679 Posts
Posted - August 19 2020 :  16:18:07  Show Profile  Visit support's Homepage  Reply with Quote
Hi Ed

You need to use our copy dB tool to do the migration. You cannot use the built in sql migration tool unfortunately as this corrupts the data fields.

You can download this from our download page at:

https://www.vpcart.com/virtprog/vpaspcustomer.htm#addons

Using our tool ensures that you will have no identity issues as the tables are correctly configured.

Please ensure that you follow the instructions carefully and you must check that all custom tables and fields if any exist in your Access dB are added to the creation script first.

Thank you.

Cam Flanigan
VPCart Customer Care Team
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