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

[killer7k]

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 !

[mendhak]

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

[killer7k]

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 ?

[killer7k]

does the appSettings anything to do with this ?

[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.

[killer7k]

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 !

[mendhak]

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?