Copying DB data failing on upgrade

Copying DB data failing on upgrade

Home » Kartris ASP.NET Ecommerce Software » Kartris technical issues

https://forum.kartris.com/Topic1396.aspx

Print Topic | Close Window

By thedrumdoctor - Mon 10 Oct 2011

I've done a V1.2 - V1.3 upgrade on a staging server and it's time for me to copy the data from the staging server to the live server.

For the record, I've never copied data from one SQL database to another....ever.

My staging server has SQL 2008 Express installed on it and I was able to use the import export wizard to pull the data down from the live server onto a new backup database on my staging server.

Using the import export wizard to transfer my upgraded SQL data from the staging server back up to the live server is falling at the first hurdle:

- Validating (Error)
Messages
Error 0xc0202049: Data Flow Task 1: Failure inserting into the read-only column "ADR_ID".
(SQL Server Import and Export Wizard)

Error 0xc0202045: Data Flow Task 1: Column metadata validation failed.
(SQL Server Import and Export Wizard)

Error 0xc004706b: Data Flow Task 1: "component "Destination - tblKartrisAddresses" (52)" failed validation and returned validation status "VS_ISBROKEN".
(SQL Server Import and Export Wizard)

Error 0xc004700c: Data Flow Task 1: One or more component failed validation.
(SQL Server Import and Export Wizard)

Error 0xc0024107: Data Flow Task 1: There were errors during task validation.
(SQL Server Import and Export Wizard)

Looking at it, there seems to be a problem writing data to the existing database but I am completely out of my depth on this. The Kartris knowledgebase on upgrading to a newer version states:

"6. Copy your new site database to the live database, overwriting the existing data."

I'm clueless about how to copy the new data to the old database and the provided import export wizard is the only way I can think of doing it. Can any experienced developers please point me where I'm going wrong?

I have backups of the old database in .bak format aswell.

By Mohammad - Fri 14 Oct 2011

To copy the upgraded database (1.3 ready) from your staging server to the live server, you don't need to use the data tool.

The best way to do it is to create a backup ".bak" for the upgraded db from the staging server, and then copy that file to the live server, so it will be restored in the live db server for the new (kartris 1.3) db.

By thedrumdoctor - Mon 17 Oct 2011

Thanks for the reply, I've opened up a ticket in the support area as I'm getting errors trying to restore from the .bak file.