Last post Feb 07, 2010 05:27 AM by rami_nassar
Nov 06, 2006 06:37 PM|Caddre|LINK
I recommend Backup and Restore because it also move your permissions, there is a known issue of orphaned permissions, meaning the permissions are created in the Master database but not in your database. The quick solution delete the restore and create a
new one. Please download and read the free backup and restore chapter from SQL Server 2005 a beginner’s guide.
If you use another method remember to check your permissions if they were not moved you need to follow the direction in the section dealing with moving your logins. Hope this helps.
May 13, 2008 11:13 PM|devcalpoly|LINK
Detach and attach will also work. Using T-SQL or Wizards.
May 29, 2008 06:43 AM|vijay.tri2001|LINK
If you want simply transfer just generate script and transfer through DTS.
Jun 19, 2008 08:32 PM|byte4321|LINK
Right click on database and export the tables to new server/database.
Dec 11, 2008 10:08 PM|rami_nassar|LINK
I'm using attach and deattach in my work... and sometimes exporting scripts
Dec 17, 2008 04:51 AM|avinash_vns|LINK
There are many way to transfer running database.
1- Using backup restore.
2. Using Replication.
Detach and Attach is not the right way because there is chance of data loss.
Dec 25, 2008 04:46 AM|sirdneo|LINK
Attaching/Deattaching works fine on first build at production or Q/A. But whenever I fix bug I create scripts to update the production database.
Jan 05, 2009 03:32 PM|rami_nassar|LINK
Deattach and Attach database from SQL Server Managment Studio...
Feb 05, 2009 01:54 AM|TapeBoy929|LINK
Mar 04, 2009 11:17 AM|arry.net|LINK
just do this
Go to Run->Cmd->
write->Net Stop Mssqlserver (or just shut down ur sqlserver 4 a while from
SQL Server Configuration Manager)
(After ,it has Stopped)
Go Tothis Direcrtory:-----
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data
here in data 2 files of ur database are stored(in my case Tradenbids)
Copy these to file
and paste whaere ever you want
write->Net Start Mssqlserver (it will start mssqlserver)
now u have the whole db , just copy and paste these to file whenever u want a backup
Mar 23, 2009 04:20 AM|kanth456|LINK
am srikanth.i have two databases one at source and other at target with same structure .i want to track the changes of dml operations of tables and convert this into Xml file and that should be sent through email and updated to database how to solve this
problem please reply it to my mail firstname.lastname@example.org
May 13, 2009 11:16 AM|vineetJAISWAL|LINK
Why are you not using Import/Export if your system is connected in LAN, other wise you can use backup and restore option which take all your permisson, Identity, Defaultvalue as per your master database.
May 14, 2009 11:03 AM|soumendu|LINK
If u system is in local area connection(& in both the master & slave contain same formated server with same OS configuration) i think u can easily transfer the data(sometimes back i was at same confusion) the i take my senior help & u cannot even imagin
that i tranfer througn external hard drive(by copying from the source & moving to any other ).so [Yes] .And if u still facing prob. then u can go for some extra expertise.
Ok then [cool] ...Bye
May 15, 2009 09:35 AM|shashanksaudagar|LINK
May 19, 2009 07:15 PM|ajitsatpathy|LINK
You can copy .mdf & .ldf file. But for that, you have to first stop the sql server service. And this is one of the bad idea, because noone will give permission to stop service in a live server where a number of applications are running. So you may follow
one of the following solutions.
1) You may generate query which will contains structure of all tables & all stored procedures, functions etc. (Data will not be copied in this process)
2) Create back up & restore on your local machine where you want. (It'll copy strucure as well as data)
3) Export data from one system & import data on another system by using DTS export wizard.
export import database
create back up of database
May 20, 2009 04:56 PM|Grayson@MS|LINK
You might want to look at the new deployment features in Visual Studio 2010 beta 1 that was just released. We've got some powerful tools to make it much easier to move a database with a Web application project for either hosted or self-hosted sites.
Visual Studio 2010 beta 1
Oct 23, 2009 04:55 PM|jerrios|LINK
I'm a new user to this tools and am building a web project using visual web developer express 2008. I tried transfering all my project files to another computer but i can't get the database to connect. I've read that you have to attach detach, copy paste
etc lots of way to transfer the file. What i did before was just copy the project folder and transfer with usb but it kinda lost the database connection. How do i transfer the db as well? Hope you guys can help. I'm new so i don't get the term you guys using.
I found the attach method but i wanna know the other methods as well as a back up since the other computer is kinda far away and i wanna make sure i get it right this time. Please help. Thank you =)
Oct 23, 2009 05:48 PM|ajitsatpathy|LINK
Right click on your database. Go to Tasks->Backup. It'll show a location where to save. Take backup by clicking OK. Just go to that location & copy that file. Then go to second computer where you want to restore. Open SQL Server. Right click on "Databases".
Go to "Restore Database". Select "from device" option. Click on the right side button. Then click "Add". select that backup file & click OK. Then click "To database" dropdown list. You can see your database name. Select it & click OK.
Tell m if any problem.
Oct 25, 2009 03:29 PM|jerrios|LINK
Right click on database as in in database explorer? is it in visual web developer express 2008? And plus everytime i choose to 'view in browser' my .aspx page it says asp.net developement server.
Oct 25, 2009 05:34 PM|ajitsatpathy|LINK
U need to open it from SQL management studio.
Feb 07, 2010 05:27 AM|rami_nassar|LINK
mmmmmm, if you need to accomplish that programitically, you can use SQLBulk Copy