Activity overview
Latest activity by AndyScott
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 ...
inappropriate aliasing of fields in a where clause
When typing a query if you type the table in full and do not use sql prompt to fill in the name and add the alias, but do use sql prompt to select the field it adds the alias to the field as the ta...
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
Feature request, missing feature and a bug
The ability to specify the alias for a table would be really useful as the auto selected aliases do not match the aliases used throughout my companies code base which makes reading the SQL difficul...
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?
SQL Data Compare: Re map object screen
It would be useful to be able to order the objects based on the mapping column, you can currently order by object name, type, owner but not by mapping.
This would help in finding tables that have n...
Data Compare: Where clause editor bug
When adding a filter to a table you need to add a trailing space otherwise the compare fails due to incorrect Syntax.
e.g.
"testfield is not null" fails
"testfield is not null " succeeds