Creating SQL table with installer.
-
Hiya I have created an installer for my c# and ado.net app, but want to create a new sql table when the installer runs, if the sql table in the database does not exist. I also need to add assemblies to the gac when the installer runs. How do I do this?? Thanks.
-
Hiya I have created an installer for my c# and ado.net app, but want to create a new sql table when the installer runs, if the sql table in the database does not exist. I also need to add assemblies to the gac when the installer runs. How do I do this?? Thanks.
[Streamline Your Database Setup Process with a Custom Installer](http://Streamline Your Database Setup Process with a Custom Installer)[^]
-
Hiya I have created an installer for my c# and ado.net app, but want to create a new sql table when the installer runs, if the sql table in the database does not exist. I also need to add assemblies to the gac when the installer runs. How do I do this?? Thanks.
I wrote my own installer, which just calls the various steps of installation in turn ( install .NET1.1, DirectX9, MSDE, etc. ) and one of those steps is a little app I wrote that uses an XML config file to specify a connection string and a sequence of .SQL files. The files it points to are the ones I used when writing the database, and the app runs them in turn, and displays any errors, and the SQL it is calling as it goes. This sets up my database, and then I run the installer for my actual applications. Christian I have drunk the cool-aid and found it wan and bitter. - Chris Maunder
-
I wrote my own installer, which just calls the various steps of installation in turn ( install .NET1.1, DirectX9, MSDE, etc. ) and one of those steps is a little app I wrote that uses an XML config file to specify a connection string and a sequence of .SQL files. The files it points to are the ones I used when writing the database, and the app runs them in turn, and displays any errors, and the SQL it is calling as it goes. This sets up my database, and then I run the installer for my actual applications. Christian I have drunk the cool-aid and found it wan and bitter. - Chris Maunder
Hi I now have my sql script which generates the database and tables. I have my setup project and added a custom action for the script. But the script will not run when being installed.. Help!!
-
Hi I now have my sql script which generates the database and tables. I have my setup project and added a custom action for the script. But the script will not run when being installed.. Help!!
I wrote my OWN installer, and run the script myself, that is, I also wrote the C# code to run the script. If you're not running your own code, I have no idea how to get an installer to run a SQL script, but I doubt just providing the script will do it. Christian I have drunk the cool-aid and found it wan and bitter. - Chris Maunder