Clone on Data Compare
OK I have a db that has few hundred tables but within the schema I only want to compare like 150 tables. I have a Dev, QA, UAT, Stage, Train and PROD db's which resided in different SQL servers. I just completed a data compare for that tables I want from Prod and Train. Now I cloned that project and reviewed the tables selected which were correct. THen I selected the Data Source tab and changed the connection to a different server and database then clicked on the table&View tab again and I see more then the tables that I just compared using the original project. But not ALL tables that can be selected are selected. So I'm wondering were is Data Compare getting that selected list from? I have also just changed the database and not the server on the cloned project and sill have the same behavior. I also would like to know is the project name would change to reflect the databases that I would compare on the clone project or does it keep the original project name?
0 · Share on Twitter
This discussion has been closed.