How can we help you today? How can we help you today?

SQL Data Compare - Command LIne Output File

I am comparing 2 databases via command line. When I execute the following command:
SQLDataCompare /project:"C:\CompareFiles\compare_AW1_AW2.sdc" /Include:table:[Users] /Out:"C:\Users\mthurman\Documents\outputlog.txt" /verbose

I get the following in my output log.txt:

Redgate Client capability version: 2 SQL Data Compare: trial, edition standard Loading synchronization parameters from project file: C:\CompareFiles\compare_AW1_AW2.sdc OK Comparing database (local)\SQLEXPRESS.AW1 with database (local)\SQLEXPRESS.AW2... Registering databases Mapping Comparing databases Finished

Summary Information
==================================================================================================================================================================================================================================================================================================================================================
DB1 = (local)\SQLEXPRESS.AW1
DB2 = (local)\SQLEXPRESS.AW2

Object type     Name                                                                                                                                                                                                                                                                                                         Records      DB1 DB2 
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Table           [dbo].[Users]                                                                                                                                                                                                                                                                                                          2  <>  <>  
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
OK

The databases have differences and running the compare through the GUI will show what they are. This output log does not show that detail. What am I missing?

Thanks, Matt

mthurman
0

Comments

2 comments

Sort by
  • Tianjiao_Li
    Hi Matt,

    From the posted output I can see Data Compare has found two records exists in both DBs and they are different- this is working as expected. I'm afraid you'd have to use the GUI to view the details of the difference.  




    Tianjiao_Li
    0
  • mthurman
    @Tianjiao_Li Thanks!
    mthurman
    0

Add comment

Please sign in to leave a comment.