Hi Every one,

I am mostly an asp/asp.net and db developer. In terms of teh data base I have writtn many stored procedure but none of them has ever been dealing with data transfer across the instances.

Currently I have also some dba tasks which are:

Migrating look up tables/changes in production.
Comparing databases/tables/constranits between instances and making sure they are all the same...


Any idea of doing this? any automated process without third party tools?

Thanks and very appreaciated.