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
Home
/
Repstance User Guide
/
DATABASE CONFIGURATION COMMANDS
/
Prepare Target Database
/
SQL Server as Target
SQL Server as Target
General Parameters
database
– The only appropriate value is
target
dbtype
– The appropriate value is
mssql
generatesql
– This parameter to identify if database objects are to be created (0 - value, default), or the only SQL script creating the objects to be generated (1 value).
Database Connectivity
server
– Host name or IP address of the database server
port
– Database port
dbname
– Database name
user
– Database User name
password
– Database User password
Prev page:
Oracle as Target
Next page:
PostgreSQL as Target
Repstance User Guide
ABOUT REPSTANCE
SUPPORTED DATABASE REQUIREMENTS
GETTING STARTED WITH REPSTANCE
Getting Started with Repstance in Amazon Web Services
Getting Started with Repstance in Microsoft Azure
Getting Started with Repstance in On-Premises
INTERACTING WITH REPSTANCE SERVER
Command Line Interface (CLI)
Fully Interactive Mode
Command Mode
Configure repcli for Remote Access
Web User Interface (Web UI)
REST API
CONFIGURE REPLICATION WITH REPSTANCE
Basic Replication Configuration
Initial Data Migration
Multi-Target Replication Configuration
BI-Direction
Objects and Data Transformation
DATABASE CONFIGURATION COMMANDS
Prepare Source Database
SQL Server as Source
Oracle as Source
Prepare Target Database
Oracle as Target
SQL Server as Target
PostgreSQL as Target
MySQL as Target
Snowflake as Target
Redshift as Target
Validate Database
Remove Repstance Objects from Database
PROCESS CONFIGURATION COMMANDS
Prepare Capture Process
SQL Server Capture Parameters
Oracle Capture Parameters
Overview of Data Capturing Methods for Oracle Database
Capture Objects Specification
Initial Load
Prepare Apply Process
SQL Server Apply Parameters
Oracle Apply Parameters
PostgreSQL Apply Parameters
MySQL Apply Parameters
Snowflake Apply Parameters
Redshift Apply Parameters
AWS S3 Apply Parameters
Objects Filtering
Alter Process
Validate Process
Show Process
Remove Process
Objects Mapping and Possible Transforms
PROCESS CONTROL COMMANDS
Run any Capture or Apply Processes
Stop any Capture or Apply Processes
Status of any Capture or Apply Processes
Reset Apply Process
Report Process
REPSTANCE WEB USER INTERFACE
Database Configuration
Oracle Database Configuration
SQL Server Database Configuration
PostgreSQL Database Configuration
MySQL Database Configuration
Redshift Database Configuration
Snowflake Database Configuration
Process Configuration
Create Capture Process
Create Apply Process
Modify, Validate or Remove Processes
Processes Monitoring and Maintenance
Wizard Mode
REPSTANCE SERVER MAINTENANCE
How to Start Repstance Services
How to Check Repstance Service Status
How to Stop Repstance Services
Backup Repstance Files
Housekeeping
GLOSSARY
On this page
General Parameters
Database Connectivity
Contact us
Full name
Phone
Email
Write your message here
Send
Message sent
We have received your message and will reply to
it as soon as possible.
Close
Request a Demo