The free, open-source SchemaCrawler for SQL Server tool is desinged to
do just this. You can take human-readable snapshots of the schema and
data, for later comparison. Comparisons are done using a standard diff
tool such as WinMerge. SchemaCrawler outputs details of your schema
(tables, views, pro
Le 29/12/2009 21:21, akp geek a écrit :
> thanks for the repsonse. I appreciate it. are there any limitations on using
> this one? Means that we have to the same user on both databases and same
> passwords.
>
> I have used the command following way
>
> check_postgres.pl --action=same_schema -H
Also check this out Very interesting – it can compare data between the DBs
(tables/views). Check this out –
http://www.zidsoft.com/
http://www.zidsoft.com/screenshots.html
Thanks
Deepak
On Tue, Dec 29, 2009 at 4:37 PM, Joshua Tolley wrote:
> On Tue, Dec 29, 2009 at 03:21:18PM -0500, akp gee
On Tue, Dec 29, 2009 at 03:21:18PM -0500, akp geek wrote:
>thanks for the repsonse. I appreciate it. are there any limitations on
>using this one? Means that we have to the same user on both databases and
>same passwords.
>
>I have used the command following way
>
>
thanks for the repsonse. I appreciate it. are there any limitations on using
this one? Means that we have to the same user on both databases and same
passwords.
I have used the command following way
check_postgres.pl --action=same_schema -H 172. -p 1550
--db=myProdDB --dbuser=prodUser -
On Tue, Dec 29, 2009 at 11:43:58AM -0500, akp geek wrote:
>Hi all -
>
> I have postgres running on 2 servers. one production and one
>testing. What would be the best way to compare the 2 database, so find out
>the differences? Can you please advice?
>
>regards
