Comments
Sort by recent activity
Alex B said:
Hi @Nagaraj125, The individual differences are not written to the console (I believe due to the potential to be quite numerous). You will need to include the /Export:<directory> switch (see this page) which will create comparison files - one called "Results Summary.csv" which has the count information and the others are listing the actual differences in each table involved (only that have differences I believe). Kind regards, Alex
Hi Alex, Sorry for the late reply, its been while now. Can you please suggest where can I use switch command to compare the data of two tables. / comments
Alex B said:
Hi @Nagaraj125,The individual differences are not written to the console (I believe due to the potential to be quite numerous).You will need to include the /Export:<directory> sw...
Hi @Alex B Thanks It worked. But I wanted to compare only one table called 'Jobtype'. But even though i used Include command it compared all the tables available in the database. Also I wanted to comparison of actual table data not just the count. How to accomplish that? Please suggest me to actual data comparison of the table data. Below is command used and attached is the result log. sqldatacompare /server1:BANVS-DEVDB12-3\SQL2012 /database1:BCR ^ /server2:BANVS-DEVDB12-3\SQL2012 /database2:BCRDev ^ /Include:table:[JobType] /Verbose >> "D:\Results\log1.txt" / comments
Hi @Alex B Thanks It worked. But I wanted to compare only one table called 'Jobtype'. But even though i used Include command it compared all the tables available in the database.Also I wanted to co...
Hi @Alex B Thanks again. Now I got out put related to only one table. But this time also I got output related to only the count of that table. I am looking for complete table comparison which includes table data and expecting the differences in the log file (same as when table is selected for data comparison in SQL Data Compare 13 UI) will be generated. Could you please help with me this as well. / comments
Hi @Alex B Thanks again. Now I got out put related to only one table.But this time also I got output related to only the count of that table. I am looking for complete table comparison which includ...
HI @Alex B Thanks for looking into this. I tried with above mentioned syntax with table name used as "JobType". But got the error in log file as attached. Kindly suggest on the same. [image] / comments
HI @Alex B Thanks for looking into this.I tried with above mentioned syntax with table name used as "JobType". But got the error in log file as attached. Kindly suggest on the same.
Thanks Alex again, actually above error happened due to space issue which is resolved now as I got the correct log file with count data. However can you please assist me for the scenario where If I want to compare table (not just the count entire table data) what will be syntex. I am trying with below syntax but not much luck: sqldatacompare /server1:servername\instance /database1:Testdatabase /server2:servername\instance /database2:UATDatabase
/Include: table:[Products] / Verbose >> "D:\Results\log.txt" Error says: [image]
/ comments
Thanks Alex again, actually above error happened due to space issue which is resolved now as I got the correct log file with count data.However can you please assist me for the scenario where If I ...
Hi Alex, I have created one project and tried to automate the comparison using below syntax in batch file as suggested by u: sqldatacompare /project:"C:\Users\UserName\Desktop\Project.sdc" >> "D:\Results\log.txt" However the out file generated from above action in the "Results" folder is not giving any conclusive comparison details. It shows only minimal details. Attached is the log file generated for your reference. Could you please assist me on the same if i have missed on anything. Thanks, Nagaraj S / comments
Hi Alex,I have created one project and tried to automate the comparison using below syntax in batch file as suggested by u:sqldatacompare /project:"C:\Users\UserName\Desktop\Project.sdc" >> "D:\Res...
Thanks alex for looking in to this. As mentioned in my last post I wanted to compare tables from two different DB servers. Hence I used below syntax in my batch file (.bat) but it didn't work out. C: Cd C:\Program Files (x86)\Red Gate\SQL Compare 13 sqldatacompare /server1:UATServerName /database1:DatabaseName /server2:TestServerName /database2:DatabaseName /Include: table:[Product] / Verbose /Export: "D:\Results" Also I tried to automate using the already saved project file using below syntax: sqldatacompare /project:"C:\Users\UserName\Desktop\Project.sdc" /Out: "D:\Results\log.txt" But in both the examples it didn't work. Could you please confirm if i am missing anything on the above syntax.
/ comments
Thanks alex for looking in to this.As mentioned in my last post I wanted to compare tables from two different DB servers.Hence I used below syntax in my batch file (.bat) but it didn't work out.C:...
Thanks Alex for the quick response. I would like to compare few tables from two different databases (Pord and Test) using red gate data compare 13. And same I would like to automate using the batch file. / comments
Thanks Alex for the quick response. I would like to compare few tables from two different databases (Pord and Test) using red gate data compare 13. And same I would like to automate using the batch...