How to transfer local sql server or database to another computer

Question

I'm working on a project with 4 other guys, and we are developing an android app with a DB. Now, we are going to use a localhost for our SQL Server, I want to be able to take the database from my laptop and copy it to the other guys' computers. I"m using SQL Server 2008 Management Studio.

Any ideas of how to do it? I don't mind to copy the entire localhost server if we can do that.

BTW, I tried to backup the DB on my laptop by right-click on the DB (created .bak file) but there is no restore option on the other computer.

Thanks

Joe G Joseph · Accepted Answer · 2012-10-08 12:30:46Z

2

Backup your data base and restore in the other machines

edit

If you dont find the restrore option, please try using sql script

ex:

RESTORE DATABASE nwind_new FROM DISK = 'c:\backups\northwind\nwind.bak'
WITH
MOVE 'northwind' TO 'd:\Program Files\Microsoft SQL 
Server\Data\nwind_new.mdf'
MOVE 'northwind_log' TO 'd:\Program Files\Microsoft SQL
Server\Data\nwind_new_log.ldf'

You can try

edited Oct 8, 2012 at 12:30

answered Oct 8, 2012 at 12:24

Joe G Joseph

24.2k5 gold badges58 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Shiridish · Accepted Answer · 2012-10-08 12:35:15Z

0

See these links about backup and restore:

http://technet.microsoft.com/en-us/library/cc966495.aspx

and

http://blogs.msdn.com/b/sreekarm/archive/2009/09/11/move-a-database-from-one-server-to-another-server-in-sql-server-2008.aspx

To restore your database see this useful link:

http://msdn.microsoft.com/en-us/library/ms177429(v=sql.100).aspx

edited Oct 8, 2012 at 12:35

answered Oct 8, 2012 at 12:26

Shiridish

4,9625 gold badges37 silver badges64 bronze badges

Comments

Diego · Accepted Answer · 2012-10-08 12:39:03Z

0

its weird you dont see the restore option. You could try deattaching the DB from its location, copy the files (DB and LOG) to the new location and attach it there.

MSDN

answered Oct 8, 2012 at 12:39

Diego

36.5k21 gold badges94 silver badges138 bronze badges

Collectives™ on Stack Overflow

How to transfer local sql server or database to another computer

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related