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#?

1 Answer 1


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.


You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .