Comments
Sort by recent activity
We use 2 copyto locations, one is for offsite backups and another is for storing backups for archiving to tape. It would be really nice to be able to specify different timeframes for local backup files as well as different durations for each copyto location. / comments
We use 2 copyto locations, one is for offsite backups and another is for storing backups for archiving to tape. It would be really nice to be able to specify different timeframes for local backup ...
Hi Bart, I forgot to say I am running SQL promp3.0 in Query Analyser.
Andy / comments
Hi Bart, I forgot to say I am running SQL promp3.0 in Query Analyser.
Andy
Thanks for the response, I will carry on playing around with the primary key problem until I find a suitable solution / comments
Thanks for the response, I will carry on playing around with the primary key problem until I find a suitable solution
The where clause on a table is great as we have tables that have system types and client specific type data in them, the where clause allows me to only synchronise the appropriate rows.
Would it be possible to specify a columns value based on a sql statement eg
the primary key on a table is an int(not seeded) when adding rows to the target table the primary key needs to be max +1, as the Primary keys are not seeded and do not match up between different roots, I exclude this column in the comparison, unfortunately the Insert fails as the Primary key is Null if I could specify the field as sql statement the insert would not fail.
I have not used the checksum feature yet, I will have a play later on
Andy / comments
The where clause on a table is great as we have tables that have system types and client specific type data in them, the where clause allows me to only synchronise the appropriate rows.
Would it be...
Can this clone option be added to SQL Data Compare as it is only available on SQL Compare? / comments
Can this clone option be added to SQL Data Compare as it is only available on SQL Compare?