Home Search Tags Members

Home » Kartris ASP.NET Ecommerce Software » Kartris technical issues » Copying DB data failing on upgrade

Copying DB data failing on upgrade

Posted By thedrumdoctor Mon 10 Oct 2011
Add to Favorites1

Copying DB data failing on upgrade

Topic View Topic View Topic Options Topic Options
Author Message
thedrumdoctor
Posted Mon 10 Oct 2011
Supreme Being

Supreme Being - (68,457 reputation)Supreme Being - (68,457 reputation)Supreme Being - (68,457 reputation)Supreme Being - (68,457 reputation)Supreme Being - (68,457 reputation)Supreme Being - (68,457 reputation)Supreme Being - (68,457 reputation)Supreme Being - (68,457 reputation)Supreme Being - (68,457 reputation)

Group: Forum Members
Last Active: Mon 21 May 2018
Posts: 94, Visits: 266
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.
Tags
Edited Mon 10 Oct 2011 by thedrumdoctor
Post Information
Mohammad
Posted Fri 14 Oct 2011
Kartris Expert

Kartris Expert - (78,821 reputation)Kartris Expert - (78,821 reputation)Kartris Expert - (78,821 reputation)Kartris Expert - (78,821 reputation)Kartris Expert - (78,821 reputation)Kartris Expert - (78,821 reputation)Kartris Expert - (78,821 reputation)Kartris Expert - (78,821 reputation)Kartris Expert - (78,821 reputation)

Group: Administrators
Last Active: Sun 27 Sep 2015
Posts: 115, Visits: 706
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.
Post Information
thedrumdoctor
Posted Mon 17 Oct 2011
Supreme Being

Supreme Being - (68,457 reputation)Supreme Being - (68,457 reputation)Supreme Being - (68,457 reputation)Supreme Being - (68,457 reputation)Supreme Being - (68,457 reputation)Supreme Being - (68,457 reputation)Supreme Being - (68,457 reputation)Supreme Being - (68,457 reputation)Supreme Being - (68,457 reputation)

Group: Forum Members
Last Active: Mon 21 May 2018
Posts: 94, Visits: 266
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.
Post Information

Similar Topics

Expand / Collapse

Reading This Topic

Expand / Collapse

Back To Top

Powered By InstantForum.NET 2012-1 © 2024
Execution: 0.047. 9 queries. Compression Enabled.