Deploy Application With Database

[killer7k]

Hi ,

I have done an application using vb.net 2003 & I have database in SQL server 2000 ,

I connect to the sql database using
Data Source=(local);database=MyBase

so i need when i deploy my application

It will create this database

i dont know how can i get the database from SQL server 2000
when i have the installation ?


Thanks !

[randem]

Either you deploy an empty database file or the SQL to create the file then execute the SQL.

[killer7k]

Hi randem ,

I dont know exactly if that what i need

let's say i the database in SQL Server 2000 & i have a Application or Website That use this query

what i need is during the deployment of the project to save the database with it

Thanks !

[randem]

That uses what query???? We are talking about deployment, correct? Usage is something entirely different.

For deployment:

• Export the Create SQL for the database thru the SQL Server Interface. This will be the SQL script that you use to create your database on the target system.

• Create an Empty database on your development system. Back it up. Deploy the backed up database. Thru the SQL Server Interface you restore the database on the target system.