How to copy database from one sql server to other sql server

Question

Hi Friends I want to know how to copy database from one sql server to other sql server plz help me suppose i have database in sql server 2008 is it possible to copy that database in sql server 2005 how to do this? i wait for your valuable reply Thanks

Vijay Yadav · Answer

Hi Sagar I am not sure whether it will work or not but we can also restore the .bak file and then generate the scripts.

sagar Bhosale · Answer

Thanks Vijay I have .bak file that is not generated in script format in ss2008 so that's i can't copy .bak file in ss2005 so that's why i install ss2008 in my system There is one doubt for me if i create .bak file in ss2008 R2 it is possible for me copy that .bak file in ss2008 Thanks all of friend for your valuable helps

Vijay Yadav · Answer

Sagar krishna also suggested you the same... Have you tried that?

Vijay Yadav · Answer

Sagar that is possible by generating scripts with data in sql 2008 and then run that script with data in SQL 2005...

sagar Bhosale · Answer

Thanks for reply

Suthish Nair · Answer

First of all why you want to make a copy from 2008 to 2005. Due to backward compatibility you cannot make do this. You need to generate each sql scripts from Management studio and run it on SS 2005.

Sandeep Shekhawat · Answer

Use Generate Script to create data base that target Sql Server 2005. Description is available here: http://www.sqlservermart.com/HowTo/MSSQL_Convert_2008_To_2005.aspx B ut Remeber Change Script for Server Version= Sql Server 2005 in process steps Then copy paste data from one table to another table means Sql Server 2008 tables to Sql Server 2005 Table.

sagar Bhosale · Answer

Hi friends i will try this way i Radar.bak file when i open sql server databae i create new Database name is Radar on right click my new database i click on Restore then i select my Radar.bak file That Radar.bak file is create in sql server 2008 & i want to copy that database into sql server 2005 but it is show me error i posted that screenshot plz help me

Akkiraju Ivaturi · Answer

Follow this link: http://blogs.msdn.com/b/sreekarm/archive/2009/09/11/move-a-database-from-one-server-to-another-server-in-sql-server-2008.aspx This may help you.

sagar Bhosale · Answer

Yes Suthish i read that article but i can't understand how to do .plz help me Thanks

Suthish Nair · Answer

The link provided have the solution. Did you tried reading it?

Krishna Garad · Answer

generate script for your database as above link with script data and in sql 2005 execute the generated script.

sagar Bhosale · Answer

Thanks for reply Still i can't get solution plz help me

Jiteendra Sampathirao · Answer

Hi sagar refer this link ..it might help you...... Link 1: