FAQ - Frequently Asked Questions

Re: How to move databases between computers that are running SQL Server

ajitsatpathy — Sun, 25 Oct 2009 17:34:05 GMT

U need to open it from SQL management studio.

Re: How to move databases between computers that are running SQL Server

jerrios — Sun, 25 Oct 2009 15:29:19 GMT

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.

Re: How to move databases between computers that are running SQL Server

ajitsatpathy — Fri, 23 Oct 2009 17:48:47 GMT

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.

Re: How to move databases between computers that are running SQL Server

jerrios — Fri, 23 Oct 2009 16:55:38 GMT

Hello,

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 =)

Re: How to move databases between computers that are running SQL Server

Grayson@MS — Wed, 20 May 2009 16:56:26 GMT

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.

Deploying Databases with Web Application Projects Overview Pasted from <http://msdn.microsoft.com/en-us/library/dd465340(VS.100).aspx> Walkthrough: Deploying a Database with a Web Package Pasted from <http://msdn.microsoft.com/en-us/library/dd483479(VS.100).aspx> Walkthrough: Deploying a Database using Web Publish Pasted from <http://msdn.microsoft.com/en-us/library/dd579608(VS.100).aspx> How to: Include Custom Scripts with a Database in a Web Package Pasted from <http://msdn.microsoft.com/en-us/library/dd465343(VS.100).aspx>

HTH,

Grayson

Re: How to move databases between computers that are running SQL Server

ajitsatpathy — Tue, 19 May 2009 19:15:40 GMT

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.

Re: How to move databases between computers that are running SQL Server

shashanksaudagar — Fri, 15 May 2009 09:35:33 GMT

One can also use Copy database option to copy databases from source server to destination server. Otherwise the best way is to use ETL (Extract -Transform & Load) feature of SQL Server which is available by virtue of DTS in SQL Server 2000 or SSIS in SQL Server 2005. Here you can create Packages using BIDS (Business Intelligence Development Studio) IDE given by SQL Server 2005 and then run these packages by creating a job in SQL server.

Re: How to move databases between computers that are running SQL Server

soumendu — Thu, 14 May 2009 11:03:06 GMT

Hi ,see

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 .And if u still facing prob. then u can go for some extra expertise.

Ok then ...Bye

Re: How to move databases between computers that are running SQL Server

vineetJAISWAL — Wed, 13 May 2009 11:16:22 GMT

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.

Re: How to move databases between computers that are running SQL Server

kanth456 — Mon, 23 Mar 2009 04:20:13 GMT

hi,

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 kanth456@in.com

Re: How to move databases between computers that are running SQL Server

arry.net — Wed, 04 Mar 2009 12:17:40 GMT

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)

1. Tradenbids.mdf

2.Tradenbids_log.ldf

Copy these to file

and paste whaere ever you want

Now

Go to Run->Cmd->

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

Re: How to move databases between computers that are running SQL Server

TapeBoy929 — Thu, 05 Feb 2009 02:54:27 GMT

If you're looking to copy the database, you don't have to use backup/restore or detach/attach. You can use the copy database feature. This will capture the data, logins, and stored procedures. Try it out. Good luck.

Re: How to move databases between computers that are running SQL Server

rami_nassar — Mon, 05 Jan 2009 16:32:21 GMT

Deattach and Attach database from SQL Server Managment Studio...

Re: How to move databases between computers that are running SQL Server

sirdneo — Thu, 25 Dec 2008 05:46:58 GMT

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.

Re: How to move databases between computers that are running SQL Server

avinash_vns — Wed, 17 Dec 2008 05:51:30 GMT

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.

Avinash