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

sagar Bhosale

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

14 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vijay Yadav15y ago
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 Bhosale15y ago
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 Yadav15y ago
Sagar, krishna also suggested you the same... Have you tried that?
Vijay Yadav15y ago
Sagar that is possible by generating scripts with data in sql 2008 and then run that script with data in SQL 2005...
sagar Bhosale15y ago
Thanks for reply
Suthish Nair15y ago
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 Shekhawat15y ago
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

But 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 Bhosale15y ago
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 Ivaturi15y ago
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 Bhosale15y ago
Yes Suthish i read that article but i can't understand how to do .plz help me

Thanks
Suthish Nair15y ago
The link provided have the solution. Did you tried reading it?
Krishna Garad15y ago
generate script for your database as above link with script data and in sql 2005 execute the generated script.
sagar Bhosale15y ago
Thanks for reply,

Still i can't get solution plz help me
Jiteendra Sampathirao15y ago
Hi sagar,
refer this link ..it might help you......

Link 1: