Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 Other Topics
 SQL & DB2 Row Count

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-05-06 : 08:12:17
asdsad writes "I need to get the row count for all the tables in two identical databases (SQL and DB2). I was able to get the row count for all the tables in SQL, but not DB2.
I also need to compare the identical tables in two databases (SQL and DB2), and see whether there is any mismatch in the record count for each of the tables. If there is a mismatch, need to terminate the execution. Appreciate any help.

Thanks"

X002548
Not Just a Number

15586 Posts

Posted - 2005-05-06 : 12:39:41
Have you set up a linked server to db2? are you using db2 connect?

Are you trying to build some type of replication?

We need some more details.



Brett

8-)
Go to Top of Page
   

- Advertisement -