Step 1 - Describe Databases

Owned by Arjen Visser
Last updated: Apr 21, 2014 by Chris Lawless (Deactivated)
2 min read

The following settings are available in "Step 1 - Describe databases" of the setup wizard.

Oracle

What type of database is this? (Oracle/MySQL/MSSQL/Oracle AWS RDS/Hadoop/CSV): 

Select the database type. The choices are:

  • Oracle (can be source and target database)
  • MySQL (can only be target database)
  • Microsoft SQL Server (can only be target database)
  • Amazon Web Service RDS (can only be target database)
  • Hadoop (can only be target database)
  • Comma Separated Value (can only be target)
Please enter database TNS alias

Specify the TNS alias used to connect to this database (Oracle only).

Please enter SYSDBA user name: [SYS]

Specify the sysdba user name (Oracle only). 

Please enter password for this user

Specify the password for the SYSDBA user (Oracle only).

Please enter user with DBA role

Specify the DBA user name (Oracle only). 

Enter the Dbvisit Replicate owner and apply user (this user will be created by this script): [dbvrep]

A Dbvisit Replicate repository will be created in this database. This is the database username that will own this repository.

Please enter password for this user: [dbvpasswd] 

Specify the password for the Dbvisit Replicate repository user.

Please enter default permanent tablespace for this user

Specify the default tablespace of the Dbvisit Replicate repository user.

Please enter default temporary tablespace for this user

Specify the temporary tablespace of the Dbvisit Replicate repository user.


MySQL
Please enter database hostname: [localhost] 

Enter the database hostname (MySQL only)

Please enter user name of an administrator: [root]

Enter the user name of the the administrator (MySQL only)

Please enter password for this user

Enter the password for the MySQL administrator (MySQL only)

Enter the database user to log into apply database: [root]

Enter the username that logs into the target or apply database. 

Enter the database (schema) to use for Dbvisit Replicate internal data (will be created in the script): [dbvrep]

A Dbvisit Replicate repository will be created in this database. This is the database username that will own this repository.


Microsoft SQL Server

Please enter database ODBC DNS

Enter the ODBC DNS (SQL Server only)

Please enter user name of an administrator: [SA]

Enter the user name of the the administrator (SQL Server only)

Please enter password for this user: [password]

Enter the password for the administrator 

Enter the user to log into apply database: [SA]

Enter the username that logs into the target or apply database. 

Please enter password for this user: [password]

Enter the password for this user

Enter the database to use: [dbvrep]

Name of the database to use.

Enter the schema the table are created by the user specified: [dbo]

Name of the schema that will hold the Dbvisit Replicate repository (the schema where tables get created by default by the new user).

Enter the database with user data:

Enter name of the MS SQL database where the replicated tables reside.

Â