For inter-server copying to work the target server must be declared as a linked server to the source server. The following describes how to do this:

General
Select SQL Server as the server type. Select the server options Data access, RPC and RPC out.
Security
Select no security context will be used only. Note that the Local login and Remote user columns refer to the login names of the SUN SuperUser on each server; this is normally SUN.

The linked server is now configured.

To confirm that the linked server is set up correctly you can attempt to query on the source server's SunSystems tables manually in Query Analyser. The query is in the form:

SELECT * FROM [server name] . [database name] .dbo.[table name e.g. DB_DEFN]

Before running BUCOPY for inter-server copying you must ensure that the Distributed Transaction Co-ordinator service (MS DTC) has been started on the source server (Enterprise Manager\SQLServerGroup\SupportServices).

For inter-server coping to work an Oracle Database Link of a Fixed User type must exist between the target and source server.

The following describes how to do this:

Connect to your target Oracle instance with SQL*PLUS logging in as the target SunSystems SuperUser and enter the following, where ‘ORAPROD’ is the name of your Source Instance and ENG is the name of your source SunSystems SuperUser, and ENGPSWD is the password.  You must have an equivalent Net8 connection from the Target to Source Server.

CREATE DATABASE LINK ORAPROD CONNECT TO ENG IDENTIFIED BY ENGPSWD USING ORAPROD

The Database Link is now configured.

To confirm that the Database Link is active you can attempt to query the source servers tables:

SELECT * FROM [Table Name]@[Database Link Name]

i.e. SELECT * FROM DB_DEFN@ORAPROD.

Launch DBA Studio or Enterprise Manager. Connect to the Target database as the SunSystems SuperUser. Expand Schema Expand the SunSystems SuperUser Schema Select Database Links From the Object menu select Create… then from the pop-up select Database Link then create.

Name: The Name of the database link, which should be the name of your source instance.

Connection Details: Fixed User

User Name: The name of the SunSystems SuperUser on the Source instance

Password: The password for the above

Service Name: The Net Service Name you have created whish should match Name: above.

The Database Link is now configured

To confirm that the Database Link is active you can use the Test button.

Select the link in DBA*Studio or Enterprise Manager then Select the Test Button.