Data comparison between DEV vs QA

  • All,

    DBA team has populated data and logins from DEV server to QA server recently. I have to ensure that the data and logins has been moved correctly.

    My question is:

    1) As a developer perspective, How to do comparison between these tow servers apart from the list i mentioned here.

    2) As a DBA perspective, How to do comparison between these tow servers ? As I am not aware of DBA side, It would be appreciable if anybody give me from the basic steps to advance steps.

    Inputs are welcome !

    karthik

  • The best way is to go out and get a compare product like RedGate's SQLCompare. Another option is to script the databases and use a text compare product like Windiff.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply