![]() That's probably an hour or two of research to see how bad it is going to be. configure CFLAGS'-ggdb' \ -enable-debug \ -with-libxml \ -with-uuidossp \ -with-icu \ -with-extra-version. To do that we need to run the configure script in the directory where you have downloaded the Babelfish for PostgreSQL engine sources. Your choice will affect how the names of T-SQL schemas inside the Babelfish database appear in PostgreSQL. Before compiling the Babelfish for PostgreSQL source code, we need to configure the build. When you create a Babelfish cluster, you choose between using a single migrated T-SQL user database or multiple migrated T-SQL user databases together. It was written by the group that wrote the old SSMS Oracle conversion tool (DB Best I believe) and is pretty solid. Babelfish offers two modes of operation: single-db. Babelfish is a optional Aurora feature and incurs no additional cost. Heck it is cheap enough you can run AWS SCT/DMS, point an app at it on 1433, and see how it runs.ĮDIT: I only came here from Brent's profile and just read the post, AWS SCT will probably be the most helpful and pray you don't have a ton of complex queries. With Babelfish for PostgreSQL, applications that were originally built for SQL Server can work directly with PostgreSQL with few to no code changes and without changing connectivity drivers in existing client applications. If you have a small-medium complexity app with some basic reporting and you want a crutch for people while you convert or save on MSSQL licenses, give it a shot. I would be hesitant to move a datawarehouse, less over size and more over lots of esoteric functions and you often move out of full declarative statements to trying to manipulate the DB. Having used it in a production deployment and it was fine.ĭon't expect to replace everything and don't take really complex queries/databases.Įx. Yes, it is reliable and production ready in my experience if you have the correct expectations and assessments.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |