global statements
SOURCE systema;
TARGET local;
DETAIL;
REPLACE;
REG_COPY;
KEEPREGTAG;
CREATEXMAPS;
SELECT DBTYPE=MSS DBID=CAPT123;
MODIFY NEW_DBID=CAPTUR2,MSSOPTS=(DBSERVER=ABC188888\server2,DBNAME=capture2);

The REG_COPY statement copies the registrations.
The CREATEXMAPS statement generates the extraction maps.
The SELECT statement must contain DBTYPE=MSS to identify the source type as Microsoft SQL Server.
The MODIFY statement contains the NEW_DBID and MSSOPTS parameters for this example:
The NEW_DBID parameter specifies the optional user-defined instance identifier for the database server and database name that are defined in the MSSOPTS parameter. This instance identifier has a maximum length of seven characters. You can enter only one unique instance identifier for a database server and database name combination. If you are migrating from one environment to another, you can enter an instance identifier that matches the instance identifier in the source system. In this manner, you can avoid using a generated instance identifier and having to update the extraction map names in PowerCenter workflows and edit the PowerExchange Logger DBID parameter value on the target.
The MSSOPTS parameter identifies the SQL Server database server and database name.