Remote Database Deployment

We have an application using a SQL 2005 database which we need to deploy to a client. The only we can find of deploying the structure and the data is to perform a backup on the source server and a restore on the destination server.

Is this really the best/only way to deploy a database? I'd appreciate any pointers.

Thanks in advance

LazyGenius wrote:

We have an application using a SQL 2005 database which we need to deploy to a client. The only we can find of deploying the structure and the data is to perform a backup on the source server and a restore on the destination server.

Is this really the best/only way to deploy a database? I'd appreciate any pointers.

Thanks in advance

If you're using SQL 2005 you don't even need to backup/restore. You can just Xcopy your mdf (and optionally ldf) files and do an attach.

|||

It all seems a bit "DOS" to me but thanks for the quick reply. We have a small utility program to attach the database so I guess we'll just use that.

Thanks again

|||

Hey you asked for a better way of doing it. Think of the time that it would take to backup and restore a large database. Compare that with detaching it, making a copy, and attaching that copy on the other end.