SQLines Data is a high performance data transfer, schema conversion and validation tool for Sybase SQL Anywhere (Sybase ASA) to Microsoft SQL Server migration.
SQLines Data benefits:
Migration Features
You can use SQLines SQL Converter tool to convert stored procedures, functions, triggers, views and other objects.
Scalability and High-Performance
Designed for DBAs and Enterprise-Class Migrations
You can use SQLines Data tool in command line. Just launch sqldata.exe on Windows or .sqldata on Linux with the specified options.
For information how to define Sybase ASA and SQL Server connections, see SQLines Data Connection String Formats.
Examples:
./sqldata -t=emp -sd=asa,syb_user/syb_pwd@sample_db -td=sql, sql_user/sql_pwd@server_host\instance,sql_db
-t option defines the table name, -sd and -td options (source and target databases) specify the connection strings for Sybase ASA and SQL Server, respectively.
This command transfers table emp from Sybase sample_db database to SQL Server sql_db database located on server_host\instance.
./sqldata -t=* -cmd=transfer -topt=truncate -sd=asa,syb_user/syb_pwd@sample_db \ -td=sql, sql_user/sql_pwd@server_host\instance,sql_db
In this example -topt=truncate option specifies loading into existing tables truncating data before import.
./sqldata -t=* -cmd=validate -vopt=rows -sd=asa,syb_user/syb_pwd@sample_db \ -td=sql, sql_user/sql_pwd@server_host\instance,sql_db
In this example -cmd=validate -vopt=rows options allows you validating the data transfer.