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!
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.