January 24, 2011 at 10:22 am
Hi,
I am new to sql server 2008R2.
We have a reporting server on which we have 2 instances, one is sql server 2005 sp3 enterprise edition and other is sql server 2008R2 express edition with advanced services.
I have a database on the sql 2008 instance which i want to copy it to sql 2005 instance.
How can i acheive this?
Thanks.
Regards,
Sushan
Regards
Sushant Kumar
MCTS,MCP
January 24, 2011 at 10:29 am
You can't use backups because they never were and never will be backward compatible. You need to script the whole db and objects. Then reimport the data.
January 24, 2011 at 11:32 am
@ ninja
Thanks.
Will be there any compatibility issues when i run sql 2008 database in sql 2005?
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
January 24, 2011 at 11:40 am
No because you HAVE TO remake the whole thing from scratch... no backup, no restore. Script everything, rebuild the whole structure and reimport the data manually.
January 24, 2011 at 11:41 am
To recreate the database on SQL 2005 you'll have to remove/change any SQL 2008-specific features (spatial, date, time, etc) otherwise the creation scripts won't run on SQL 2005
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 24, 2011 at 11:43 am
GilaMonster (1/24/2011)
To recreate the database on SQL 2005 you'll have to remove/change any SQL 2008-specific features (spatial, date, time, etc) otherwise the creation scripts won't run on SQL 2005
What she said.... but that would have been obvious at this point I guess :w00t:.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply