Install SMO or Alternative? - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Install SMO or Alternative?

Message

From

14/03/2011 22:11:33

Gunnar Philipp
Texas, United States

To

14/03/2011 18:56:41

Michel Fournier
Level Extreme Inc.
Petit-Rocher, New Brunswick, Canada

General information

Forum:

ASP.NET

Category:

Databases

Title:

Re: Install SMO or Alternative?

Environment versions

Environment:

VB.NET 1.1

OS:

Windows XP SP2

Network:

Windows 2003 Server

Database:

MS SQL Server

Application:

Desktop

Miscellaneous

Thread ID:

01503651

Message ID:

01503675

Views:

29

>>So, here are my questions:
>>

how to install "only" SMO manually?
>>

is there an alternative and/or a better way to accomplish the above tasks?
>
>I had to install SMO manually to support SQL Server 2008 specific functionalities for SQL Server 2005. So, yes, there is a setup file availabe for that component only. You might want to define your setup to make sure it installs that component prior to the rest of your setup which depends on it.

Hi Michel

Thanks for your reply.

One of the thoughts I had are as follows:
The end-user inserts the CD which has all the different installation components, such as iis setup, workstation install, sql install (or existing selection), etc.

The user has the option to use an existing SQL instance or to install a new express instance. For this i must search the network and 'offer' all the different options (also existing database selection for enterprise interface to my app).

I think it would be 'dumb' to have to install SMO just so that i can show the user the different options. And then he might choose to use an existing sql, which means we just installed smo on a machiene which he/she didn't really need.

what are your thoughts on that?

Click here to load this message in the networking platform