https://www.sqlines.com/ 2026-04-06T17:59:44+00:00 https://www.sqlines.com/ https://www.sqlines.com/lib/images/favicon.ico text/html 2026-04-03T06:57:49+00:00 sqlines 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 2026-04-03T06:57:29+00:00 sqlines https://www.sqlines.com/db2-to-sql-server?rev=1775199449&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 2026-04-03T06:57:11+00:00 sqlines 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:56:59+00:00 sqlines 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-02T10:23:04+00:00 sqlines https://www.sqlines.com/release-notes?rev=1775125384&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 2026-04-02T10:10:33+00:00 sqlines 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-02T09:39:15+00:00 sqlines 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 2026-04-01T10:18:00+00:00 sqlines https://www.sqlines.com/sybase-asa-to-postgresql/return_resultset?rev=1775038680&do=diff Sybase SQL Anywhere allows a stored procedure to return a result set to the caller by executing a standalone SELECT statement: Sybase SQL Anywhere: -- Return a result set from stored procedure CREATE PROCEDURE sp_getColors() RESULT ( id INT, name VARCHAR(30)) BEGIN SELECT 1, 'White' UNION ALL SELECT 2, 'Black' UNION ALL SELECT 3, 'Green' END GO text/html 2026-03-30T13:44:24+00:00 sqlines https://www.sqlines.com/sqldata-release-notes?rev=1774878264&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 2026-03-25T18:07:02+00:00 sqlines 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-03-25T14:06:45+00:00 sqlines 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 2026-03-23T20:04:54+00:00 sqlines https://www.sqlines.com/purchase?rev=1774296294&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 2026-03-20T20:10:41+00:00 sqlines https://www.sqlines.com/sybase-asa-to-postgresql/for_cursor_loop?rev=1774037441&do=diff In Sybase SQL Anywhere and PostgreSQL, you can use the FOR statement to execute the specified statements for each row in a cursor. Sybase SQL Anywhere: CREATE PROCEDURE show_colors() BEGIN FOR rec AS cur CURSOR FOR SELECT name FROM colors DO MESSAGE 'Color: ' || name TO CLIENT; END FOR; END GO text/html 2026-03-14T17:38:29+00:00 sqlines https://www.sqlines.com/sybase-asa-to-postgresql/timestamp?rev=1773509909&do=diff In Sybase SQL Anywhere, the TIMESTAMP data type stores date and time with fractional seconds with microseconds precision. In PostgreSQL, you can also use the TIMESTAMP(p) data type, allowing you to set a precision from 0 to 6 for fractional seconds, with a default of 6. text/html 2026-03-14T17:17:58+00:00 sqlines https://www.sqlines.com/postgresql-to-oracle/timestamp?rev=1773508678&do=diff In both PostgreSQL and Oracle, the TIMESTAMP data type stores date and time data (year, month, day, hour, minute, second and fractional second). PostgreSQL and Oracle: -- A sample table CREATE TABLE product ( name VARCHAR(70), created TIMESTAMP(3), expiry TIMESTAMP ); text/html 2026-03-14T17:15:11+00:00 sqlines 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 2026-03-12T18:50:50+00:00 sqlines https://www.sqlines.com/sybase-asa-to-sql-server?rev=1773341450&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 2026-03-12T14:57:17+00:00 sqlines https://www.sqlines.com/sybase-asa-to-postgresql/default_timestamp?rev=1773327437&do=diff In Sybase SQL Anywhere, you can specify the DEFAULT TIMESTAMP clause for a table column, and its value will auto-update with the current date and time whenever the row is updated. In PostgreSQL, you can use DEFAULT CLOCK_TIMESTAMP() to set the default value on insert, and a trigger to update it on every update. text/html 2026-03-12T07:19:01+00:00 sqlines https://www.sqlines.com/oracle-to-postgresql/string_concat?rev=1773299941&do=diff In Oracle, the || operator concatenates strings ignoring NULL values. In PostgreSQL, the || operator returns NULL if any operand is NULL. To avoid this, use the CONCAT function, which ignores NULL values, or use COALESCE to replace NULLs with empty strings. text/html 2026-03-12T07:18:51+00:00 sqlines https://www.sqlines.com/sybase-asa-to-postgresql/string_concat?rev=1773299931&do=diff In Sybase SQL Anywhere, the || operator concatenates strings ignoring NULL values. In PostgreSQL, the || operator returns NULL if any operand is NULL. To avoid this, use the CONCAT function, which ignores NULL values, or use COALESCE to replace NULLs with empty strings.