I have a VB.NET program that uses SQL DMO to setup the SQL Server for replication, create the publication with all the articles and start the snapshot creation. With SQL 2008 R2, DMO is unavailable (at least with SQL 2008 there was a backwards compatibility
package that i could load to get it).
I have read that SMO was available in SQL 2000-2005 and i know there were some differences, but i am only using it for the replication setup. Then i saw some in the BOM about RMO.
I am a little confused about the RMO - is that just a sub-set of SMO?
My BIGGEST concern is that i write something and it works perfectly on R2 but fails on 2008 or 2005 (since we still have customers using those versions).
Can anyone point me somewhere that talks about changing from DMO replication setup to SMO/RMO.
View Complete Post