1

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?

Mike Gardner
  • 6,611
  • 5
  • 24
  • 34
Praveenks
  • 1,436
  • 9
  • 40
  • 79
  • Please try to search for Linked Server. Please look here http://stackoverflow.com/questions/5145637/querying-data-by-joining-two-tables-in-two-database-on-different-servers – AK47 Apr 08 '14 at 09:32
  • Can I use it in sybase also ? – Praveenks Apr 08 '14 at 09:36
  • I think YES, Check this, http://support.microsoft.com/kb/280102. Or Google "linked server query in sybase" – AK47 Apr 08 '14 at 09:45

2 Answers2

2

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

Robert
  • 25,425
  • 8
  • 67
  • 81
  • Also, if the server you are adding is in the local `interfaces` file, you only need to specify the Servername, and not the IP/port. – Mike Gardner Apr 08 '14 at 13:24
2

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

Vince
  • 734
  • 1
  • 5
  • 10