how to convert sql server 2008 r2 database to sql server 2005
-
hello my Friends I do not convert sql server 2008 r2 database to sql server 2005 Please help me :((
-
hello my Friends I do not convert sql server 2008 r2 database to sql server 2005 Please help me :((
You can't simply back up and restore as you would going the other way, so you are going to have to script the schema across and then write a script to transfer the data. Red-Gate have tool that we use to do this job (usually between UAT and production, never 2008 => 2005) [edit] Red-Gate are not free or cheap and it may not be worth it for a one off job [/edit]
Never underestimate the power of human stupidity RAH
-
You can't simply back up and restore as you would going the other way, so you are going to have to script the schema across and then write a script to transfer the data. Red-Gate have tool that we use to do this job (usually between UAT and production, never 2008 => 2005) [edit] Red-Gate are not free or cheap and it may not be worth it for a one off job [/edit]
Never underestimate the power of human stupidity RAH
Step by step guide: http://www.sqlservermart.com/HowTo/MSSQL_Convert_2008_To_2005.aspx[^] http://www.linglom.com/2009/08/11/restore-database-from-sql-server-2008-to-sql-server-2005-part-1-introduction/[^] Other: http://www.todo-backup.com/backup-resource/sql-backup-software/restore-sql-2008-database-backup-to-sql-server-2005.htm[^] http://www.nwds-ak.com/WebResources/Database/RestoreSQLServer2008to2005/CreatingSQLScriptstoRestore2008.aspx[^]
-
Step by step guide: http://www.sqlservermart.com/HowTo/MSSQL_Convert_2008_To_2005.aspx[^] http://www.linglom.com/2009/08/11/restore-database-from-sql-server-2008-to-sql-server-2005-part-1-introduction/[^] Other: http://www.todo-backup.com/backup-resource/sql-backup-software/restore-sql-2008-database-backup-to-sql-server-2005.htm[^] http://www.nwds-ak.com/WebResources/Database/RestoreSQLServer2008to2005/CreatingSQLScriptstoRestore2008.aspx[^]
I think you posted this reply to the wrong person, although from the titles I did not know you could use backup/restore, interesting.
Never underestimate the power of human stupidity RAH
-
hello my Friends I do not convert sql server 2008 r2 database to sql server 2005 Please help me :((
Step by step guide: http://www.sqlservermart.com/HowTo/MSSQL_Convert_2008_To_2005.aspx[^] http://www.linglom.com/2009/08/11/restore-database-from-sql-server-2008-to-sql-server-2005-part-1-introduction/[^] Other: http://www.todo-backup.com/backup-resource/sql-backup-software/restore-sql-2008-database-backup-to-sql-server-2005.htm[^] http://www.nwds-ak.com/WebResources/Database/RestoreSQLServer2008to2005/CreatingSQLScriptstoRestore2008.aspx[^]
-
I think you posted this reply to the wrong person, although from the titles I did not know you could use backup/restore, interesting.
Never underestimate the power of human stupidity RAH
OK, thank you very much for your reply. I moved my answer...