Upgrading from Access to SQL

Did you had any response for this query, I am planning to do that same, anything to be aware of?

Thanks

blueshire and igurv,

Upgrading from Access to SQL is not a trivial process.  My experience is that the upsizing wizard built into Access is not that good.  Problem with Upsizing is that it will try to re-create the Table Schema for the SQL side which will cause problems when you try to run the store. You are much better off migrating just the data into an SQL database that is already populated with the correct tables and has the correct schema.  As I said before, even moving the data is not trivial because you are dealing with Foreign Key Constraints that will not allow you to move all the tables at once.  The best example of this I can give you is that you cannot populate the data for orders until you have the products data and customers data in because one table relies on the other.  This is the case with many of the tables and those relevant relationships are different for each store depending on which features you are using and are not using. 

There are many other considerations and things to be aware of when migrating your store from Access to MSSQL but honestly, it would take me a very long time to list them all. 

After spending several weeks learning how to migrate our own store over to SQL, we started doing these migrations for other ProductCart Customers and have done a very good job at this. 

If you are interested, my company is Cognecy Solutions, LLC and we can do your conversion from Access to MSSQL.

Please see our post in the Partner Offers thread for details.[ http://www.earlyimpact.com/forum/forum_topics.asp?FID=14  ]


Mark Shipp
Chief Executive Manager
Cognecy Solutions, LLC
mark@cognecy.com

The setting for the scDB variable woudl be:

private const scDB="SQL"

The complete string should look like this:

<%private const scCrypPass="your_product_cart_Key"
private const scDSN="Provider=sqloledb;Data Source=url.yourserver.com,1433;Initial Catalog=your_DB_Name;User Id=your_user_id;Password=your_password;"
private const scDB="SQL"
private const scStoreURL="http://your_store_url.com"%>

Please note that you should never connect to an SQL db using an IP address (always use a URL (your hosting provider will provide this).

If you have any questions about this process feel free to contact me any time (just not at 2:00 AM in the morning please).

Mark Shipp
214-206-8910 (Office Line - GMT-6:00)
mark@cognecy.com