How to copy MSSQLServer Database automated from one server to another

Question

I would like to copy one database (almost all tables) to another server. So far we have done this using the standard MSSQL wizard. We would like to include this work into an automated build we have with ant. I have found one command line tool: http://dbcopytool.codeplex.com/ Any better ideas?

Answer 1

Though I've not done this with Ant, I have done all of this with NAnt (and the links below are for Ant).

I would use the Sql task to issue a backup command, then a Apply/ExecOn command to issue the backup copy to the new server (Or the Copy task) , and then another Sql task to issue the restore on the new server.