Hello,
I want to build a set up for installation of a vb.net project with database operations. I have a sql file for the initial setting up of the DB, i need to run this sql file at the time of install , so that the DB is configured as per the requirements. Actually i need to feed in some data in the tables, prior to using the database.
I tried with new setup and deployment project, and then just added this confireDB.sql file in the project along with the normal project output. But i dont know what to do, so that at the time of installation, this configureDB.sql should run. The SQL express will be preinstalled on the network, i dont need to install that at the time of installation of this application. I only need to create the required Database, tables and fill 1 table with contents.
Please help me out. I have searched on the net with no much help.
Thanks,
ksmshsjs
I want to build a set up for installation of a vb.net project with database operations. I have a sql file for the initial setting up of the DB, i need to run this sql file at the time of install , so that the DB is configured as per the requirements. Actually i need to feed in some data in the tables, prior to using the database.
I tried with new setup and deployment project, and then just added this confireDB.sql file in the project along with the normal project output. But i dont know what to do, so that at the time of installation, this configureDB.sql should run. The SQL express will be preinstalled on the network, i dont need to install that at the time of installation of this application. I only need to create the required Database, tables and fill 1 table with contents.
Please help me out. I have searched on the net with no much help.
Thanks,
ksmshsjs
