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.

 All Forums
 Development Tools
 ASP.NET
 How to include MSDE to a web setup project

Author  Topic 

saglamtimur
Yak Posting Veteran

91 Posts

Posted - 2003-11-16 : 15:21:24
Hi,

I have a web project and would like to make a web setup project (using Visual Studio 2003) which inludes MSDE. What I want to do is, executing MSDE installation during this setup and after installation, executing some stored procedures. Any ideas?

Thanks in advance

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2003-11-16 : 19:57:10
I overheard a conversation at the PASS Summit last week that basically said installing these together was problematic and that it was better to install MSDE first and then install your app and execute your scripts. You can use osql to execute scripts from the command line. This is something MS says they're addressing with Whidbey.

--------------------------------------------------------
Visit the SQLTeam Weblogs at [url]http://weblogs.sqlteam.com[/url]
Go to Top of Page

mohdowais
Sheikh of Yak Knowledge

1456 Posts

Posted - 2003-11-17 : 01:29:04
You could use the Merge modules provided with the SQL server DB to install MSDE during the installation process, though MS no longer recommends this. The following links might help:

http://www.installsite.org/pages/en/msi/msm/msde2000.htm
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_8yeq.asp

Owais


Where there's a will, I want to be in it.
Go to Top of Page
   

- Advertisement -