Differences

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

--- sqldata:sybase-to-sqlserver [October 28, 2012 5:26 pm]
sqlines created
+++ sqldata:sybase-to-sqlserver [November 07, 2012 9:35 pm] (current)
sqlines
@@ Line 1: / Line 1: @@
+====== SQLData Tool - Sybase ASE to SQL Server Migration ======
+SQLData is a scalable, high performance data transfer, schema conversion and validation tool for Sybase Adaptive Server Enterprise to Microsoft SQL Server and SQL Azure migration.
+The tool allows you to move and validate the migration of large volumes of data and database schema within the shortest possible time frame.
+===== Why SQLData =====
+SQLData benefits:
+**Scalability and High-Performance**
+  * Transferring tables 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
+**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 Sybase ODBC driver and ADO.NET providers required
+  * No .NET dependency
+  * No installation required
+====== SQLData Editions ======
+SQLData is available in Express, Standard, Professional and Enterprise editions:
+| |  **Express**  |  **Standard**  |  **Professional**  |  **Enterprise**  |
+| **Database Size** |||||
+| //Data Volume per Database// |  3 GB  |  10 GB  |  100 GB  |  Unlimited  |
+| //Number of Tables// |  Up to 100 |  Up to 300 |  Unlimited  |:::|
+| //Number of Rows// |  Unlimited  |  Unlimited  |:::|:::|
+| //Number of Databases// |:::|:::|:::|:::|
+| **Schema Conversion** |||||
+| //CREATE TABLE Statement// |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |
+| //NOT NULL Constraints// |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |
+| //DEFAULT Clauses// |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |
+| //CHECK Constraints// |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |
+| //Primary and Foreign Keys// |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |
+| //Unique Constraints// |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |
+| //Indexes// |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |
+| **Schema Transformation** |||||
+| //Schema Name Mapping// |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |
+| **Validation** |||||
+| //Validation by Row Count// |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |
+| **Performance and Scalability** |||||
+| //Parallel Sessions// |  Up to 2  |  Up to 4  |  Up to 8  |  Unlimited  |
+| //Concurrent Reader/Writer in Each Session// |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |
+| //Table Partitioning Support// |  {{:red_cross.png|}}  |  {{:red_cross.png|}}  |  User-defined only  |  {{:green_tick.gif|}}  |
+| //32-bit Version// |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |
+| //64-bit Version// |  {{:red_cross.png|}}  |  {{:red_cross.png|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |
+| **Automation** |||||
+| //[[/sqldata_cmd|Command Line]]// |  {{:red_cross.png|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |
+| **Licensing and Support** |||||
+| //Technical Support// |  Basic  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |
+| //Price// |  Free  |  $375  |  $975  |  $1,735  |
+If any you have any questions or need any assistance, please contact us at [[support@sqlines.com]].

SQLines Data

SQLines SQL Converter

Migration to MariaDB

Migration to MySQL

Migration to PostgreSQL

Migration to SQL Server

Migration to Oracle

SQL in Applications

Differences