Try now
Try now
Use Cases
Replication and data migration Zero downtime migration Logical standby Zero downtime upgrade Distributed clusters ''Real Time'' reporting systems and Business Intelligence
Support
Current Feature Set Documentation Professional Services Roadmap
Company
About Us Contact Us Become a Partner News Updates
Try now
Try now
Home / Repstance User Guide / DATABASE CONFIGURATION COMMANDS / Prepare Target Database / SQL Server as Target

SQL Server as Target

These parameters are used by prepare, validate and remove with database=target dbtype=mssql (see Prepare Target Database, Validate Database and Remove Repstance Objects from Database). The login that is given in user needs the privileges that are described in Database Privileges.

Parameters

ParameterDescription
databasetarget. Required.
dbtypemssql. Required.
generatesql1 makes prepare return the SQL script and change nothing. The default is 0: prepare creates the objects. validate does not use the parameter, and remove removes the objects whatever its value.
serverThe host name or the IP address of the SQL Server. Required.
portThe TCP port of the SQL Server, usually 1433. Required.
userThe login that Repstance connects with. Required.
passwordThe password of the login. Required.
dbnameThe database to prepare: the schema repi with the checkpoint tables is created in it. Give it always: without dbname the default database of the login is used, which is often master.

Examples

A database that is not prepared:

repcli validate database=target dbtype=mssql server=db-tgt.example.com port=1433 dbname=testDB user=repuser password=Passw0rd123
[Invalid]: Database is not prepared for apply: [repi schema does not exist: 1]

A prepared database:

repcli validate database=target dbtype=mssql server=db-tgt.example.com port=1433 dbname=testDB user=repuser password=Passw0rd123
[Valid]: Database TESTDB is valid

The script that prepare returns with generatesql=1 is shown in Prepare Target Database.

Web UI

The form “Database Settings” of an Apply Process for SQL Server has the fields “Server”, “Port”, “Username”, “Password” and “Database Name” (the list shows the databases of the server). “Copy Settings” takes the connection data of a process that exists already:

Web UI, Database Settings: empty target connection form for SQL Server
 

Fill in the form and click “Test connection”. The buttons that prepare the database are shown in Prepare Target Database:

Web UI, Database Settings: filled target form with the Test connection button highlighted
 
 
On this page
Parameters
Examples
Web UI