Problem with synchronising not all columns in table.

daageu on Mon, 11 Jun 2012 07:42:53

I'm using SQL Azure Data Sync and SQL server 2008R2.

I'm facing next problem:

I have a table:

tblTest
-------
INT                 ID
VARCHAR(25)         COLOR
VARCHAR(MAX)        OBJECT

I'm syncing this table which has a large binary column --> OBJECT.
As SQL Azure Data Sync can't sync my column OBJECT (800MB+) column,
I chose to only sync the columns ID and COLOR in my sync dataset.

What happens now is the following:

1: Add some value to tblTest

tblTest
1 	Red		AX25ZEDASA25151ZDZDZRZZS
2	Red		ZDZDZ25ZDZDZ35AZOOPD331
3 	Black		AZUIT5199ZDZ551ZDXXVBHOP

2: I sync (so only the ID and COLOR are picked in my sync dataset because the object column is too big to sync.

What happens is that I get the next result after I synchronise:

tblTest
1 	Red		NULL
2	Red		NULL
3 	Black		NULL

So all of my inserted objects result into NULL after I synchronise...
As I need the ID's of this table its necessary to synchronise this table.
How can I avoid this problem or is this a bug?

Thanks in advance!