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
 General SQL Server Forums
 New to SQL Server Programming
 Install SQL Exp/Create a database during deploymt

Author  Topic 

sqlbug
Posting Yak Master

201 Posts

Posted - 2009-11-26 : 13:26:50
I need to deploy a .NET 2.0 windows application so if no SQL Server found on the network, it will allow them to install SQL Express.

If there is SQL Server, then it will allow them to create a database with some baseline data.

Really need help on this,
Thanks.

sqlbug
Posting Yak Master

201 Posts

Posted - 2009-11-27 : 14:29:39
basically, my concern is - to create a database with 30/40 tables with some data in some of them - the sql statements would be large. What would be the best approach to deal with it?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-11-27 : 15:13:24
Personally I'd have a user prompt that would ask if they have a SQL Server already and if not to install SQL Express.

I'd use sqlcmd to run your script files after SQL Server has been installed.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

sqlbug
Posting Yak Master

201 Posts

Posted - 2009-11-27 : 17:25:09
Thanks Tara,
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-11-27 : 18:33:23
You're welcome.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page
   

- Advertisement -