Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqldba2k6
Posting Yak Master
176 Posts |
 Posted - 2007-07-31 : 10:06:18
|
| I have designed a desk top application using VB.net 2003 and I have to now create a setup package for installation at client place. I want to include the SQL scripts as well in the setup package and run them automatically after the application is installed using the setup file. Can anyone assist me how to do that. |
|
|
rudesyle
Posting Yak Master
110 Posts |
Posted - 2007-07-31 : 12:43:02
|
| You'll want to create a setup project in Visual Studio. You'll add your desktop app to the output. I would think the sql script could get a little tricky, but basically you would want to add a custom task that can execute a batch (.bat) file. From there, you can run oSql commands (look in Books online) to execute your sql scripts. |
 |
|
|
rudesyle
Posting Yak Master
110 Posts |
Posted - 2007-08-01 : 11:41:54
|
| Forgot to mention that there's an installer class that you can use as well. This allows you to do whatever you want programmtically. Here's an article that describes it http://www.codeguru.com/Csharp/.NET/net_security/encryption/article.php/c9601/ |
|
|
|
|
|
|
setup issue