[02/03] [2005] How can I Attach the database during the deployment of my WebSite

Hello ,

I need to attach my Database during the Deployement
I am using a sql server 2000 database

i am connecting to the sql database using

Data Source=(local);Database=myBase


Thanks !

Explain 'attach', are you using an MDF? And are you deploying to a web host that isn't under your complete control?

I am using a local sql server 2000 database
when i go to deploy my WebSite
I found WebSite1.msi & Setup.ini & Setup.exe

but the database is not there

how can i add the database ?

does the appSettings anything to do with this ?

Use Sql Server Management Studio and generate a script for your database, then run it against the target database. Or, take a backup of your local database and restore it against the live database.

Quote:

---

Originally Posted by mendhak

Use Sql Server Management Studio and generate a script for your database, then run it against the target database. Or, take a backup of your local database and restore it against the live database.

---

hi mendhak ,

dont know exactly what do you mean

can i copy the database from SQL server 2000 during the deployement ?

Thanks !

I'll try to make it clearer. Are you deploying to a web host or to a remote machine that you have full control over?