Don't hate me for it, but I'd like this for MySQL to postgres too. At least as a stepping stone.<p>Use case: some of my SQL syntax depends on MySQL but I realize I made a poor life choice and would rather have transactional DDL and a myriad of better features on postgres.
This is great. I suspect that I have exactly the right use case for this.<p>The two main issues with running SQL Server are (1) you have to license all the cores on a system and (2) the standard license only recognizes up to 64GB RAM. So I actually wound up buying a 3GHz single-socket system for around $10K to save $20K on the SQL license.<p>With this, I can move a couple of the big DBs to another system that has 32 Cores with 256GB RAM and the entire DB will fit in memory, put in 5GB ethernet, and gain a tremendous amount of performance.<p>But, more importantly, I can migrate the workload on a case-by-case basis. Human costs always dwarf my software and hardware costs.
> A commonly used datatype to store monetary values is the MONEY data type. In SQL Server, the MONEY data type’s behavior is fixed using four digits to the right of the decimal (e.g., $12.8123). However, in PostgreSQL, the MONEY data type is fixed using two digits to the right of the decimal.<p>> So, when the application tries to store a value of $12.8123, by example, PostgreSQL will round to $12.81. This subtle difference will result in a rounding error and break an application if not correctly addressed. To ensure correctness in Babelfish, we need to ensure such differences, small and large, are handled with absolute fidelity.<p>How are they going to solve this with just a query translation layer? Isn't information lost on save?
As someone who has been fighting with a SQL Server to Postgresql conversion this sounds AMAZING. Too bad it won't be available before my conversion is complete (and if it is, that's an even sadder proposition)
This would be even greater news if it would not be vaporware "Babelfish for PostgreSQL will be available on Github in 2021."
<a href="https://babelfish-for-postgresql.github.io/babelfish-for-postgresql/" rel="nofollow">https://babelfish-for-postgresql.github.io/babelfish-for-pos...</a>
This is interesting because it will also help Sybase migrations. SQL Server is the "brand name" but there are still a lot of people stuck on Sybase.
Sounds like they’re open sourcing it to get some help on it. I have to wonder if they’ve found it not worth the time to make it fully production ready.
Why not do this for Oracle? I've not found SQL Server to be too bad from the crazy Oracle stuff (light experience only - maybe bigger players have it worse?).
Heres ms2pg <a href="https://edoceo.com/dev/ms2pg" rel="nofollow">https://edoceo.com/dev/ms2pg</a><p>A tool I made and used over a decade ago when migrating a bunch of stuff
I tried to build a T-Sql-to-pgsql compiler to enable us to migrate our code but ran into some fundamental issues.<p>Sql Server allows you to have arbitrary statements/declarations embedded in your sql queries. It also doesn't require type information to be specified in many places.<p>How does this translator get around that?<p>For example, if I have this bit of unoptimized T-Sql:<p><pre><code> declare @m int
select @m=[MeterID] from EnergyMeters where MeterLocation='/a/b/c';
select sum([Value]) from EnergyData where [MeterID]=@m;
</code></pre>
How would this get translated to pgsql? (Yes, you can combine this specific statement into a single query - this is a trivial example to highlight the point)
This sounds like it could be a massive competitive advantage for AWS over Azure.<p>It would be difficult for Microsoft to canibalize their Azure Sql sales by building a similar translation layer.
About every 3 years when I've tried to migrate and use some db migration tool it always seems to throw frustrating string/formatting errors, each time I've smacked my forehead and ended up just grabbing Ruby and ActiveRecord, it just always seems to work without any weird parsing errors.
1) Is there MongoDB-to-Postgres Translation layer?<p>2) Is there converter that can convert schema and transfer all data from:<p>2.1) MongoDB to SQLite?<p>2.2) MongoDB to PostgreSQL?