deploying a database

Hi, do you know how to deploy a database (along with all the tables and data
in them etc.) from a development machine to the target machine? Can I just
copy the dabase file? (Assume the SQLServer application is already
installed on the target machine)
Thanks!Backup/restore,
Detach/Attach.
Either should work just fine
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Ido" <Ido@.discussions.microsoft.com> wrote in message
news:29EA6106-1D43-4B19-89F5-B2A438DA6B8F@.microsoft.com...
> Hi, do you know how to deploy a database (along with all the tables and
> data
> in them etc.) from a development machine to the target machine? Can I just
> copy the dabase file? (Assume the SQLServer application is already
> installed on the target machine)
> Thanks!|||http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.databasejournal.com/feat...cle.php/3379901 Moving
system DB's
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scr...sp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"Ido" <Ido@.discussions.microsoft.com> wrote in message
news:29EA6106-1D43-4B19-89F5-B2A438DA6B8F@.microsoft.com...
> Hi, do you know how to deploy a database (along with all the tables and
> data
> in them etc.) from a development machine to the target machine? Can I just
> copy the dabase file? (Assume the SQLServer application is already
> installed on the target machine)
> Thanks!