0

I need the ability to copy a database similar to what the Copy Database wizard accomplishes in SQL Server, but in a more automated (i.e. command line) fashion. I am writing a small application in C# that is making a copy of a web site (both files and database).

Is there a way to execute whatever the Copy Database wizard in SQL Server 2008 does in the command line / C#?

Scott
  • 137
  • 1
  • 1
  • 9

1 Answers1

2

Your best be would be to backup and restore the database using the BACKUP DATABASE and RESTORE DATABASE commands. The Copy Database Wizard can throw errors and miss stuff.

mrdenny
  • 27,174
  • 4
  • 41
  • 69
  • This is indeed the steps that I ended up having to take in order to correctly perform a copy. Thanks. – Scott Sep 23 '10 at 12:08
  • And once you do the BACKUP/RESTORE, just pay attention to the possibility of orphaned users. An overview of why (and how to deal with them) is here: http://www.sqlservervideos.com/video/copying-and-moving-sql-server-logins/ – Michael K Campbell Sep 24 '10 at 19:17