Differences

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

sql-server-to-postgresql-tool [November 21, 2012 11:33 am]
sqlines
sql-server-to-postgresql-tool [February 06, 2013 9:12 am] (current)
sqlines
Line 1: Line 1:
-====== SQLines Tool - Microsoft SQL Server to PostgreSQL Migration ======+====== SQLines Tool - SQL Server to PostgreSQL ======
-SQLines tool allows you to convert database schema (DDL), views, stored procedures, functions, triggers, queries, SQL scripts and embedded SQL from Microsoft SQL Server to PostgreSQL.+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 [[/sqldata/sql-server-to-postgresql|SQLines Data]] tool.
===== SQLines Features and Licensing ===== ===== SQLines Features and Licensing =====
-SQLines is available in Online, Lite, Standard, Professional and Enterprise editions:+SQLines is available in Online and Desktop editions:
-| |  **Online**  |  **Lite**  | **Standard**  |  **Professional**  |  **Enterprise**  +| |  **Online Edition**  |  **Desktop Edition**  || 
-| **Lines of Code Limitation** ||||||  +| **License Limitations** |||| 
-| //DDL Statements// |  Unlimited  |  Unlimited  | Unlimited  |  Unlimited  |  Unlimited  |  +| //DDL Statements// |  Unlimited  |  Unlimited  || 
-| //DML Statements, Queries and Views// |  3,000  |  10,000  |  30,000  |  Unlimited  |  Unlimited  |  +| //DML Statements, Queries and Views// |  Unlimited  |  Unlimited  ||  
-| //Procedural SQL// |  3,000 |  n/a | 10,000  |  30,000  |  Unlimited  |  +| //Procedural SQL// |  Unlimited |  Unlimited ||  
-| **Conversion Features** |||||| +| **Conversion Features** |||| 
-| //DDL - Tables and Indexes// |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  | {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  +| //DDL - Tables and Indexes// |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  ||  
-| //DML Statements// |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  | {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  +| //Queries, Views and DML Statements// |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  || 
-| //Built-in SQL Functions// |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  +| //Stored Procedures, Functions and Triggers// |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  || 
-| //Queries and Views// |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  +| **Interfaces** |||| 
-| //Stored Procedures// |  {{:green_tick.gif|}}  |  {{:red_cross.png|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  +| //Command Line// |   n/a  |  {{:green_tick.gif|}}  ||   
-| //User-Defined Functions// |  {{:green_tick.gif|}}  |  {{:red_cross.png|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  +| //API// |  n/a  |  {{:green_tick.gif|}}  ||  
-| //Triggers// |  {{:green_tick.gif|}}  |  {{:red_cross.png|}}  |  {{:green_tick.gif|}}  | {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  +| **Platforms** |||| 
-| **Interfaces** |||||| +| Windows 32-bit |  Hosted  |  {{:green_tick.gif|}}  || 
-| //Command Line// |   n/a  |  {{:green_tick.gif|}}  | {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |   +| Linux x86 32-bit |  Hosted  |  {{:green_tick.gif|}}  || 
-| //API// |  n/a |  {{:red_cross.png|}}  |  {{:red_cross.png|}} |  {{:green_tick.gif|}}  | {{:green_tick.gif|}}  |  +| **Licensing and Support** |||| 
-| **Platforms** |||||| +| //Technical Support// |  {{:green_tick.gif|}}  |   {{:green_tick.gif|}}  ||  
-| Windows 32-bit |  Hosted  |  {{:green_tick.gif|}}  | {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  +| //Price// |  Free  |  $375  ||
-| Linux x86 32-bit |  Hosted  |  {{:green_tick.gif|}}  | {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  +
-| **Licensing and Support** |||||| +
-| //Technical Support// |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |   {{:green_tick.gif|}}  | {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  +
-| //Price// |  Free |  $135 |  $375  | $975  |  $1735  |+
-Try [[http://www.sqlines.com/online|SQLines Online]] or download a [[/download|Trial Version]] (//no registration required)//.+Try [[http://www.sqlines.com/online|SQLines Online]] or download a [[http://www.sqlines.com/download|Trial Version]].
If any you have any questions or need any assistance, please contact us at [[support@sqlines.com]]. If any you have any questions or need any assistance, please contact us at [[support@sqlines.com]].
Line 36: Line 34:
===== Conversion Features ===== ===== Conversion Features =====
-SQL conversion features supported by SQLines tool. For more information, also see+For detailed information about conversion features supported in SQLines, see
[[/sql-server-to-postgresql|SQL Server to PostgreSQL Migration Reference]]. [[/sql-server-to-postgresql|SQL Server to PostgreSQL Migration Reference]].
- 
-  * [[/sql-server-to-postgresql-tool#built-in-sql-functions|Built-in SQL Functions]] 
- 
-===== Built-in SQL Functions ====== 
- 
-Converting SQL functions: 
- 
-| | **SQL Server** ||| **PostgreSQL** ||  
-| 1 | [[/postgresql/how-to/dateadd|DATEADD]] | Add an interval to datetime | [[/postgresql/how-to/dateadd|INTERVAL expression]] ||