New Schema is not showing up in mapping
I am trying to compare tables in 2 databases on different servers (both are SQL 2005). I have SqlDataCompare 184.108.40.206. The problem is that I created a new schema called 'rpt' on both databases and created tables within the 'rpt' schema on each database. The tables have the same names on both databases, e.g. rpt.Table1, rpt.Table2 etc. Now I am trying to compare the data in those tables but the Tables & Views tab in Project Configuration is only showing me tables in the 'dbo' schema. How do I get it to compare the tables in the 'rpt' schema? I tried clicking the 'Refresh' button on the Tables & Views tab, but that did not help. Also, on the Tables & Views tabs, it does not show me the schema of the object, i.e. 'dbo' etc. so it is difficult to know what is being selected when there is a dbo.Table1 and also a Table1 in a different schema, e.g. rpt.Table1.
0 · Share on Twitter