December 2, 2011 at 6:49 am
Hi!
i use Sql server 2008. i made my db in 2008. But my customer has sql server 2005. i need to load db his server. i set my db' compatible setting for 2005. Does any problem occur in Sql Server 2005?
Can i load this db to sql server 2005 properly.
Thanks in advance.
December 2, 2011 at 7:00 am
No you cannot restore/copy a SQL 2008 database on a 2005 system, no matter what you're compatibility level is. The reason is that the file structure is different.
The only way I know for migrating would be using SSIS to create the database and export the data.
[font="Verdana"]Markus Bohse[/font]
December 2, 2011 at 7:02 am
Script the tables and the data and run those in the 2005 server
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply