Edit

Create the SQL Server Change Database

  • Article

Important

Change Data Capture for Oracle by Attunity is deprecated now. For details, refer to the announcement.

When you start the New Instance wizard, the Create CDC Database page opens. Use the Create CDC Database page to provide information about the new CDC instance and create a new Change database.

When you create a new CDC database it is enabled for SQL Server CDC and this enablement requires a login that is a member of the sysadmin fixed-server role.

When a user that starts the Create an Oracle CDC Instance wizard is not a member of the sysadmin fixed-server role, the Connect to SQL Server dialog box opens and requests the credentials for a member of the sysadmin role to carry out the Enable the database for SQL Server CDC task. When the CDC database is created, the sysadmin login is discarded and work resumes with the original SQL Server login used when the Oracle Designer Console was entered.

Important

For tasks other than Enable the database for SQL Server CDC of, the SQL Server login used for running the New Instance Wizard must have the dbcreator fixed-server role and UPDATE permissions on the MSXDBCDC database.

For information on entering the data in the Connect to SQL Server dialog box, see SQL Server Connection for Instance Creation.

Options

Oracle CDC Instance
Type the following information about the CDC instance you are creating.

  • Name: Type a name for the new service. This will also be the name of the new Change database.

  • Description: Type a description for the new instance to help you identify it. This is optional.

SQL Server Change Database
This section is used to create the database.

  1. Change Database: The name of the new Change database. The name of the database is the same as the name that you gave to the instance. This read-only field displays the full path to the database.

  2. Create Database: Click Create Database to create the database.

    To create the database, the login must have the sysasmin server role. See the security note above for more information.

    After you create the database, you can click Next to Connect to an Oracle Source Database.

See Also

How to Create the SQL Server Change Database Instance
The Oracle CDC Service