Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2007-02-15 : 09:21:15
|
| venugopal.P writes "How to packaging & deploying the sqlserver2000 databaseI create my own database and create number of tables under that database. I want to package this database in to CD-ROM. when i put this CD in the CD-DRIVE then the databse is installed in sqlserver2000 database." |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-02-15 : 12:30:02
|
| You can do it three ways.1. Make a backup and put the backup on the CD, with a script to restore the backup.2. Detach the database, copy the database and log files to the CD with a script to attach the files.3. Generate a script to create the entire database (right-click the database in Enterprise Manager and select All Tasks/Generate SQL Script).1 and 2 are best if you want to copy the database including the data that is already in the tables. 3 is best if you want to create a new empty database. |
 |
|
|
|
|
|
sqlserver2000