Deploy Application With Database
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 !
Re: Deploy Application With Database
Either you deploy an empty database file or the SQL to create the file then execute the SQL.
Re: Deploy Application With Database
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 !
Re: Deploy Application With Database
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.