[Last Call] Learn how to a build a cloud-first strategyRegister Now


Table Not visible when doing Data Compare

Posted on 2011-04-19
Medium Priority
Last Modified: 2012-05-11
I am using the Data Compare tool built in VS 2010, to move data from dev to test, when I plug in the connection values for dev and test and go to screen to select talbes , i can see every table excpet one table , i have checked the permissions on both of the table they are the same, can anybody suggest me what might be the reason for this
Question by:mannsingh3
  • 3
LVL 26

Expert Comment

ID: 35427780
did you check the table schema owner?

Accepted Solution

mannsingh3 earned 0 total points
ID: 35427803
I found the problem , the table in dev did not have the primary ket set on it

Author Comment

ID: 35427808
close it

Author Closing Comment

ID: 35455612
I found the problem on my own

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question