CODEWITHSUNDEEP
sybasesap-ase
Praveenks
Praveenks

Reputation: 1496

How to compare result of two tables present on two different database server

Let's say we have a table on two different database server ( for eg. dev and test). I want to compare the data stored in this table.

Suppose after executing the table on the dev database server, we get 10 values and same amount of data, we get on the test database server. My concern is how to compare the values that comes in each row.

Is there any specific tool for this?

Upvotes: 1

Views: 1189

Answers (2)

Vince
Vince

Reputation: 734

If you own Replication server, you can use the tool rs_subcmp located in $SYBASE/$SYBASE_REP/bin in UNIX environment

Upvotes: 2

Robert
Robert

Reputation: 25753

You are looking for proxy tables. First you should create a server

sp_addserver 'svr_dev', ASEnterprise, '[IP ADRESS]:[PORT]'

Than you can create a proxy table as below

CREATE EXISTING TABLE proxy_test 
at "svr_dev.[db_name].[user].test"

It's only an example, more information you can find here

Upvotes: 2

Related Questions