locked
SQL Server 2008 R2 Replication Management Objects sql_rmo.msi ?? RRS feed

  • 问题

  • Hi everyone,

     

    I wonder why there is no sql_rmo.msi available for SQL Server 2008 R2 ?

    There was one in the 2008 feature pack, but it disapeared in 2008 R2 feature pack...

    We developped a replication-aware program, so we use RMO, but it's only an optional feature. We don't want to deploy a SQL Server 2008 R2 instance on every single workstation.

    Moreover, our TFS Build Server doesn't have any SQL Server installed, and the build process failed because of the missing Microsoft.SqlServer.Replication.dll assembly... can't we just install these assemblies, like we used to ?

     

    Thank you

    Christophe

    2011年2月25日 9:09

答案

  • I think you can just copy that assembly dll to your library.

    If you think my suggestion is useful, please rate it as helpful.
    If it has helped you to resolve the problem, please Mark it as Answer.

    Sevengiants.com
    2011年2月25日 14:21

全部回复

  • RMO should be coming with your .NET?

    http://msdn.microsoft.com/en-us/library/ms146869.aspx

     


    If you think my suggestion is useful, please rate it as helpful.
    If it has helped you to resolve the problem, please Mark it as Answer.

    Sevengiants.com
    2011年2月25日 11:14
  • RMO is part of SqlServer installation and located in

    C:\Program Files (x86)\Microsoft SQL Server\100\SDK\Assemblies

     

    you mean my project should copy and deploy by itself the appropriate Microsoft.SqlServer.Replication.dll assembly ?

    what redistributables ?

    what about our build server ?

    2011年2月25日 12:51
  • KriX

     

    I am sorry that I haven't got VS environment at hand at the moment, however, but reading the document, that :

    The RMO namespace is Microsoft.SqlServer.Replication , and it is implemented by the Microsoft.SqlServer.Rmo.dll, which is a Microsoft .NET Framework assembly.

    I'd think you can try to see whether it exists or not on your build server which doesnt have MSSQL installed but may have .NET framewrok installed.

     

    This section describes how to start a simple RMO project using Microsoft Visual Studio.

    To create a new Microsoft Visual C# project

    1. Start Visual Studio.

    2. On the File menu, click New Project. The New Project dialog box appears.

    3. In the Project Types dialog box, select Visual C# Projects . In the Templates pane, select Windows Application .

    4. (Optional) In Name , type the name of the new application.

    5. Click OK to load the Visual C# Windows template.

    6. On the Project menu, select Add Reference item. The Add Reference dialog box appears.

    7. Select the following assemblies from the list on the .NET tab, and then click OK .

      • Microsoft.SqlServer.Replication .NET Programming Interface

      • Microsoft.SqlServer.ConnectionInfo

      • Replication Agent Library


    If you think my suggestion is useful, please rate it as helpful.
    If it has helped you to resolve the problem, please Mark it as Answer.

    Sevengiants.com
    2011年2月25日 14:20
  • I think you can just copy that assembly dll to your library.

    If you think my suggestion is useful, please rate it as helpful.
    If it has helped you to resolve the problem, please Mark it as Answer.

    Sevengiants.com
    2011年2月25日 14:21