Comments
Sort by recent activity
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
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.
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...
Nevermind. Problem solved...I had the "Shuffle data" checkbox checked. Unchecking that gave me the result I was looking for.
- Dennis / comments
Nevermind. Problem solved...I had the "Shuffle data" checkbox checked. Unchecking that gave me the result I was looking for.
- Dennis
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...
Eddie,
Thank you for your reply. I do not want to apply a CSV to the entire table, but rather to a *subset* of columns in a table (some values may be random, others I want to be based on data that is associated together from a CSV file).
Your instructions match what I *used* to see all the time in the previous version of the product (which I had only recently purchased, so my familiarity is fairly low), but now the option for CSV under the Generic category is not there in *some* cases.
For example: I have a table called, "Room," with 4 columns, two of which are NVARCHAR types. On one column, "Phone nvarchar(20)," I *do* have the option of CSV. But for the other column, "Description nvarchar(50)," the CSV option is *not* available. How is that possible?
Here are some snapshots:
1) Here is the phone field, which *does* have the CSV option: [image]
2) And here is the description field, which does *not* have the CSV option: [image]
- Dennis / comments
Eddie,
Thank you for your reply. I do not want to apply a CSV to the entire table, but rather to a *subset* of columns in a table (some values may be random, others I want to be based on data that...
Eddie,
Here is my version information:
OS: Windows XP Pro 64-bit (sp2)
SQL Express: 10.0.1600.22
SQL Data Generator: 2.1.0.3
SQL Compare: 10.1.0.102
- Dennis / comments
Eddie,
Here is my version information:
OS: Windows XP Pro 64-bit (sp2)
SQL Express: 10.0.1600.22
SQL Data Generator: 2.1.0.3
SQL Compare: 10.1.0.102
- Dennis
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.