That's probably an hour or two of research to see how bad it is going to be. Migrating from legacy SQL Server databases can be time-consuming and resource-intensive. ![]() It was written by the group that wrote the old SSMS Oracle conversion tool (DB Best I believe) and is pretty solid. Babelfish for Aurora PostgreSQL is a new capability for Amazon Aurora PostgreSQL-Compatible Edition that enables Aurora to understand commands from applications written for Microsoft SQL Server. 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. 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. Your choice will affect how the names of T-SQL schemas inside the Babelfish database appear in PostgreSQL. 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. Doing this allows applications originally built for SQL Server to work directly with PostgreSQL with few code changes compared to a traditional migration and without changing database drivers. ![]() ![]() 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. Babelfish offers two modes of operation: single-db. Babelfish for PostgreSQL extends your PostgreSQL database with the ability to accept database connections from Microsoft SQL Server clients. 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 |