Comments (3)
Hi @blaluc ,
If i understood well, the purpose of this tool is exaclty what you intend.
I mean, no matter if database objects are in the same database but with a different schema (other than "public") or in different database.
To configure it you should follow the documentation, in there you will find a JSON.
In our experience we use it for different databases, i never used it to compare different schema on same database. (that should be exactly what you ask).
Did i helped you?
from pg-diff.
I read the json config, but I still don't understand how to configure the following scenario:
I have the source db with its connections params.
I have the target db with other connections params.
...so far so good, the documentation i clear.
Now I want to compare the schema named 'dev' on the source db with the schema named 'test' on the target. Where should I specify the two schema names?
In the options/schemaNamespace/namespaces node I see a flat list of schema names. How can I declare the mapping of the schema 'dev' on the source to the schema 'test' of the target?
from pg-diff.
Hi @blaluc
Sorry, I misunderstood your use case.
Actually it's not supported. It is like you want to compare two classes in different namespace or package. It is essentially an logical error; in any case, how should I recognize if two table having same name but in different schema must be compared? Just in case you have to consider that there are many potential unwanted comparison that will produce of course a wrong sql patch.
In any case I'd like to investigate further about this feature.
from pg-diff.
Related Issues (20)
- Feature request: some options and defaults for file handling HOT 6
- Feature request: Remove the need for the 'namespaces' field in the config HOT 3
- Redshift compatibility HOT 1
- Feature Request: Compare comments HOT 6
- Column Does not Exist HOT 8
- Data Compare - Arrays HOT 5
- Options to remove IF EXISTS (and similar) statements from generated scripts HOT 5
- Schema not specified for `COMMENT ON INDEX` statements, leading to RELATION ... DOES NOT EXIST HOT 3
- Data compare doesn't detect updates of NULL values HOT 2
- Triggers not implemented? HOT 3
- Please provide sample diff output in documentation HOT 1
- How to generate separate scripts for Functions only and Tables Only HOT 1
- Disabling comments HOT 1
- create type not implemented? HOT 1
- migration option historyTableSchema HOT 1
- SSL options HOT 1
- Feature Request: Support for Incremental Materialized Views HOT 1
- Connect to AWS RDS HOT 1
- Problem if use SSL connect HOT 1
- Need support for BYTEA type for data comparison... HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from pg-diff.