Prepare SQL Server for Oracle CDC-View Script
Important
Change Data Capture for Oracle by Attunity is deprecated now. For details, refer to the announcement.
This dialog box shows the Prepare SQL script that creates the MSXDBCDC database. This database is must be on a SQL Server instance for it to be used with Oracle CDC for SQL Server.
Do the following in the Prepare SQL Server Script dialog box.
Save As
Saves the script in a text file that you can save in any location you want. You can then run the scripts at a later time by pasting the script into the SQL Server Management Studio.
Copy
Copies the script to the clipboard. You can then paste the script into the SQL Server Management Studio to run them and create the MSXDBCDC database.