SQL2005 Incompatibility?

Compares and synchronizes SQL database content.

SQL2005 Incompatibility?

Postby dbmcdonald » Mon Aug 29, 2011 5:50 pm

So far I really love SQL Data Compare, BUT....

I just had a problem on the third use where I had:
    Backed up a SQL2005 db (A)
    Copied A to Dev machine running SQL Data Compare
    Backed up SQL2005 db (B)
    Copied B to Dev machine running SQL Data Compare
    Restored A and B to a SQLExpress2008R2 into 2 db's that were setup with SQL2005 (90) compatibility
    Used SQL Data Compare and merged A into B selectively (not through scripts)
    Backed up new B SQL2005 db (which we will call C)
    Restored C to original machine where A came from but
    I get "SQL Server cannot process this media family. RESTORE HEADERONLY is terminating abnormally" which I would expect if I was not carefully that all db's were SQL 2005 version.

Why would I get this error? The only thing I can think of is that Data Compare did something to the db to make my 2005 server think it was 2008.

The work around I found was to:
    Restore B over A
    Run scripts generated by SQL Data Compare on B to make it C.
Posts: 2
Joined: Mon Aug 29, 2011 5:42 pm

Postby Brian Donahue » Tue Aug 30, 2011 8:43 am

SQL Data Compare doesn't do anything to the database properties, it strictly creates SQL DML scripts. You can see what is in those scripts before you run them - there is never any CREATE or ALTER database statement.
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Thanks for the reply

Postby dbmcdonald » Tue Aug 30, 2011 4:10 pm

Thanks for the reply. I am completely baffled as to why I had this problem then.
Posts: 2
Joined: Mon Aug 29, 2011 5:42 pm

Return to SQL Data Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests