Hi,

If let's say i have completed a vb6 project, interacting with sql server 2000 DB. I wonder if there is any tools available that i can use to compile the DB file (with triggers and stored procedure) together with the vb project file in a package for deployment to other user.

Please advise.

Thanks!

It is possible but they will need to have a licensed copy of SQL server. Then to attach your files your program will need Admin access (if you are automating). However, you can decrease the size of the install package by scripting your database to a text file. Then end user could run the script or you could if the user gives your program Admin privledges.


Good Luck