SQL Server 205 - SQL DMO

[cwhitehe]

Is there a plan to have an SQL DMO redistributable for SQL Server 2005?

[Chandima]

I think this comes built in to the setup. Here is my test case:

1. Create a Basic Msi setup.
2. Add a SQL Script.
3. Build.
4. Copy setup to a clean machine that doesn't have any SQL 2005 "stuff" (drivers, files, etc - A clean Win 2K for example).
5. Run the setup.
6. On the SQL browse dialog, browse to and select a valid SQL 2005 Server, and complete install.
7. Verify that that the database was installed on the server.

If the above works, my assumption is that the setup includes the SQL 2005 DMO (otherwise it can't communicate with the 2005 database).

Is this what you are referring to?

[cwhitehe]

I don't need the SQL DMO as part of the installation (I'm not using the SQL Script facility in InstallShield)

Our application itself uses SQL DMO. Therefore I would like the distribute the SQL DMO DLL's and install them onto the clients machine for use with our program.

Therefore I was just enquiring whether there was going to be a redistributable that can be added to my project.

[Ryan A]

SQL-DMO for 2005 requires a special backward compatible redistributable. There's a quick description and a link to the redistributable here:

http://blogs.msdn.com/mwories/articles/dmofaq.aspx

[hidenori]

At this time, you can create your own setup prerequisite that installs the Microsoft SQL Server 2005 Backward Compatibility Components (SQLServer2005_BC.msi). I filed the work order #IOC-000043872 so that InstallShield will provide the redistributable in a future release.

Thank you for reporting this.