Best command line string to produce compare table that can be imported to a SQL table?
So I'm trying to get the output of a simple SQL compare into a SQL table and go from there. Some things I'm running into, at first I was using SQL Compare 13 and it turns out it's XLS/Excel output is much different than what you'd get with the same command in SQL Compare 14. 13 basically just lists the objects while 14 lists the objects and their entire DDL differences. Is there a way to get the 14 output to match the 13 output? As in, not as rich? I just need the objects.
My main goal is to get this data into a SQL table itself, anyone ever done this and/or have tips on what output would be best? I'm probably going to have to set up a SSIS job to run the command, grab the output and then input into a SQL table.
0 · Share on Twitter