Switch from SQL Server to Postgres without changing a single line of code.
Your application was designed for SQL Server, but NEXTGRES lets you run it on PostgreSQL with ease.
Overview
While PostgreSQL supports most of the abstract functionality required by applications designed for SQL Server, differences in the client software, SQL dialect, and procedural languages often make switching databases a difficulty. Although a subset of these issues can be reduced using migration tools developed by third-party consultants and public cloud providers, they often require counterintuitive workarounds as well as changes to code and data types, which affect the overall behavior of your application. The substantial amount of hand-holding, tweaking, and testing involved in such a project is why switching databases is considered expensive and time-consuming. This is why NEXTGRES was created.
Compatibility
Microsoft SQL Dialect
A large subset of the DDL and DML dialect employed by SQL Server is supported. If an equivalent operation or option exists in Postgres, it is passed-through. Otherwise, it is dropped.
Native Transact-SQL Support
Unlike migration tools, which essentially translate syntax from SQL Server to Postgres, NEXTGRES-based PostgreSQL has well-known SQL Server functionality built-in.
Contrary to PostgreSQL, NEXTGRES supports native Transact-SQL (T-SQL) using the freely-available pgTSQL (provided by OpenSCG) – this means there is zero migration from T-SQL to PL/pgSQL; your code moves directly over.
TDS Protocol Compatible
NEXTGRES Gateway is a proxy which speaks the same TDS wire-level network protocol as the SQL Server. This enables applications designed to work with SQL Server, including those without source code, to transparently interoperate with Postgres. Likewise, this enables developers and DBAs to use many of the same tools and utilities they’re accustomed to, such as SQL Server Management Studio, sqsh, etc.
Additional Compatibility Components
- Microsoft Open Data Services (ODS) & Sybase/SAP Open Server Compatible Implementation – A drop-in replacement for the no-longer-public Microsoft ODS and Sybase/SAP Open Server product, often referred to as srvlib.
Pilot Customer Program
We’re currently piloting our product to a select number of customers. To be considered for the program, please send us an email.
Free Version
We will soon be releasing a downloadable version of the product free for personal use. Stay tuned!