https://www.sqlines.com/ 2026-04-28T19:43:56+00:00 https://www.sqlines.com/ https://www.sqlines.com/lib/images/favicon.ico text/html 2025-06-21T18:40:29+00:00 https://www.sqlines.com/about?rev=1750531229&do=diff SQLines provides tools to help you migrate databases and applications on-premise and cloud. There are more than 100,000 unique users (in last 12 months) around the world who use our migration tools. Among our partners and customers: * MariaDB * Oracle * SingleStore * DBS Bank Singapore * T-Systems * Wells Fargo Bank * UBS * Chevron * Macy's * The United States Department of Homeland Security * US Navy * American Airlines * Cognizant * Capgemini * Wipro * Inf… text/html 2012-08-09T10:00:36+00:00 https://www.sqlines.com/application-testing?rev=1344506436&do=diff Application Testing Methodology and Process When you migrate Oracle databases to SQL Server, in most cases you also have to convert embedded SQL statements in your applications written in Java, .NET, PowerBuilder, C/C++ or other languages. Application testing is one of the most important phases of a migration project, and usually several testing approaches are applied to increase the testing coverage and quality: text/html 2012-05-13T08:32:49+00:00 https://www.sqlines.com/assessment?rev=1336897969&do=diff It is important to gather appropriate information about the migration project to * Understand the current system architecture, workload, performance, security and availability requirements * Identify the migration complexity, scope, cost and time, ROI * Discover critical and challenging issues, dependencies * Define best practices and guidelines to follow * Plan the migration text/html 2020-11-21T20:39:18+00:00 https://www.sqlines.com/case-studies?rev=1605991158&do=diff Case studies for some migration projects performed by the SQLines team. An U.S. Government Agency We provided services to migrate IBM DB2 database including stored procedures and triggers from to Oracle database. One of the Largest Banks in Asia SQLines team helped with migration of IBM DB2 and Oracle corporate databases to MariaDB. text/html 2025-03-05T14:42:14+00:00 https://www.sqlines.com/cfg?rev=1741185734&do=diff You can run SQLines SQL Converter tool from a command line, and this article describes the configuration file options. Additionally, you can specify options in Command Line. You can use -cfg command line option to specify the location and file name for the configuration file. If -cfg option is not defined, the default configuration file is sqlines.cfg. The tool firstly tries to read it from the current directory, and if not found from the SQLines executable directory. text/html 2026-01-10T18:44:33+00:00 https://www.sqlines.com/cmd?rev=1768070673&do=diff SQLines SQL Converter tool allows you to convert database schema (DDL), queries and DML statements, views, stored procedures, packages, functions and triggers between databases. SQLines converts SQL statements located in one or more files, not from a live database. You can run SQLines from a command line. Executables files are sqlines.exe and ./sqlines on Windows and Linux, respectively. text/html 2024-09-09T11:38:21+00:00 https://www.sqlines.com/cobol-to-oracle?rev=1725881901&do=diff SQLines provides tools to help you convert existing COBOL stored procedures and programs to Oracle PL/SQL. # Convert a single file ./sqlines -sl=cobol -s=db2 -t=oracle -in=cobol.cbl # Convert multiple files ./sqlines -sl=cobol -s=db2 -t=oracle -in=*.cbl -out=out_dir/ text/html 2013-09-02T13:15:21+00:00 https://www.sqlines.com/cobol?rev=1378127721&do=diff SQLines provides tools and services to help you convert existing COBOL applications to Java, C#.NET, Oracle PL/SQL and Microsoft Transact-SQL languages. * COBOL to Oracle PL/SQL For more information, please contact us at <support@sqlines.com>. text/html 2011-04-28T13:54:15+00:00 https://www.sqlines.com/command-line?rev=1303998855&do=diff You can run SQLines from a command line or shell script. Executable file is sqlines.exe on Windows, and sqlines on Linux/Unix. Any option, including user-defined options, can be specified in command line and configuration file (config.txt, by default). text/html 2025-02-19T08:48:37+00:00 https://www.sqlines.com/contact-us?rev=1739954917&do=diff If you have any questions, please contact us at <support@sqlines.com>. * Bakhtrioni 22, Tbilisi, Georgia, 0194 * Phone: +995 592-120-143 text/html 2011-02-05T11:43:53+00:00 https://www.sqlines.com/contribute?rev=1296906233&do=diff If you have developed conversion templates that may be useful for other people doing migrations, you can send them to <support@sqlines.com> All contributions will be included to the SQLines' users directory, so anyone can use them to build their custom conversion. text/html 2012-12-12T12:56:50+00:00 https://www.sqlines.com/cs?rev=1355317010&do=diff When you perform a database migration project, you have to modify your applications to work with the new database. SQLines provides tools and services to migrate embedded SQL statements and database access code between various databases in C# applications. text/html 2013-02-03T13:33:51+00:00 https://www.sqlines.com/db2-to-greenplum-tool?rev=1359898431&do=diff SQLines tool allows you to convert database schema (DDL), queries and DML statements, views, stored procedures, functions and triggers from IBM DB2 to Greenplum. SQLines converts SQL scripts and standalone SQL statements. To migrate data and database schema from an IBM DB2 database to Greenplum use SQLines Data tool. text/html 2014-09-28T20:08:26+00:00 https://www.sqlines.com/db2-to-greenplum?rev=1411934906&do=diff Technical information on migration from IBM DB2 to Greenplum. * Data Types * Built-in SQL Functions * CREATE TABLE Statement * ALTER TABLE Statement * CREATE INDEX Statement * Other SQL Statements Last Update: IBM DB2 10.1 and Greenplum 4.2 text/html 2026-04-03T06:56:59+00:00 https://www.sqlines.com/db2-to-mariadb?rev=1775199419&do=diff SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures (SPL and COBOL), functions, triggers, queries and SQL scripts from IBM DB2 to MariaDB. * SQLines Data - Data transfer, schema migration and validation tool * SQLines SQL Converter - SQL scripts assessment and conversion tool text/html 2026-04-03T06:57:11+00:00 https://www.sqlines.com/db2-to-mysql?rev=1775199431&do=diff SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from IBM DB2 to MySQL. SQLines can also assist you to convert COBOL stored procedures and programs to MySQL procedural SQL, Java, Python or any other language. text/html 2026-04-03T06:57:49+00:00 https://www.sqlines.com/db2-to-oracle?rev=1775199469&do=diff SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from IBM DB2 to Oracle. SQLines can also assist you to convert COBOL stored procedures and programs to Oracle PL/SQL or Java. text/html 2025-08-14T07:55:21+00:00 https://www.sqlines.com/db2-to-postgresql?rev=1755158121&do=diff SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from IBM DB2 to PostgreSQL: * SQLines Data - Data transfer, schema migration and validation tool * SQLines SQL Converter - SQL scripts conversion tool text/html 2023-11-13T14:39:03+00:00 https://www.sqlines.com/db2-to-snowflake?rev=1699886343&do=diff SQLines provides tools to help you convert database schema (DDL), views, queries and SQL scripts from IBM DB2 to Snowflake. * SQLines SQL Converter - SQL scripts assessment and conversion tool Databases: * IBM DB2 for LUW, z/OS and OS/400 11.x, 10.x, 9.x, 8.x and 7.x * Snowflake text/html 2026-04-22T16:07:48+00:00 https://www.sqlines.com/db2-to-sql-server?rev=1776874068&do=diff SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, SQL queries and SQL scripts from IBM DB2 to Microsoft SQL Server (MSSQL, MS SQL), Azure SQL and Azure Synapse. * SQLines SQL Converter - SQL Conversion and Assessment tool * SQLines Data - Data Transfer, Schema Migration and Validation tool text/html 2017-04-25T17:43:47+00:00 https://www.sqlines.com/db2?rev=1493142227&do=diff The reference provides technical information on IBM DB2. DB2 Configuration * Define the Database Codepage DB2 Installation Issues * DB2 Common, Cryptography - Cannot Load the Specified Library gsk8iccs.dll - DB2 10.1 on Windows 7 text/html 2026-02-07T08:51:10+00:00 https://www.sqlines.com/default_sidebar?rev=1770454270&do=diff Array SQLines Data Overview Command Line Configuration File Connection Strings Data Validation SQLines SQL Converter Overview Command Line Configuration File Migration to MariaDB IBM DB2 to MariaDB Informix to MariaDB MySQL to MariaDB Oracle to MariaDB PostgreSQL to MariaDB SQL Server to MariaDB Sybase ASE to MariaDB Sybase ASA to MariaDB text/html 2011-12-23T09:51:36+00:00 https://www.sqlines.com/doc?rev=1324633896&do=diff SQLines W SQLines W is a simple UI tool, a wrapper for the command line tool. * SQLines W - Tutorials and Screenshots * SQLines W - User's Guide SQLines Command Line * SQLines Command Line Reference text/html 2011-04-19T13:40:17+00:00 https://www.sqlines.com/donate?rev=1303220417&do=diff If you find open source tool SQLines and free migration knowledge base useful, you can donate ($20, $30, $50 etc.) to support the SQLines project. Donation payment options are credit card, PayPal, wire and check. Use the Quantity (Qty.) field in the order form to specify the donation amount. text/html 2026-03-25T14:06:45+00:00 https://www.sqlines.com/download?rev=1774447605&do=diff You can download SQLines tools: SQLines Data SQLines Data is a tool for data transfer, schema conversion and data migration validation/testing. It also convert views, stored procedures, functions, and triggers from a live database i.e. it requires a database connection. text/html 2012-10-01T12:59:58+00:00 https://www.sqlines.com/download1?rev=1349096398&do=diff Here you can download SQLines tools for various platforms. SQLines is released under open source GPL v3 license. To save your time, consider also trying Online Conversion tool to quickly review SQLines capabilities. SQLines 1.7 for Windows (32-bit, installation required) * SQLines 1.7 for Windows - 5.7 Mb, Release on December 16, 2011 text/html 2023-07-18T17:38:19+00:00 https://www.sqlines.com/hive-to-snowflake?rev=1689701899&do=diff SQLines provides tools to help you convert database schema (DDL), views, queries and SQL scripts from Apache Hive to Snowflake. * SQLines SQL Converter - SQL scripts assessment and conversion tool Databases: * Apache Hive 3.x and 2.x * Snowflake any release text/html 2022-03-09T12:30:44+00:00 https://www.sqlines.com/hive-to-trino?rev=1646829044&do=diff SQLines provides tools to help you convert database schema (DDL), views, queries and SQL scripts from Apache Hive to Trino and Presto. * SQLines SQL Converter - SQL scripts assessment and conversion tool Databases: * Apache Hive 3.x and 2.x * Presto/Trino any version text/html 2026-03-14T17:15:11+00:00 https://www.sqlines.com/home?rev=1773508511&do=diff SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures, packages, user-defined functions (UDFs), triggers, SQL queries, SQL scripts between different database platforms. * SQLines Data SQLines Data is a high performance tool that uses native database clients and can help you automate data transfer and schema conversion for major enterprise databases. More... text/html 2012-11-07T17:46:35+00:00 https://www.sqlines.com/informix-to-db2?rev=1352310395&do=diff Technical information on migration from Informix to IBM DB2. Last Update: Informix 11.7 and IBM DB2 10.1 * Data Types Data Types Converting data types: Informix IBM DB2 CHAR Fixed-length character string CHAR INT, INTEGER 32-bit integer INT, INTEGER SMALLINT 16-bit integer SMALLINT VARCHAR Variable-length character string VARCHAR text/html 2022-12-07T15:49:24+00:00 https://www.sqlines.com/informix-to-mariadb?rev=1670428164&do=diff SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from Informix to MariaDB. * Informix 14.x, 12.x, 11.x, 10.x, 9.x and 7.x (Dynamic Server IDS and Extended Parallel Server XPS) * MariaDB 10.x and 5.x text/html 2022-12-07T15:50:37+00:00 https://www.sqlines.com/informix-to-mysql?rev=1670428237&do=diff SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from Informix to MariaDB. * Informix 14.x, 12.x, 11.x, 10.x, 9.x and 7.x (Dynamic Server IDS and Extended Parallel Server XPS) * MySQL 8.x, 6.x, 5.x text/html 2022-12-07T12:22:11+00:00 https://www.sqlines.com/informix-to-oracle?rev=1670415731&do=diff SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from Informix to Oracle. * Informix 14.x, 12.x, 11.x, 10.x, 9.x and 7.x (Dynamic Server IDS and Extended Parallel Server XPS) * Oracle 21c, 19c, 18c, 12c, 11g, 10g and 9i text/html 2024-12-18T08:10:32+00:00 https://www.sqlines.com/informix-to-postgresql?rev=1734509432&do=diff SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from Informix to PostgreSQL. * SQLines SQL Converter - SQL scripts conversion and assessment tool * SQLines Data - Data transfer, schema migration and validation tool text/html 2026-04-16T18:15:56+00:00 https://www.sqlines.com/informix-to-sql-server?rev=1776363356&do=diff SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from Informix to Microsoft SQL Server (MSSQL), SQL Azure, Synapse and Fabric. * SQLines SQL Converter - SQL Scripts Conversion and Assessment tool * SQLines Data - Data Transfer, Schema Migration and Validation tool text/html 2017-04-14T23:00:40+00:00 https://www.sqlines.com/informix?rev=1492210840&do=diff The reference provides technical information on Informix and its migration to other databases. * Configure and Troubleshoot Connection to Informix How To - Database Schema * How to get next SERIAL value How To - Catalog Queries * How to define the database code page (locale) text/html 2026-02-07T08:56:00+00:00 https://www.sqlines.com/java?rev=1770454560&do=diff SQLines SQL Converter can help you convert native dynamic SQL statements in native SQL synatx, reserved words used in JPA annotations and other language elements in Java applications. To run the conversion in command line: # Convert multiple files ./sqlines -s=oracle -t=mysql -sl=java -tl=java -a -in=Project/src/main/java/*.* -out=Converted/ text/html 2012-05-14T11:44:13+00:00 https://www.sqlines.com/jdbc-driver?rev=1336995853&do=diff SQLines JDBC Driver helps you migrate existing Java applications from Oracle to Microsoft SQL Server and SQL Azure databases without source code changes. The Oracle compatibility JDBC driver can also help you automatically test the database migration at the application level as well as replicate data between Oracle and SQL Server during the transition phase of migration. text/html 2022-10-27T21:58:15+00:00 https://www.sqlines.com/like?rev=1666907895&do=diff LIKE operator allows you to search for a specified pattern in strings. LIKE supports wildcard characters. Syntax: -- Pattern matching str [NOT] LIKE pattern [ESCAPE escape_char] Example: -- Select cities with the second letter 'a' in the name SELECT * FROM cities WHERE name LIKE '_a%'; text/html 2025-02-19T09:58:20+00:00 https://www.sqlines.com/mariadb-to-mysql?rev=1739959100&do=diff SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from MariaDB to MySQL. * SQLines SQL Converter - SQL scripts assessment and conversion tool * SQLines Data - Data transfer, schema migration and validation tool text/html 2023-11-21T22:35:12+00:00 https://www.sqlines.com/mariadb-to-oracle?rev=1700606112&do=diff SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures and functions, triggers, queries, embedded SQL statements and SQL scripts from MariaDB to Oracle. Databases: * MariaDB 11.x and 10.x * Oracle 21c, 19c, 18c, 12c and 11g R2 text/html 2021-05-12T10:21:30+00:00 https://www.sqlines.com/mariadb?rev=1620814890&do=diff Technical information for MariaDB. * Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535 text/html 2025-07-21T16:56:50+00:00 https://www.sqlines.com/menu1?rev=1753117010&do=diff * Home * Why SQLines * Download * Purchase * Support * Partners * Case Studies * About * Contact Us text/html 2012-11-01T13:29:12+00:00 https://www.sqlines.com/migration-to-db2?rev=1351776552&do=diff SQLines provides tools and services to help you transfer data, convert database schema (DDL), views, stored procedures, packages, functions, triggers, queries, SQL scripts and embedded SQL from various databases to IBM DB2: * Migration from Oracle to IBM DB2 * Migration from Microsoft SQL Server to IBM DB2 * Migration from Sybase to IBM DB2 * Migration from Informix to IBM DB2 text/html 2012-10-24T19:36:59+00:00 https://www.sqlines.com/migration-to-mysql?rev=1351107419&do=diff SQLines provides tools and services to help you transfer data, convert database schema (DDL), views, stored procedures, packages, functions, triggers, queries, SQL scripts and embedded SQL from various databases to MySQL: * Migration from Oracle to MySQL * Migration from IBM DB2 to MySQL * Migration from Microsoft SQL Server to MySQL * Migration from PostgreSQL to MySQL * Migration from Sybase to MySQL * Migration from Informix to MySQL text/html 2012-12-07T19:59:16+00:00 https://www.sqlines.com/migration-to-oracle?rev=1354910356&do=diff SQLines provides tools and services to help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries, SQL scripts and embedded SQL from various databases to Oracle: * Migration from IBM DB2 to Oracle * Migration from Microsoft SQL Server to Oracle * Migration from Sybase to Oracle * Migration from Informix to Oracle * Migration from MySQL to Oracle text/html 2012-10-24T19:37:17+00:00 https://www.sqlines.com/migration-to-postgresql?rev=1351107437&do=diff SQLines provides tools and services to help you transfer data, convert database schema (DDL), views, stored procedures, packages, functions, triggers, queries, SQL scripts and embedded SQL from various databases to PostgreSQL: * Migration from Oracle to PostgreSQL * Migration from IBM DB2 to PostgreSQL * Migration from Microsoft SQL Server to PostgreSQL * Migration from MySQL to PostgreSQL * Migration from Sybase to PostgreSQL * Migration from Informix to PostgreSQL text/html 2012-11-04T08:44:13+00:00 https://www.sqlines.com/migration-to-sql-server?rev=1352018653&do=diff SQLines provides tools and services to help you transfer data, convert database schema (DDL), views, stored procedures, packages, functions, triggers, queries, SQL scripts and embedded SQL from various databases to Microsoft SQL Server and SQL Azure: text/html 2026-02-07T08:56:44+00:00 https://www.sqlines.com/mybatis?rev=1770454604&do=diff SQLines SQL Converter can help you convert SQL statements in MyBatis Mapper XML files from the source dialect to the target SQL dialect. To run the conversion in command line: # Convert multiple files ./sqlines -s=oracle -t=mysql -sl=mybatis -tl=mybatis -a -in=Project/*.xml -out=Converted/ text/html 2013-02-14T15:36:11+00:00 https://www.sqlines.com/mysql-to-db2-tool?rev=1360856171&do=diff SQLines tool allows you to convert database schema (DDL), queries and DML statements, views, stored procedures, functions and triggers from MySQL to IBM DB2. SQLines converts SQL scripts and standalone SQL statements. To migrate data and database schema from a MySQL database to IBM DB2 use SQLines Data tool. text/html 2013-02-14T15:53:45+00:00 https://www.sqlines.com/mysql-to-db2?rev=1360857225&do=diff Technical information on migration from MySQL to IBM DB2. * Data Types * Built-in SQL Functions Last Update: MySQL 5.6 and IBM DB2 10.1 MySQL to IBM DB2 Migration Tools * SQLines - Database and SQL Conversion Tool * SQLines Data - Data Transfer and Database Schema Migration Tool * Free Online SQL Conversion Tool text/html 2021-04-29T13:23:01+00:00 https://www.sqlines.com/mysql-to-hive?rev=1619702581&do=diff SQLines provides tools to help you convert database schema (DDL), views, queries and SQL scripts from MySQL to Apache Hive. * SQLines SQL Converter - SQL scripts assessment and conversion tool Databases: * MySQL 8.x and 5.x * Apache Hive 3.x and 2.x text/html 2026-01-13T15:35:09+00:00 https://www.sqlines.com/mysql-to-mariadb?rev=1768318509&do=diff SQLines tools can help you assess and convert database schema (DDL), queries and SQL scripts for MySQL to MariaDB migration. * SQLines Data - Data Transfer, Schema Migration and Validation tool * SQLines SQL Converter - SQL scripts assessment and conversion tool text/html 2024-07-01T09:22:15+00:00 https://www.sqlines.com/mysql-to-oracle?rev=1719825735&do=diff SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures and functions, triggers, queries, embedded SQL statements and SQL scripts from MySQL to Oracle. Databases: * MySQL 8.x, 5.x and 4.x * Oracle 23, 22c, 21c, 19c, 18c, 12c and 11g R2 text/html 2022-02-11T13:16:39+00:00 https://www.sqlines.com/mysql-to-postgresql-tool?rev=1644585399&do=diff SQLines tool allows you to convert database schema (DDL), queries and DML statements, views, stored procedures, functions and triggers from MySQL to PostgreSQL. SQLines converts SQL scripts and standalone SQL statements. To migrate data and database schema from a MySQL database to PostgreSQL use SQLines Data tool. text/html 2025-01-08T07:40:13+00:00 https://www.sqlines.com/mysql-to-postgresql?rev=1736322013&do=diff SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures and functions, triggers, queries and SQL scripts from MySQL to PostgreSQL (Postgres). Databases: * MySQL 8.x and 5.x * PostgreSQL 17.x, 16.x, 15.x, 14.x, 13.x, 12.x, 11.x, 10.x and 9.x text/html 2023-02-07T19:51:04+00:00 https://www.sqlines.com/mysql-to-singlestore?rev=1675799464&do=diff SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from MySQL to SingleStore. Databases: * MySQL 8.x and 5.x * SingleStore 8.x and 7.x Migration Reference * SQL Language Elements * Data Types * CREATE TABLE * CREATE PROCEDURE * CREATE FUNCTION * Procedural (SPL) Statements * SQL Statements text/html 2012-11-04T08:49:40+00:00 https://www.sqlines.com/mysql-to-sql-server-migration?rev=1352018980&do=diff SQLines provides tools and services to help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries, SQL scripts and embedded SQL from MySQL to Microsoft SQL Server and SQL Azure. Tools * SQLData - High-performance data transfer, schema conversion and validation tool * SQLines Online SQL conversion text/html 2012-11-26T13:43:44+00:00 https://www.sqlines.com/mysql-to-sql-server-tool?rev=1353937424&do=diff SQLines tool allows you to convert database schema (DDL), views, stored procedures, functions, triggers, queries, SQL scripts and embedded SQL from MySQL to Microsoft SQL Server. SQLines Features and Licensing SQLines is available in Online, Lite, Standard, Professional and Enterprise editions: text/html 2026-04-16T18:16:07+00:00 https://www.sqlines.com/mysql-to-sql-server?rev=1776363367&do=diff SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures and functions, triggers, SQL queries and SQL scripts from MySQL to Microsoft SQL Server (MS SQL, MSSQL), Azure SQL and Azure Synapse. * SQLines SQL Converter - SQL Conversion and Assessment tool * SQLines Data - Data Transfer, Schema Migration and Validation tool text/html 2017-09-30T07:18:25+00:00 https://www.sqlines.com/mysql?rev=1506755905&do=diff * Language Elements * Identifiers Language Elements SQL language elements: Single Line Comment # -- Until the end of line, -- must be followed by a space or tab Identifiers Names for database objects such as databases, tables, views, columns, indexes, triggers, procedures etc. text/html 2022-09-14T17:30:24+00:00 https://www.sqlines.com/netezza-to-redshift?rev=1663176624&do=diff SQLines provides tools to help you convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from Netezza to Amazon Redshift. SQL Server to Redshift Migration Reference * CREATE TABLE CREATE TABLE Statement Converting CREATE TABLE statement keywords and clauses: text/html 2023-03-03T16:38:21+00:00 https://www.sqlines.com/netezza-to-sql-server?rev=1677861501&do=diff SQLines provides tools to help you convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from Netezza to Microsoft SQL Server (MSSQL, MS SQL), Azure SQL and Azure Synapse. Databases: * Netezza 7.x * Microsoft SQL Server 2022, 2019, 2017, 2016, 2014, 2012, 2008 and 2005 text/html 2012-05-02T13:17:47+00:00 https://www.sqlines.com/oci-config?rev=1335964667&do=diff SQLines OCI driver has the same file name as the original Oracle OCI library oci.dll, and it has to be located in the application directory, so applications can automatically load SQLines OCI DLL instead of Oracle OCI DLL. Configuration File - sqlines_oci.ini sqlines_oci.ini is the configuration file for SQLines OCI that must be located in the same directory as the SQLines OCI DLL oci.dll (the application directory). text/html 2012-04-21T08:36:04+00:00 https://www.sqlines.com/odbc-driver?rev=1334997364&do=diff SQLines ODBC Driver for Oracle to SQL Server allows you to use your existing Oracle ODBC applications with Microsoft SQL Server and SQL Azure databases without or with minimal changes in the source code. Why SQLines ODBC SQLines ODBC driver can be very helpful in Oracle to SQL Server and SQL Azure migration project: text/html 2012-04-19T20:31:14+00:00 https://www.sqlines.com/odbc?rev=1334867474&do=diff The reference provides detailed technical information on migrating ODBC C/C++ applications from Oracle to Microsoft SQL Server and SQL Azure. Last Update: Microsoft SQL Server 2012 and Oracle 11g ODBC API Functions ODBC API functions conversion: text/html 2011-09-02T10:39:04+00:00 https://www.sqlines.com/oracle-forms?rev=1314959944&do=diff Here you can find white papers, references and articles on migration from Oracle Forms applications. Oracle Forms Migration Articles Articles on various migration related topics. * Migrating Oracle Forms to WPF using Model-View-ViewModel Pattern (Migration to .NET) * Converting Oracle Forms Files to XML * Implementing List of Values (LOV) in C# .NET * Implementing Alerts in C# .NET text/html 2024-06-14T09:20:15+00:00 https://www.sqlines.com/oracle-to-db2?rev=1718356815&do=diff SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from Oracle to IBM DB2. * SQLines SQL Converter - SQL Conversion and Assessment tool * SQLines Data - Data Transfer, Schema Migration and Validation tool text/html 2016-06-19T15:02:25+00:00 https://www.sqlines.com/oracle-to-esgyndb?rev=1466348545&do=diff SQLines provides tools and services to help you transfer data, convert database schema (DDL), stored procedures, functions, packages, queries and SQL scripts from Oracle to EsgynDB (powered by Apache Trafodion). * Oracle 12c, 11g, 10g and 9i * EsgynDB text/html 2013-03-24T18:07:59+00:00 https://www.sqlines.com/oracle-to-greenplum-tool?rev=1364148479&do=diff SQLines tool allows you to convert database schema (DDL), queries and DML statements, views, stored procedures, packages, functions and triggers from Oracle to Greenplum. SQLines converts SQL scripts and standalone SQL statements. To migrate data and database schema from an Oracle database to Greenplum use SQLines Data tool. text/html 2013-04-01T19:33:21+00:00 https://www.sqlines.com/oracle-to-greenplum?rev=1364844801&do=diff SQLines provides tools and services to help you transfer data, convert database schema (DDL), views, stored procedures, functions, packages, triggers, queries and SQL scripts from Oracle to Greenplum. * Oracle 11g, 10g and 9i * Greenplum 4.2 and 4.1 text/html 2026-02-05T15:34:07+00:00 https://www.sqlines.com/oracle-to-mariadb-compatibility?rev=1770305647&do=diff SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, packages, triggers, queries and SQL scripts from Oracle to MariaDB: * SQLines Data - Data Transfer, Schema Migration and Validation tool * SQLines SQL Converter - SQL Scripts Conversion and Assessment tool. Try Online text/html 2026-02-05T15:33:09+00:00 https://www.sqlines.com/oracle-to-mariadb?rev=1770305589&do=diff SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, packages, triggers, queries and SQL scripts from Oracle to MariaDB. * SQLines Data - Data Transfer, Schema Migration and Validation tool * SQLines SQL Converter - SQL Scripts Conversion and Assessment tool. Try Online text/html 2026-02-04T18:43:44+00:00 https://www.sqlines.com/oracle-to-mysql?rev=1770230624&do=diff SQLines tools can help you transfer data, convert database schema (DDL), views, PL/SQL stored procedures, functions, packages, triggers, queries and SQL scripts from Oracle to MySQL. * SQLines Data - Data Transfer, Schema Migration and Validation tool * SQLines SQL Converter - SQL Scripts Conversion and Assessment tool. Try Online text/html 2016-07-30T15:02:27+00:00 https://www.sqlines.com/oracle-to-netezza?rev=1469890947&do=diff SQLines provides tools and services to help you transfer data, convert database schema (DDL), views, stored procedures, functions, packages, triggers, queries and SQL scripts from Oracle to Netezza. * Oracle 12c, 11g, 10g and 9i * Netezza 7.x text/html 2013-01-18T09:37:34+00:00 https://www.sqlines.com/oracle-to-postgresql-tool?rev=1358501854&do=diff SQLines tool allows you to convert database schema (DDL), queries and DML statements, views, stored procedures, packages, functions and triggers from Oracle to PostgreSQL. SQLines converts SQL scripts and standalone SQL statements. To migrate data and database schema from an Oracle database to PostgreSQL use SQLData tool. text/html 2026-02-05T14:19:56+00:00 https://www.sqlines.com/oracle-to-postgresql?rev=1770301196&do=diff SQLines tools can help you transfer data, convert database schema (DDL), views, PL/SQL stored procedures, functions, packages, triggers, queries and SQL scripts from Oracle to PostgreSQL (Postgres). * SQLines Data - Data Transfer, Schema Migration and Validation tool * SQLines SQL Converter - SQL Scripts Conversion and Assessment tool. Try Online text/html 2023-12-07T21:37:44+00:00 https://www.sqlines.com/oracle-to-snowflake?rev=1701985064&do=diff SQLines provides tools to help you convert database schema (DDL), views, stored procedures, functions, packages, triggers, queries and SQL scripts from Oracle to Snowflake. * SQLines SQL Converter - SQL scripts assessment and conversion tool Databases: text/html 2013-01-08T14:58:08+00:00 https://www.sqlines.com/oracle-to-sql-server-cs-conversion?rev=1357657088&do=diff When you migrate an Oracle database to Microsoft SQL Server, you have to modify your applications to work with the new database. In C# applications you have to convert the syntax of SQL statements as well as ADO.NET Data Provider classes, methods and types if you use an Oracle specific provider such as Oracle.DataAccess.Client or System.Data.OracleClient. text/html 2026-04-16T18:16:19+00:00 https://www.sqlines.com/oracle-to-sql-server?rev=1776363379&do=diff SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, packages, triggers, queries and SQL scripts from Oracle to Microsoft SQL Server (MSSQL, MS SQL), Azure SQL and Azure Synapse. * SQLines SQL Converter - SQL Conversion and Assessment tool * SQLines Data - Data Transfer, Schema Migration and Validation tool text/html 2025-12-24T08:17:45+00:00 https://www.sqlines.com/oracle?rev=1766564265&do=diff * Identifiers * Built-in Functions Identifiers Names for database objects, columns, variables etc. First character Alphabetical Subsequent characters Alphanumeric, _ (underscore), # (pound sign) and $ (dollar) Database links Can contain @ (at sign) and . (period) Identifier quote character " (double quotes) Maximum length: text/html 2012-06-07T14:00:59+00:00 https://www.sqlines.com/oracle_schema_sql_server_database?rev=1339077659&do=diff An Oracle instance can run only one database, and schemas are widely used to logically group database objects in Oracle. A Microsoft SQL Server instance can run multiple databases, and although SQL Server also supports schemas, an Oracle schema is usually migrated to a SQL Server database, not to a schema. text/html 2022-12-21T19:20:10+00:00 https://www.sqlines.com/overview?rev=1671650410&do=diff SQLines SQL Converter tool can help you convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts between major databases. SQLines SQL Converter converts SQL scripts and standalone SQL statements. To migrate data and database schema use SQLines Data. You can use the tool with desktop UI or run it in command line. You can also try SQLines Online. text/html 2023-03-15T14:19:54+00:00 https://www.sqlines.com/partners?rev=1678889994&do=diff SQLines partners with leading database vendors to provide migration solutions. Array Array text/html 2024-06-27T18:05:54+00:00 https://www.sqlines.com/plsql-to-java?rev=1719511554&do=diff SQLines SQL Converter can help you convert Oracle PL/SQL stored procedures, functions and packages to Java. To run the conversion in command line: # Convert a single file ./sqlines -s=oracle -t=oracle -tl=java -in=package.sql -out=Package.java # Convert multiple files ./sqlines -s=oracle -t=oracle -tl=java -in=*.sql -out=out_dir/ text/html 2011-12-28T11:15:27+00:00 https://www.sqlines.com/postgresql-to-all?rev=1325070927&do=diff Summary information on SQL differences between PostgreSQL and other databases. a feature is supported and no syntax conversion is required, but subtle functional differences still may exist (browse for the details to see them). a feature is supported but there are differences in clauses, range, options etc. so syntax conversion may be required in some cases. text/html 2025-10-22T12:49:49+00:00 https://www.sqlines.com/postgresql-to-mariadb?rev=1761137389&do=diff SQLines tools can help you transfer data, convert database schema (DDL), views, stored functions (procedures), triggers, queries and SQL scripts from PostgreSQL to MariaDB. * SQLines Data - Data Transfer, Schema Migration and Validation tool * SQLines SQL Converter - SQL Scripts Conversion and Assessment tool. Try Online text/html 2025-10-22T12:38:45+00:00 https://www.sqlines.com/postgresql-to-mysql?rev=1761136725&do=diff SQLines tools can help you transfer data, convert database schema (DDL), views, stored functions (procedures), triggers, queries and SQL scripts from PostgreSQL to MySQL. * SQLines Data - Data Transfer, Schema Migration and Validation tool * SQLines SQL Converter - SQL Scripts Conversion and Assessment tool. Try Online text/html 2013-03-15T10:11:26+00:00 https://www.sqlines.com/postgresql-to-oracle-tool?rev=1363342286&do=diff SQLines tool allows you to convert database schema (DDL), queries and DML statements, views, functions and triggers from PostgreSQL to Oracle. The tool converts SQL scripts and standalone SQL statements from one or more files, it does not require database connections. text/html 2024-07-16T05:59:35+00:00 https://www.sqlines.com/postgresql-to-oracle?rev=1721109575&do=diff SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from PostgreSQL (Postgres) to Oracle. * SQLines SQL Converter - SQL Scripts Conversion and Assessment tool. Try Online * SQLines Data - Data Transfer, Schema Migration and Validation tool text/html 2026-04-16T18:16:32+00:00 https://www.sqlines.com/postgresql-to-sql-server?rev=1776363392&do=diff SQLines tools can help you convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from PostgreSQL (Postgres) to Microsoft SQL Server (MSSQL, MS SQL), Azure SQL, Azure Synapse and Fabric. * SQLines SQL Converter - SQL Scripts Conversion and Assessment tool. Try Online * SQLines Data - Data Transfer, Schema Migration and Validation tool text/html 2024-11-07T15:03:10+00:00 https://www.sqlines.com/postgresql?rev=1730991790&do=diff * Data Types * How To - Data Definition (DDL) * Database Migration Issues * How To - Most Popular Queries and Expressions * How To - PL/pgSQL Procedural SQL * How To - Database Administration (DBA) * Queries - SELECT Statement * Statements * PostgreSQL and C# .NET Applications text/html 2022-10-02T08:37:32+00:00 https://www.sqlines.com/powerbuilder?rev=1664699852&do=diff If you use PowerBuilder applications that access Oracle, you have to convert them when you migrate the Oracle databases to Microsoft SQL Server. PowerBuilder applications usually contain embedded SQL statements in Oracle syntax that needs to be converted to equivalent SQL Server syntax. text/html 2010-11-09T22:37:09+00:00 https://www.sqlines.com/privacy?rev=1289342229&do=diff We recognize the importance of protecting your personal information and we are committed to safeguarding your privacy online. SQLines understands that you are concerned about privacy, and we handle your personal information in a safe and responsible manner. text/html 2012-03-21T08:24:42+00:00 https://www.sqlines.com/products?rev=1332318282&do=diff SQLines offers tools to help you migrate data, database schema/DDL, queries, views, stored procedures, functions, triggers, embedded SQL and database API. Our tools support major enterprise databases including Oracle, Microsoft SQL Server, IBM DB2, MySQL, PostgreSQL, Sybase, Informix, Teradata, Netezza, Greenplum and others. text/html 2011-12-20T10:03:55+00:00 https://www.sqlines.com/progress?rev=1324375435&do=diff Here you can find white papers, references and articles on migration from Progress OpenEdge applications. Progress OpenEdge Migration Articles Articles on various migration related topics. Tutorials * Querying and Updating Data Compared with SQL text/html 2026-04-28T11:38:56+00:00 https://www.sqlines.com/purchase?rev=1777376336&do=diff You can purchase licenses for SQLines tools online. A single license is valid for both tools. SQLines Data tool migrates database schema (tables, constraints, indexes and sequences) and data as well as views, stored procedures, functions, and triggers from a live database i.e. it requires a database connection. text/html 2024-01-07T22:12:05+00:00 https://www.sqlines.com/rank?rev=1704665525&do=diff SQLines database migration ranking according to Online SQL Converter use. Note that the report can be biased for many reasons. * Users * Top 10 Source Databases * Top 5 Source Databases by Region * Top 10 Target Databases * Top 5 Target Databases by Region * Top 20 Database Migrations * Top 5 Database Migrations by Region text/html 2022-08-13T06:48:33+00:00 https://www.sqlines.com/redshift-to-spark?rev=1660373313&do=diff SQLines tools can help you convert database schema (DDL), views, queries and SQL scripts from Amazon Redshift to Apache Spark. * SQLines SQL Converter - SQL scripts assessment and conversion tool Databases: * Amazon Redshift * Apache Spark 3.x and 2.x text/html 2026-04-24T17:00:09+00:00 https://www.sqlines.com/release-notes?rev=1777050009&do=diff Changes in SQLines SQL Converter tool. * Version 3.3.307 * Version 3.3.303 * Version 3.3.301 * Version 3.3.300 * Version 3.3.177 * Version 3.3.173 * Version 3.3.171 * Previous Releases Version 3.3.307 In progress. Please contact us at <support@sqlines.com> for updates, improvements and new features. text/html 2023-07-12T08:50:57+00:00 https://www.sqlines.com/reshift-to-sql-server?rev=1689151857&do=diff SQLines tools can help you convert database schema (DDL), views, stored procedures, functions, queries and SQL scripts from Amazon Redshift to Microsoft SQL Server (MSSQL, MS SQL), Azure SQL, Azure Synapse and Fabric. Databases: * Amazon Redshift * Microsoft SQL Server 2022, 2019, 2017, 2016, 2014, 2012, 2008 and 2005 text/html 2023-12-18T15:26:30+00:00 https://www.sqlines.com/rpg-to-mysql?rev=1702913190&do=diff SQLines tools can help you convert IBM RPG routines and programs to MySQL stored procedures and functions. ./sqlines -sl=rpg -s=db2 -t=mysql -in=file.rpg Migration Reference * Language Elements * Data Types * Built-in Functions * Routines * Directives text/html 2012-07-06T12:36:36+00:00 https://www.sqlines.com/scripts?rev=1341578196&do=diff SQL scripts that can be helpful in Oracle to Microsoft SQL Server migration projects. Built-in Functions Emulating Oracle built-in functions in SQL Server: * INSTR - Find a position of substring in string SQL Server Metadata * Select All Tables in All Databases (Transact-SQL Script) text/html 2020-06-08T12:07:02+00:00 https://www.sqlines.com/services?rev=1591618022&do=diff There are free and commercial tools that can be very helpful in a migration project, but the cost, time and risk still highly depend on experience in database migrations. SQLines offers the following migration services: * Database Schema and Data Migration * SQL Scripts and Procedural SQL (PL/SQL, T-SQL, SPL etc.) Conversion * Embedded SQL and Database API Conversion in Java, C#, VB/VB.NET, ASP/ASP.NET, C/C++, PowerBuilder, Perl, PHP, Python and other applications * Data and Schema Va… text/html 2023-07-18T17:38:40+00:00 https://www.sqlines.com/spark-to-snowflake?rev=1689701920&do=diff SQLines provides tools to help you convert database schema (DDL), views, queries and SQL scripts from Apache Spark and Databricks SQL to Snowflake. * SQLines SQL Converter - SQL scripts assessment and conversion tool Databases: * Apache Spark 3.x and 2.x * Snowflake any release text/html 2024-07-25T11:12:37+00:00 https://www.sqlines.com/sql-server-to-databricks?rev=1721905957&do=diff SQLines tools can help you convert database schema (DDL), views, queries and SQL scripts from Microsoft SQL Server (MSSQL, MS SQL), Azure SQL Database, Azure Synapse to Databricks. * SQLines SQL Converter - SQL Scripts Conversion and Assessment tool. Try Online text/html 2023-08-05T07:18:31+00:00 https://www.sqlines.com/sql-server-to-db2?rev=1691219911&do=diff SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from Microsoft SQL Server (MSSQL, MS SQL), Azure SQL Database, Azure Synapse to IBM DB2: * SQLines Data - Data transfer, schema migration and validation tool * SQLines SQL Converter - SQL scripts conversion tool. Try Online text/html 2026-02-24T15:08:06+00:00 https://www.sqlines.com/sql-server-to-mariadb?rev=1771945686&do=diff SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from Microsoft SQL Server (MSSQL, MS SQL), Azure SQL Database, Azure Synapse to MariaDB. * SQLines SQL Converter - SQL Scripts Conversion and Assessment tool. Try Online * SQLines Data - Data Transfer, Schema Migration and Validation tool text/html 2013-02-20T09:02:47+00:00 https://www.sqlines.com/sql-server-to-mysql-tool?rev=1361350967&do=diff SQLines tool allows you to convert database schema (DDL), queries and DML statements, views, stored procedures, packages, functions and triggers from Microsoft SQL Server to MySQL. SQLines converts SQL scripts and standalone SQL statements. To migrate data and database schema from a SQL Server database to MySQL use SQLines Data tool. text/html 2026-02-24T15:49:56+00:00 https://www.sqlines.com/sql-server-to-mysql?rev=1771948196&do=diff SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from Microsoft SQL Server (MSSQL, MS SQL), Azure SQL Database, Azure Synapse to MySQL. * SQLines SQL Converter - SQL Scripts Conversion and Assessment tool. Try Online * SQLines Data - Data Transfer, Schema Migration and Validation tool text/html 2013-02-14T16:11:18+00:00 https://www.sqlines.com/sql-server-to-oracle-tool?rev=1360858278&do=diff SQLines tool allows you to convert database schema (DDL), queries and DML statements, views, stored procedures, functions and triggers from Microsoft SQL Server to Oracle. SQLines converts SQL scripts and standalone SQL statements. To migrate data and database schema from a SQL Server database to Oracle use SQLines Data tool. text/html 2025-12-04T14:10:05+00:00 https://www.sqlines.com/sql-server-to-oracle?rev=1764857405&do=diff SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from Microsoft SQL Server (MSSQL, MS SQL), Azure SQL Database, Azure Synapse to Oracle. * SQLines Data - Data transfer, schema migration and validation tool * SQLines SQL Converter - SQL scripts conversion and assessment tool. Try Online text/html 2013-02-06T16:12:40+00:00 https://www.sqlines.com/sql-server-to-postgresql-tool?rev=1360167160&do=diff SQLines tool allows you to convert database schema (DDL), queries and DML statements, views, stored procedures, functions and triggers from Microsoft SQL Server to PostgreSQL. SQLines converts SQL scripts and standalone SQL statements. To migrate data and database schema from a SQL Server database to PostgreSQL use SQLines Data tool. text/html 2026-04-02T09:39:15+00:00 https://www.sqlines.com/sql-server-to-postgresql?rev=1775122755&do=diff SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from Microsoft SQL Server (MSSQL, MS SQL), Azure SQL Database, Azure Synapse to PostgreSQL (Postgres). text/html 2024-01-31T22:25:08+00:00 https://www.sqlines.com/sql-server-to-redshift?rev=1706739908&do=diff SQLines provides tools to help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from Microsoft SQL Server to Amazon Redshift. Databases: * Microsoft SQL Server 2022, 2019, 2017, 2016, 2014, 2012, 2008, 2005 and 2000 * Amazon Redshift text/html 2023-02-17T16:05:51+00:00 https://www.sqlines.com/sql-server-to-singlestore?rev=1676649951&do=diff SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from Microsoft SQL Server (MSSQL, MS SQL), Azure SQL Database, Azure Synapse to SingleStore. Databases: text/html 2023-03-21T09:04:57+00:00 https://www.sqlines.com/sql-server-to-snowflake?rev=1679389497&do=diff SQLines tools can help you convert database schema (DDL), views, queries and SQL scripts from Microsoft SQL Server (MSSQL, MS SQL), Azure SQL Database, Azure Synapse to Snowflake. * SQLines SQL Converter - SQL scripts assessment and conversion tool text/html 2023-10-29T19:18:29+00:00 https://www.sqlines.com/sql-server-to-synapse?rev=1698607109&do=diff SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts and SQL scripts from Microsoft SQL Server (MSSQL, MS SQL), Azure SQL to Azure Synapse. * SQLines SQL Converter - SQL Conversion and assessment tool text/html 2024-06-22T14:41:14+00:00 https://www.sqlines.com/sql-server?rev=1719067274&do=diff * SQL Language Elements * Data Types * Built-in SQL Functions * Statements * Database Migration Issues * Database Settings * How To - Transact-SQL * SQL and Transact-SQL * SQL Server Metadata * Instances and Connections * SQL Server Performance text/html 2017-10-12T20:06:19+00:00 https://www.sqlines.com/sql?rev=1507838779&do=diff Functions and Expressions by Category String functions: * Find position in string Functions by Name Built-in SQL functions (A-Z): Function Description Example Result Databases INSTR Find position in string INSTR('abc', 'b') 2 Oracle, DB2, MySQL, MariaDB text/html 2026-04-22T17:28:04+00:00 https://www.sqlines.com/sqldata-release-notes?rev=1776878884&do=diff Changes in SQLines Data tool. * Version 3.7.17 * Version 3.7.13 * Version 3.7.11 * Version 3.7.10 * Previous Releases Version 3.7.17 In progress. Please contact us at <support@sqlines.com> for updates, improvements and new features. text/html 2025-05-03T08:10:55+00:00 https://www.sqlines.com/sqldata?rev=1746259855&do=diff SQLines Data is a data transfer, schema conversion and migration validation tool that supports major enterprise databases: * Oracle * DB2 to Oracle * Informix to Oracle * MySQL to Oracle * SQL Server to Oracle * Sybase ASE to Oracle * Sybase SQL Anywhere to Oracle text/html 2025-02-21T10:58:24+00:00 https://www.sqlines.com/sqldata_cfg?rev=1740135504&do=diff You can run SQLines Data tool from a command line, and this article describes the configuration file options. Additionally, you can specify options in Command Line. The default configuration file is sqldata.cfg located in the current directory. You can use -cfg command line option to specify another location and file name for the configuration file. text/html 2026-03-25T18:07:02+00:00 https://www.sqlines.com/sqldata_cmd?rev=1774462022&do=diff You can run SQLines Data tool from a command line, and this article describes the command line parameters. Additionally, you can specify options in Configuration File. To run SQLines Data from command line, run .sqldata on Linux and /sqldata.exe on Windows. text/html 2026-04-11T16:28:13+00:00 https://www.sqlines.com/sqldata_connection?rev=1775924893&do=diff Connection strings are required to specify the connection information for the source and target databases in SQLines Data tool. Connection strings can be specified using the -sd and -td command line options. For more information, see SQLines Data Command Line Reference. text/html 2026-03-09T18:53:16+00:00 https://www.sqlines.com/sqldata_db2_connection?rev=1773082396&do=diff If you are going to connect to a localhost IBM DB2 database you do not need to setup any additional libraries to use SQLines Data tool as they are already supplied with IBM DB2 server. If you need to connect to a remote IBM DB2 database, you need to have DB2 Runtime Client or IBM Data Server Driver Package installed in your system. text/html 2024-01-04T22:35:49+00:00 https://www.sqlines.com/sqldata_db2_odbc_connection?rev=1704407749&do=diff You may need to use ODBC driver to connect to IBM iSeries DB2 (AS/400) systems. Installing DB2 iSeries ODBC on Windows Go to IBM site and download IBM i Access Client Solutions, for example, IBMiAccess_v1r1.zip. Additionally download IBM i Access Client Solutions - Windows Application Package, for example, IBMiAccess_v1r1_WindowsAP_English.zip text/html 2024-09-09T16:35:29+00:00 https://www.sqlines.com/sqldata_informix_connection?rev=1725899729&do=diff If you are going to connect to a localhost Informix database you do not need to setup any additional libraries to use SQLines Data tool as they are supplied with Informix server. If you need to connect to a remote Informix database, you need to have Informix Client SDK (Informix CSDK) installed in your system. text/html 2025-03-25T13:51:20+00:00 https://www.sqlines.com/sqldata_mariadb_connection?rev=1742910680&do=diff If you are going to connect to a localhost MariaDB database you do not need to setup any additional libraries to use SQLines Data tool as they are supplied with MariaDB server. If you need to connect to a remote MariaDB database, you need to have MariaDB C API libmariadb installed in your system. text/html 2025-02-17T12:10:16+00:00 https://www.sqlines.com/sqldata_mysql_connection?rev=1739794216&do=diff If you are going to connect to a localhost MySQL database you do not need to setup any additional libraries to use SQLines Data tool as they are supplied with MySQL server. If you need to connect to a remote MySQL database, you need to have MySQL C API libmysqlclient installed in your system. text/html 2017-05-06T13:07:28+00:00 https://www.sqlines.com/sqldata_new?rev=1494076048&do=diff List of in-progress features and fixes ordered by implementation priority. * Long identifiers when migrating from SQL Server to Oracle 11g * From Oracle: constraints and indexes for not selected tables are currently migrated * From DB2: constraints for not selected tables are currently migrated * Oracle CASCADE clause fix * IDENTITY fix when migrating from SQL Server to PostgreSQL * PRIMARY KEY fix when migrating from SQL Server to PostgreSQL * FOREIGN KEY fix when migrating fro… text/html 2023-05-22T16:36:11+00:00 https://www.sqlines.com/sqldata_oracle_connection?rev=1684773371&do=diff If you need to connect to a localhost Oracle database you do not need to setup any additional libraries to use SQLines Data tool as they are already supplied with the Oracle server software. If you need to connect to a remote Oracle database, you need to have Oracle OCI (Oracle Call Interface) installed in your system. text/html 2024-06-25T15:26:09+00:00 https://www.sqlines.com/sqldata_postgresql_connection?rev=1719329169&do=diff If you are going to connect to a localhost PostgreSQL database you do not need to setup any additional libraries to use SQLines Data tool as they are already supplied with PostgreSQL server. If you need to connect to a remote PostgreSQL database, you need to have PostgreSQL C API libpq (PostgreSQL native client software) installed in your system. text/html 2026-04-11T08:53:35+00:00 https://www.sqlines.com/sqldata_sql_server_connection?rev=1775897615&do=diff If you are connecting to a SQL Server database on localhost you do not need to setup any additional libraries to use SQLines Data tool as they are supplied with Microsoft SQL Server. If you need to connect to a remote SQL Server database, you need to have SQL Server ODBC Driver (since SQL Server 2022) or Native Client (deprecated since SQL Server 2022) installed in your local system. text/html 2026-04-15T13:34:43+00:00 https://www.sqlines.com/sqldata_sybase_connection?rev=1776260083&do=diff If you need to connect to a localhost Sybase ASE database you do not need to setup any additional libraries to use SQLines Data tool as they are already supplied with the Sybase ASE server software. If you need to connect to a remote Sybase ASE database, you need to have Client Library/C (CT-Lib) installed in your system. text/html 2026-01-03T11:49:28+00:00 https://www.sqlines.com/sqldata_validation?rev=1767440968&do=diff SQLines Data tool allows you to validate the migrated data in tables. There are two options available: * Row Count Check * Full Data Comparison Row Count Check Row count check is a quick and simple way to check that all rows of all tables were migrated. SQLines Data tool executes SELECT COUNT(*) query for every table and compares the results. text/html 2012-08-14T15:02:06+00:00 https://www.sqlines.com/sqlextract_powerbuilder?rev=1344956526&do=diff SQLExtract tool allows you to extract embedded and dynamic SQL statements from PowerBuilder applications to SQL files. The tool was developed to extract SQL statements from applications accessing Oracle and Microsoft SQL Server databases, but with some limitations, you can use it for any database. text/html 2017-05-10T04:18:08+00:00 https://www.sqlines.com/sqlines_new?rev=1494389888&do=diff List of in-progress features and fixes ordered by implementation priority. * CREATE TABLE fixes for SQL Server to Amazon Redshift conversion * Oracle 11g 30 characater identifiers * Oracle reserved words * MySQL column comments when converting to Oracle * Oracle 12.2 long identifiers (128 characters) * Oracle 12.2 column level specification for case sensitivity for tables * Oracle 12.1 VARCHAR2 limits enhanced to 32767 * Oracle 12.1 Implicit result sets support in stored pro… text/html 2012-05-19T19:31:34+00:00 https://www.sqlines.com/ssorc?rev=1337455894&do=diff SQLines offers Oracle compatibility libraries that allow you to use existing Oracle applications with Microsoft SQL Server and SQL Azure databases without source code changes, recompiling and relinking. The Oracle compatibility libraries can also help you automatically test the database migration at the application level as well as replicate data between Oracle and SQL Server during the transition phase of migration. text/html 2011-09-28T10:15:14+00:00 https://www.sqlines.com/ssrs?rev=1317204914&do=diff Here you can find white papers, references and articles on migration to/from SQL Server Reporting Services. SQL Server Reporting Services Migration Articles Articles on various migration related topics. Tutorials * Creating Reports (.RDL Files) Manually text/html 2011-08-05T09:19:30+00:00 https://www.sqlines.com/support-and-services?rev=1312535970&do=diff text/html 2025-02-10T09:53:15+00:00 https://www.sqlines.com/support?rev=1739181195&do=diff The SQLines development team provides support for SQLines tools. We fix bugs, improve conversion and add new features by your requests. Currently the technical support is provided by email and handled by the developers directly. Please feel free to report any issues at <support@sqlines.com>. text/html 2026-04-16T18:17:25+00:00 https://www.sqlines.com/sybase-ads-to-sql-server?rev=1776363445&do=diff SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from SAP Sybase Advantage Database Server (Sybase ADS) to Microsoft SQL Server. Databases: * SAP Sybase Advantage Database Server 12.x, 11.x, 10.x and 9.x * Microsoft SQL Server 2025, 2022, 2019, 2017, 2016, 2014, 2012, 2008, 2005 and 2000 text/html 2024-08-01T07:40:59+00:00 https://www.sqlines.com/sybase-asa-to-mariadb?rev=1722498059&do=diff SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from SAP SQL Anywhere, Sybase SQL Anywhere, Sybase Adaptive Server Anywhere (Sybase ASA) to MariaDB. * SQLines SQL Converter - SQL Scripts Conversion and Assessment tool. Try Online * SQLines Data - Data Transfer, Schema Migration and Validation tool text/html 2024-08-01T07:40:27+00:00 https://www.sqlines.com/sybase-asa-to-mysql?rev=1722498027&do=diff SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from SAP SQL Anywhere, Sybase SQL Anywhere, Sybase Adaptive Server Anywhere (Sybase ASA) to MySQL. * SQLines SQL Converter - SQL Scripts Conversion and Assessment tool. Try Online * SQLines Data - Data Transfer, Schema Migration and Validation tool text/html 2013-04-16T14:32:09+00:00 https://www.sqlines.com/sybase-asa-to-oracle-tool?rev=1366122729&do=diff SQLines tool allows you to convert database schema (DDL), views, stored procedures, functions, triggers, queries, SQL scripts and embedded SQL from Sybase SQL Anywhere (Sybase ASA) to Oracle. SQLines Features and Licensing SQLines is available in Online and Desktop editions: text/html 2026-02-24T17:08:47+00:00 https://www.sqlines.com/sybase-asa-to-oracle?rev=1771952927&do=diff SQLines provides tools and services to help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from Sybase SQL Anywhere, Sybase Adaptive Server Anywhere (ASA) to Oracle. * Sybase SQL Anywhere 17, 12, 11, 10, 9 and 5 * Oracle 19c, 12c and 11g text/html 2026-04-02T10:10:33+00:00 https://www.sqlines.com/sybase-asa-to-postgresql?rev=1775124633&do=diff SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from SAP Sybase SQL Anywhere, Sybase Adaptive Server Anywhere (ASA) to PostgreSQL (Postgres). * SQLines SQL Converter - SQL Conversion and Assessment tool * SQLines Data - Data Transfer, Schema Migration and Validation tool text/html 2026-04-16T18:17:00+00:00 https://www.sqlines.com/sybase-asa-to-sql-server?rev=1776363420&do=diff SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from SAP SQL Anywhere, Sybase SQL Anywhere, Sybase Adaptive Server Anywhere (Sybase ASA) to Microsoft SQL Server (MSSQL, MS SQL), Azure SQL Database, Azure Synapse. text/html 2017-12-20T16:21:11+00:00 https://www.sqlines.com/sybase-asa?rev=1513786871&do=diff Technical information on Sybase SQL Anywhere (Sybase Adaptive Server Anywhere or Sybase ASA). Data Types Built-in data types by category and mapping to other databases... DATETIME Date and time - year, month, day, hour, minute, second and fraction of a second Database Configuration * Locale Information text/html 2012-11-06T19:54:16+00:00 https://www.sqlines.com/sybase-to-db2?rev=1352231656&do=diff Technical information on migration from Sybase Adaptive Server Enterprise to IBM DB2. Last Update: Sybase Adaptive Server Enterprise 15.0 and IBM DB2 10.1 * Data Types Data Types Converting data types: Sybase ASE IBM DB2 CHAR Fixed-length character string CHAR INT, INTEGER 32-bit integer INT, INTEGER SMALLINT 16-bit integer SMALLINT VARCHAR Variable-length character string VARCHAR text/html 2025-07-12T08:08:03+00:00 https://www.sqlines.com/sybase-to-mariadb?rev=1752307683&do=diff SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from Sybase Adaptive Server Enterprise (Sybase ASE) to MariaDB. * SQLines SQL Converter - SQL Scripts Conversion and Assessment tool. Try Online * SQLines Data - Data Transfer, Schema Migration and Validation tool text/html 2025-07-13T07:29:37+00:00 https://www.sqlines.com/sybase-to-mysql?rev=1752391777&do=diff SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from Sybase Adaptive Server Enterprise (Sybase ASE) to MySQL. * SQLines SQL Converter - SQL Scripts Conversion and Assessment tool. Try Online * SQLines Data - Data Transfer, Schema Migration and Validation tool text/html 2013-02-14T16:16:31+00:00 https://www.sqlines.com/sybase-to-oracle-tool?rev=1360858591&do=diff SQLines tool allows you to convert database schema (DDL), queries and DML statements, views, stored procedures, functions and triggers from Sybase Adaptive Server Enterprise (Sybase ASE) to Oracle. SQLines converts SQL scripts and standalone SQL statements. To migrate data and database schema from a Sybase database to Oracle use SQLines Data tool. text/html 2025-12-04T08:43:04+00:00 https://www.sqlines.com/sybase-to-oracle?rev=1764837784&do=diff SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from Sybase Adaptive Server Enterprise (Sybase ASE) to Oracle. * SQLines Data - Schema, data migration and validation tool * SQLines SQL Converter - SQL scripts conversion and assessment tool. Try Online text/html 2024-10-16T15:43:26+00:00 https://www.sqlines.com/sybase-to-postgresql?rev=1729093406&do=diff SQLines tools help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from SAP Sybase Adaptive Server Enterprise (Sybase ASE) to PostgreSQL. * SQLines SQL Converter - SQL Scripts Conversion and Assessment tool. Try Online * SQLines Data - Data Transfer, Schema Migration and Validation tool text/html 2026-04-16T18:16:48+00:00 https://www.sqlines.com/sybase-to-sql-server?rev=1776363408&do=diff SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from SAP Sybase Adaptive Server Enterprise (Sybase ASE) to Microsoft SQL Server (MSSQL, MS SQL), Azure SQL Database, Azure Synapse. text/html 2025-12-04T08:15:29+00:00 https://www.sqlines.com/sybase?rev=1764836129&do=diff Technical information on Sybase Adaptive Server Enterprise (Sybase ASE). * DBA Scripts - Data Catalog Queries * Get the Default Characater Set * Get Stored Procedure Text DBA Scripts - Data * Inserting N Rows In a Loop Committing After Each Mth Row (Transact-SQL Script, Workload Simulation) text/html 2016-08-10T05:37:35+00:00 https://www.sqlines.com/teradata-to-esgyndb?rev=1470807455&do=diff SQLines provides tools and services to help you transfer data, convert database schema (DDL), stored procedures, functions, queries, SQL and BTEQ scripts from Teradata to EsgynDB (powered by Apache Trafodion). We also help convert embedded SQL statements in C/C++, C#, Java, PowerBuilder, VB/VB.NET, ASP/ASP.NET, Perl/PHP, Python and other applications. text/html 2020-11-11T15:14:39+00:00 https://www.sqlines.com/teradata-to-oracle?rev=1605107679&do=diff SQLines provides services to help you convert database schema (DDL), views, stored procedures, functions, triggers, macros, queries, BTEQ and SQL scripts from Teradata to Oracle. We also help convert embedded SQL statements in C/C++ (ODBC, ESQL/C), C#, Java, PowerBuilder, VB/VB.NET, ASP/ASP.NET, Python, Perl/PHP, SAS, Bash shell scripts and applications. text/html 2016-06-07T14:34:42+00:00 https://www.sqlines.com/teradata-to-trafodion?rev=1465310082&do=diff SQLines provides tools and services to help you transfer data, convert database schema (DDL), stored procedures, functions, queries, SQL and BTEQ scripts from Teradata to Apache Trafodion (EsgynDB). * Teradata 15, 14, 13.x, 12, V2R6 and V2R5 * Trafodion text/html 2012-02-29T09:32:22+00:00 https://www.sqlines.com/teradata?rev=1330507942&do=diff Technical information on SQL dialect of Teradata database. Tables - DDL Options and Attributes * CASESPECIFIC and NOT CASESPECIFIC (CS and NOT CS) How To - System and Catalog Information * Define If Session in Teradata or ANSI Mode Built-in Functions Built-in functions by category... text/html 2012-04-15T12:58:43+00:00 https://www.sqlines.com/testing?rev=1334494723&do=diff During or After Development Phase of Migration: * Discovering remaining issues * Assisting with testing * Performing static code analysis (without application execution) * Optimizing code After completing the development phase of migration, you can use SQLines to identify issues that left unattended or not properly handled by tools that you used to automate conversion or after manual conversion. text/html 2011-05-04T14:44:46+00:00 https://www.sqlines.com/todo?rev=1304520286&do=diff Options in source as hints /* sqlines(option1=value1, option2 = value2) */ Can be used for tests and in online tools. Maybe very convenient. Discussion Forums <http://tda31.blogspot.com/2011/03/discussion-forums-famous-migration.html> Report Feature - Target tokens In report show source match and target tokens (in symbolic form to understand conversion after applying all options $options, $target; use symbols to represent $change, $delete) text/html 2020-09-18T17:14:42+00:00 https://www.sqlines.com/tutorials?rev=1600449282&do=diff There are several ways to work with SQLines: * SQLines Online (Web-based) * SQLines W (UI Wrapper for Command Line Tool) * SQLines Studio (IDE) * SQLines Command Line Tool SQLines Online You can use SQLines online at <http://www.sqlines.com/online>. You can perform conversion and assessment for standalone SQL scripts and application source code. text/html 2025-02-25T09:05:02+00:00 https://www.sqlines.com/why?rev=1740474302&do=diff Why you should choose SQLines migration tools: * SQLines vs AI * Tools for the Entire Database Migration * Enterprise-Class Migrations * High Quality of Automated Code Conversion * Supporting Many Popular Databases SQLines vs AI Modern AI tools deliver impressive results and provide significant assistance. However, a substantial amount of effort is still required to complete the migration.