Differences

This shows you the differences between two versions of the page.

sqldata:sybase-to-sql-server [March 29, 2017 12:27 pm] (current)
sqlines created
Line 1: Line 1:
 +====== SQLines Data Tool - Database Migration from Sybase ASE to SQL Server ======
 +SQLData is a scalable, high performance data transfer, schema conversion and validation tool for Sybase Adaptive Server Enterprise (Sybase ASE) to Microsoft SQL Server migration.
 +
 +  * **Sybase Adaptive Server Enterprise** 16.x, 15.x, 12.x and 11.x  
 +  * **Microsoft SQL Server** 2016, 2014 and 2012
 +
 +See also [[/sybase-asa-to-sql-server|Sybase SQL Anywhere to SQL Server Migration]].
 +
 +===== Why SQLines Data =====
 +
 +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
 +
 +You can use [[/sybase-to-sql-server|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 Client Library/C (CT-Lib) 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 version
 +
 +**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
 +
 +===== SQLines Data in Command Line =====
 +
 +You can use SQLines Data tool in command line. Just launch //sqldata.exe// on Windows with the specified options.
 +
 +For information how to define Sybase ASE and SQL Server connections, see [[/sqldata_connection|SQLines Data Connection String Formats]].
 +
 +Examples:
 +
 +  * **Transfer a single table**
 +
 +| **sqldata -t**=emp **-sd**=**sybase**,syb_user/syb_pwd@syb_host,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 ASE 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//.