DataCompare Issue- Workaround
I have downloaded the CTP and as a DBA was interested to see the functionality of the SchemaCompare and DataCompare Options. The SchemaCompare option ran great and returned very helpful results.
I ran into an issue with the DataCompare feature, however. I used the same connections that had successfully worked for the SchemaCompare and chose a single table to compare the data from, I know this table holds ~9m rows and was using it as a benchmark. After finishing the selection wizard I got a message stating something about connecting to the databases and noticed that both connections had 'Red X Syndrome', I re-ran the DataCompare and chose all tables in the database and then clicked finish and the compare began, I stopped and tried just the single table again, with no success, I also selected just the first 2 tables in the list and that ran, but I could not skip the first 2 tables and compare the third and fourth ones successfully. I don't want to compare data in all my tables (at least not yet) so that I can get an idea of overall timing from this one table. How can I work with only a single table or small subset?
Any help is appreciated. thanks.
