Is there a way in which I can mov a databse from one server to another? I've been developing a database on my localhost, and when I come to move it online, I'll want to be able to save myself the ...

Step-By-Step: Learn the basics of using DTS in Microsoft SQL Server Your email has been sent Learn how Data Transformation Services (DTS) can help you import, export, and/or transform data from ...

I've been able to move databases with sp_detach and sp_attach. Obviously, connections to that database will be dropped, but it shouldn't affect any others.