Question

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!


Sponsored



Replies

JuneT on Mon, 11 Jun 2012 08:14:59


did you deprovision the sync group before removing the column?

daageu on Mon, 11 Jun 2012 08:23:18


As I created the sync group I chose not to sync that column so I think that can't be the problem and what does deprovisioning do and how do I deprovision ? (Is it not possible to edit the sync dataset and redeploy?, do I always have to delete the whole DB from the group and deprovision it ?)

Thanks for the reply!

JuneT on Mon, 11 Jun 2012 08:44:02


because you may have different stored procs applying changes to the same table...

Charles Shen - MSFT on Mon, 11 Jun 2012 14:45:20


As I created the sync group I chose not to sync that column so I think that can't be the problem and what does deprovisioning do and how do I deprovision ? (Is it not possible to edit the sync dataset and redeploy?, do I always have to delete the whole DB from the group and deprovision it ?)

Thanks for the reply!


Since the table is already provisioned, reprovision will not help in this case, you have to deprovision and provision again.