1. | What are the key SMO assemblies that need to be referenced in an SMO application? |
|
2. | How do you connect to a server using logon credentials? |
|
3. | What namespace is used by RMO to create an application that works with replication objects? |
|
4. | What function must be performed regardless of the type of replication you are using? |
|
5. | What are the main objects that can be used in an AMO application? |
|
6. | In an AMO application, what four objects are used to connect to a database? |
|
7. | What assembly enables you to connect to a client using ADOMD.NET? |
|
Answers
1. | For most SMO applications, you will need to reference the following assemblies:
|
2. | To connect to a server using logon credentials, you will need to set a reference to the Microsoft.SqlServer.ConnectionInfo assembly and a directive to the Microsoft.SqlServer.Management.Common namespace. You then specify the logon credentials using the ServerConnection object. |
3. | Even though there are two assemblies used in RMO applications, Microsoft.SqlServer.Replication and Microsoft.SqlServer.Rmo, there is only one namespace directive that you need to add to your code: Microsoft.SqlServer.Replication. |
4. | Regardless of what type of replication you are performing, you need to specify a publisher and a distributor. You also need to specify the publisher and distributor databases. |
5. | The main objects in an AMO application are Cube, Dimension, and MiningStructure. You will need to use the Server and Database objects to get to these objects. |
6. | To connect to a database with an AMO application, you need the Server and Database objects mentioned in the previous answer. You will also need DataSource and DataSourceView objects. |
7. | To connect to a client using ADOMD.NET, you will set a reference to the Microsoft.SqlServer.AdomdClient assembly. For server-based applications, you will use the Microsoft.SqlServer.AdomdServer assembly. |