Skip to content

create-the-sql-server-change-database.md

Latest commit

 

History

History
51 lines (34 loc) · 3.03 KB

create-the-sql-server-change-database.md

File metadata and controls

51 lines (34 loc) · 3.03 KB
title Create the SQL Server Change Database
description Create the SQL Server Change Database
author chugugrace
ms.author chugu
ms.date 03/14/2017
ms.service sql
ms.subservice integration-services
ms.topic how-to
f1_keywords
oraIns

Create the SQL Server Change Database

[!INCLUDE oracle-cdc-retirement]

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 [!INCLUDEssNoVersion] login used when the Oracle Designer Console was entered.

Important

For tasks other than Enable the database for SQL Server CDC of, the [!INCLUDEssNoVersion] 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