Activity overview
Latest activity by gvsoft
SqlDataCompare SDK Options
I have used the SqlCompare SDK in the past, and today I wrote a new tool using the SqlDataCompare SDK. However, I am unable to find the comparison options related to data compare. All I can find ...
Andrew,
It looks like the basic functionality we need is there. I tested with a new and a dropped index, and both cases resulted in what I expected. One possible concern would be if someone had created an object with the same name but wrong/different definition, in which case, we would want to drop and re-create the object (not ignore/skip it just because it already exists). That should be a very rare occurrence, but it did come up in the conversation I had with a co-worker.
I've enabled the option in the application I wrote to generate the scripts using the SQLCompare API. We'll try it out for a while and see if there are any problems or gotchas that we need to watch out for, and will let you know if any come up.
Thanks again,
Dennis Jones / comments
Andrew,
It looks like the basic functionality we need is there. I tested with a new and a dropped index, and both cases resulted in what I expected. One possible concern would be if someone had c...
Oh, thank you. I've seen that option, but didn't think it was applicable to our scenario. I will try it and let you know what happens.
Dennis / comments
Oh, thank you. I've seen that option, but didn't think it was applicable to our scenario. I will try it and let you know what happens.
Dennis
Synchronizing when schema could be different than expected
We have an automated process to create our upgrade scripts from a known database. We assume customer databases will look like our database (because it *should*, as long as nobody messes with it), ...
Brian Donahue wrote:
I got the list of reserved characters from MS-DOS documentation and that list does not include the hat ^. Hat is the escape character so AFAIK you don't need to escape it? At any rate I did test it on the command line.
But this is a different point altogether, the program is broken and using the correct syntax will not help you.
But because '^' is an escape character, it cannot be used by itself without being treated like an escape character. Therefore, to have it treated like a normal '^', it must be escaped as "^^".
Try this in a batch file: @echo This is a hat: ^^
@echo This is an escape: ^
The first line will display a single '^'. The second will not. In fact, it will cause problems in the batch if left alone.
Can I expect a fix to the program any time soon? / comments
Brian Donahue wrote:
I got the list of reserved characters from MS-DOS documentation and that list does not include the hat ^. Hat is the escape character so AFAIK you don't need to escape it? A...
Well that's a relief!
I should also point out that I am attempting to do this from a batch file. So I am pretty certain that need to escape the hat '^' character, hence my use of:
^^Report$
I eagerly await a reply. / comments
Well that's a relief!
I should also point out that I am attempting to do this from a batch file. So I am pretty certain that need to escape the hat '^' character, hence my use of:
^^Report$
I eage...
Using ExcludeColumns switch correctly
Hello,
I am using SQL Data Compare from the command line. I want to exclude a couple of columns on a table named, "Report". I am using the switch like this:
/excludecolumns:Report:CreatedTime,Mod...
What happened to this requested suggestion? Did it get tossed out? Four years later, version 2.0.3.1 still doesn't have this capability. / comments
What happened to this requested suggestion? Did it get tossed out? Four years later, version 2.0.3.1 still doesn't have this capability.
What is the status of this bug? I have DG 2.0.3.1 and it still has the same problem. / comments
What is the status of this bug? I have DG 2.0.3.1 and it still has the same problem.
I take it back...it doesn't work. It works, but it uses the data currently in the database as the source, not the generated data values. I want it to use the generated values from the other column. Is this even possible?
- Dennis / comments
I take it back...it doesn't work. It works, but it uses the data currently in the database as the source, not the generated data values. I want it to use the generated values from the other colum...