|
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.
Mon 10 Oct 2011 by
thedrumdoctor
|