I am currently running PC 2.75 with Apparel/Gift addon running on an Access database.  I have just purchased the upgrades to v3 but am considering since I'm undertaking a major upgrade I might as well upgrade to SQL server at the same time.

Has any one had any experience of this? any problems I should be aware of.  I intend trying to upgrade fully to v3 within Access (via 2.76 first) and then use the Access upsizing wizard on the v3 database to move to SQL

Any tips would be greatly appreciated

Richard
http://www.blueshire.com - www.blueshire.com

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 - http://www.earlyimpact.com/forum/forum_topics.asp?FID=14   ]


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

I am trying to move the DB from Access to MS SQL - what should be the settings for the variable scDB, changed to and do i need to make changes to SSL link, where would I find that?

Thanks Gurv

private const scCrypPass="sdfhsdfkshf98werwreiwerjv"
'private const scDSN="DRIVER={Microsoft Access Driver (*.mdb)};DBQ=d:\hosting\chque\ProductCart\dbcedfwb\EI27.mdb"
'private const scDSN="Provider=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=d:\hosting\chque\ProductCart\dbcwb\EI27.mdb;User Id=;Password=;"
private const scDSN= driver={SQL Server};server="&address&";uid="&username&"; pwd="&password&";database="&database
private const scDB="Access"
private const scStoreURL= " http://ww.xx.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"%'>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)
mailto:mark@cognecy.com - mark@cognecy.com

FWIW, I paid Early Impact to perform the DB conversion from Access to MSSQL 2000...and it was well worth every penny.  I'm of the impression the system I run is a bit "unusual" for a productcart installation...but, they made the migration pretty painless.

Then I turned around and migrated it to MSSQL 2005 myself a couple weeks later.

If they still offer the service, I'd consider paying to have it done.  The price was incredibly reasonable, you'll be supporting the ProductCart developers, and they have quite a bit more experience converting their own DB between formats than anyone else.