Sunday, February 19, 2012

How to Copy DataBases between SQL Express instances.

I am developing an application that uses SQL Server Express. Everything is running great, except that I can't figure out how to copy a DataBase from my server at work onto my laptop so that I may test it at home...

How can I copy the DataBase from my Server at work to my laptop? I'm on the network at work, I just can't figure out how to copy it...

Please help! :)

Thanks,

Jacob
Look up detach database in Books On Line, sp_detach_db and sp_attach_db|||Do I need SQL Server 2005 (not express) to do this through the management studio?

I'm not going to mess with doing this myself, I want the software to do it.
|||

I don't have SSMS-E installed but right click on the database and see if you have a detach option, or an All tasks|Detach Option.

If you do, take it, once the file is detached just copy the foo.mdf and foo.ldf to the new server, then right click and select attach.

No comments:

Post a Comment