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

1 Answer 1

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.

2

You must log in to answer this question.

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