Hello everyone,

I'm trying to setup a DataSync between an on-premises database and a Azure DB.  Initially I chose "Select all the columns in all the tables" and hit sync.  It appeared to work beautifully until I started comparing the data.  There are two tables that didn't sync at all.

I dug in a little and noticed in the Sync Rules screen, while the two tables were there to select, they were each missing all of their columns, so naturally, they did not sync at all. 

I've tried the below with no luck.

• Refreshed Schema
• Change the DB used to define the Data set from the Azure DB to the on-premise DB and refreshed Schema.
• Changed it back to use the Azure DB for the Data set definition and refreshed again after the above didn't work.
• Created a new Data Sync Group and starting from scratch

Extra notes: 

• The tables do have primary keys, that are not "IDENTITY" generated
• Besides Views and Stored Procedures, the tables do not have any defined dependencies in the Azure DB, which is defined as the Hub.

I appreciate any help, thanks a lot,

Greg

• Edited by GAndora Monday, January 26, 2015 9:16 PM Adding extra notes about the tables in question