Sometimes I just want to compare selected tables in 1 database to selected tables in another database but with different table name. For example, database 1 has table named X and in database 2 has table named XY. I need to just compare X to XY. Can this be done.
Comments
1 comment
-
No, this isn't possible in SQL Compare (although it is in SQL Data Compare!). You're not the first to ask for this so maybe it will make it into the product one day, but sadly not for v8.0. You might try creating a view with the same name as the table, and comparing using this?
Thanks for the feedback,
David Atkinson
Red Gate Software
Add comment
Please sign in to leave a comment.