Protecting A Single Cell Of Data

[Mike Penta]

Hello –

I think I got myself in a bit of a bind – a database that I'm trying to sync locally has a single column in a table that I do not want updated. The rest of the data in the row would update – but that single column needs to be filtered. From my tests – this doesn't seem possible.

Is there any way in SQLyog to filter this out OR (and I'm not against) a simple manner to tie an UPDATE query at the end of a sync, that could run immediately after from the command line? (I'd essentially change the data right back if it was changed or not) I'm still learning the program, so I'm not sure what its capable of.

Thanks

(ps sorry the about title – I meant column, but I posted before rereading myself)

[peterlaursen]

If I understand you correctly, you can do this:

create a batch file that exectues

– a SJA sync job

– a SJA notifications job that does the UPDATE

and you can execute and/or schedule the .bat file

refer to: http://webyog.com/faq/27_35_en.html

[Mike Penta]

peterlaursen wrote on Jun 16 2007, 03:04 AM:

create a batch file that exectues

– a SJA sync job

– a SJA notifications job that does the UPDATE

and you can execute and/or schedule the .bat file

Perfect – I knew the program could do this, I just didn't know where to look. It works just as I need it to, thank you.

I wasn't certain if your answer was also an answer to my 'can you filter out certain columns from the updating process,' so let me describe what I meant with a little more clarity. It would be a great feature if it wasn't one.

Lets say I have a table with 3 columns: A – B – C. They each have several rows of data. And lets say the data in column B I want to be left unchanged.

Currently – If I have the sync look at column A and C, and it finds a checksum difference – It replaces the whole ROW. This means the data in column B is overwriten.

What I would like to have happen – Have the sync look at column A and C in each row, and if it finds a checksum difference, it only replaces the data in Column A and C, and not changing the data in column B.

[peterlaursen]

No .. you cannot 'filter out' columns.  SQLyog/SJA data sync will always sync complete rows.

The specification is used to select only specific columns for calculation of checksums and not sync.

If for instance you have a unique column (more than the PK) you can speed up things by onlyusing this one for checksums.

Please refer to the article (that still is almost correct):

http://webyog.com/en/whitepapers/Using_SQL…L_Databases.pdf

[peterlaursen]

and btw: I think your request is extremely dangerous (though of course there will always be situations (users + data) where everything may make sence).  That would very easily become a 'out-of-sync tool' that way!

The only solution I can propose right now is to 'split' the table into two or more tables – one with data that shall sync, another with data that shall not.

[Author]

Posts