SQLines Data - Sybase ASA to SQL Server Migration

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

• All Data Types
• NOT NULL Constraints
• DEFAULT Clauses
• CHECK Constraints
• Primary and Foreign Keys
• Unique Constraints
• Indexes
• Comments on Tables and Columns
• Schema Name Mapping
• Validation by Row Count
• Validation by Row Content

You can use SQLines SQL Converter tool to convert stored procedures, functions, triggers, views and other objects.

Scalability and High-Performance

• Transferring data in multiple concurrent sessions
• Performing concurrent read and write operations in each session
• Using Sybase ODBC Library with array processing to extract data from Sybase
• Using SQL Server Native Client Bulk Copy API to insert data to SQL Server
• C/C++ application, 32-bit and 64-bit
• Microsoft Windows and Linux versions

Designed for DBAs and Enterprise-Class Migrations

• Easy to set up and configure the transfer of a large number of tables
• Command line with powerful and easy to use options
• Wildcards to select tables
• Comprehensive performance stats to help you tune the data transfer
• No space required to hold Sybase export
• No .NET data access providers required
• No JDBC
• No installation required

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:

• Transfer a single table

./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.

• Load into existing tables with truncation

./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.

• Validate the data transfer

./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.