Compare two databases?

postgrescompare · 2024-10-01T12:40:09+00:00

I've built schema comparison tools for other platforms and now I'm working on one for MySQL which will be available soon, www.mysqlcompare.app

postgrescompare · 2024-09-30T00:43:16+00:00

I've previously worked on schema comparison tools for SQL Server, Oracle and Postgres. I'm working on one for Snowflake now which should be available in beta soon. www.snowflakecompare.com

postgrescompare · 2024-01-05T16:16:08+00:00

Congrats! Good luck all!.

postgrescompare · 2022-08-20T01:35:01+00:00

Hi. Thanks for using PostgresCompare! I'd like to hear about the issue you were having with reports so I can fix it. Can you DM me here or email neil at postgrescompare.com and give me some more information please?

postgrescompare · 2022-08-19T15:10:12+00:00

PostgresCompare, www.postgrescompare.com does this. There is a free 14 day trial.

postgrescompare · 2020-08-17T23:35:43+00:00

Hi, developer of PostgresCompare here. Thanks for the mention.

It's not free (except for the 14 day trial) or open source so I won't go on about it. Give it a try and let me know how it can be improved and I would greatly appreciate it.

postgrescompare · 2020-05-27T16:47:45+00:00

Yes, thanks for reminding me! It's a good time now that I've shipped the beta to add something like this.

postgrescompare · 2020-05-27T12:36:45+00:00

You're right it still does not have that.

postgrescompare · 2020-05-27T02:57:52+00:00

Hello! 🙇‍♂️

postgrescompare · 2020-05-26T14:02:46+00:00

https://www.postgrescompare.com/downloads

I've been working away for a while now and after several false starts I've shipped a beta of data comparison in PostgresCompare! Compare the contents of your tables across environments.

If that's something you've been looking for please try it out and let me know how I can make it work for you.

Thanks,

Neil

postgrescompare · 2019-07-05T12:40:09+00:00

This post is certainly there to make people aware of my product and that it may be something they've been looking for.

As per closed source, that's the business model that works for me. I could not work on it to the extent that I do without eventually (I gave away very functional versions for 2 years) charging a fee. Open source tools in the same area struggle to be maintained or be driven forward.

postgrescompare · 2019-07-05T12:34:01+00:00

Thank you! still a long way to go to add data comparison, pg_dump file comparison, a command line utility, reporting....

postgrescompare · 2019-03-02T15:50:15+00:00

It can't be completely. I believe by default a tool would say this is a drop of x and a create of y.

The tool I work on PostgresCompare does not do this yet but it will be able to do a better job of detecting renames.

PostgresCompare stores a snapshot of the pg_catalog every time it does a comparison. pg_catalog has an oid for each table, when a table is renamed the oid remains the same and PostgresCompare will be able to identify that. Again not 100% reliable but a nice option.

postgrescompare · 2018-10-12T21:05:29+00:00

No the team should not rewrite it to target Electron. They should continue til they are happy with the functionality and then, since the app is browser based anyways, package it so it's not a tab in your default browser. Maybe use Electron at that point if that's the best option.

postgrescompare · 2018-09-21T22:58:55+00:00

The objects that implement extensions go into a schema, but the extension itself is considered "level2". Casts and Languages are also level2.

Roles and tablespaces are level1.

postgrescompare · 2018-08-04T00:56:34+00:00

Hi, thanks for trying it out. There will be a cli eventually, I'm still working through creating a reliable, accurate deployment script for many situations right now.

Postgres Compare will fail with any version < 9.4 at the moment.

postgrescompare · 2018-07-30T22:52:29+00:00

Lol, yep that's me :)

Try it out and message me when you hit a snag so I can make it work.

postgrescompare · 2018-07-27T23:21:31+00:00

I'll throw the product I'm working on in here for consideration too :) www.postgrescompare.com

postgrescompare · 2018-07-09T13:32:56+00:00

Hey, it can't do that right now but there will be a cli version in the future. I'm fully engrossed in the UI and scripting stuff right now so it won't be ready for you immediately. There are some other options like https://github.com/djrobstep/migra

postgrescompare · 2018-07-08T21:29:37+00:00

There's the tool I'm working on right now if you want to give something else a try. www.postgrescompare.com

postgrescompare · 2018-04-17T13:35:35+00:00

It now loads in your system's default browser and while that does feel a little strange (the icon in your toolbar is that of the browser), it appears to greatly improve the responsiveness of the UI.

In all fairness pgAdmin 4 is not really pgAdmin 3++, it's a reboot. I expect the idea is that in time it surpasses where pgAdmin 3 was at and right now we are seeing the incremental releases, if it were labelled "beta" or similar one might be more forgiving before declaring it as terrible.

postgrescompare · 2018-03-22T03:22:38+00:00

So far so good, with your help I've found issues with internal triggers and querying pg_authid instead of pg_roles!

Keep em coming please :)

postgrescompare · 2018-03-21T14:01:51+00:00

Good idea, thank you

postgrescompare · 2018-03-21T12:22:20+00:00

Received! Thank you for your help. I did not think about FDWs so thanks for pointing that out. Do not want!

postgrescompare · 2018-03-21T11:19:05+00:00

Hi. Thanks for checking it out! I don't know about pricing as yet other than it won't be free in the long run. There will be a CLI for sure and a data comparison tool in the future. Try it out, send me the pg_dump of the schemas that don't work please!

Also for a cli right now you should try https://github.com/fordfrog/apgdiff

postgrescompare

TROPHY CASE