Nandini
Reputation: 65
data comparision between two different database fails in ssdt visual studio 2013
I tried to compare two different databases objects/schema in ssdt visual studio 2013. Both the databases have similar tables. while comparing all the tables are not detected. what might be the reason ? can some one help me on this ?
Upvotes: 0
Views: 51
Answers (1)
Peter Schott
Reputation: 4726
Most likely a lack of primary keys (maybe unique keys/constraints). If you need more flexibility, Red-Gate's SQL Compare has more options to define columns to use in the case that there aren't any defined unique constraints.
Upvotes: 2
Related Questions
- How can I switch my signed in user in Visual Studio 2013?
- Using SSIS BIDS with Visual Studio 2012 / 2013
- Visual Studio SSDT Data Compare how to compare two tables in a single database
- Visual Studio SQL Server Data Tools Comparison Mappings
- Deploy multiple SSDT database projects from Visual Studio 2013
- Install Visual Studio 2013 on Windows 7
- Visual Studio 2013 SSDT - Support for SQL Server 2008 R2?
- Visual Studio 2013 - DB Data Compare
- SSDT on Visual Studio 2012 broken then fixed, broken again also broken on VS2013