Red Gate forums :: View topic - SQL2005 Incompatibility?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Compare Previous Versions
SQL Data Compare Previous Versions forum

SQL2005 Incompatibility?

Search in SQL Data Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
dbmcdonald



Joined: 29 Aug 2011
Posts: 2

PostPosted: Mon Aug 29, 2011 6:50 pm    Post subject: SQL2005 Incompatibility? Reply with quote

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.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6674

PostPosted: Tue Aug 30, 2011 9:43 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
dbmcdonald



Joined: 29 Aug 2011
Posts: 2

PostPosted: Tue Aug 30, 2011 5:10 pm    Post subject: Thanks for the reply Reply with quote

Thanks for the reply. I am completely baffled as to why I had this problem then.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group