Comments
Sort by recent activity
OK well I couldn't replicate it but one of the testers has managed to. The case is that if the field in your custom comparison key has more than one null value and the table that you are migrating to is empty or has less records than there are null values in the source table.
We'll get a patch into the upcoming version for you.
Thanks for finding it. / comments
OK well I couldn't replicate it but one of the testers has managed to. The case is that if the field in your custom comparison key has more than one null value and the table that you are migrating ...
Can I ask you to confirm which version you are using of SQL Data Compare - you can find this out by going to the menu help->about. There was a problem with something similar to this in an older version where a table was empty and a custom comparison key was being used.
I've just checked on the version that I have on my machine and it seems
to be working ok.
Thanks. / comments
Can I ask you to confirm which version you are using of SQL Data Compare - you can find this out by going to the menu help->about. There was a problem with something similar to this in an older ver...
OK I've tried and I can't replicate internally. Is there any chance you can pm me the schema information and data for the table that is having the problem. We are releasing a patch soon and hopefully I can get a fix for this in time.
Thanks / comments
OK I've tried and I can't replicate internally. Is there any chance you can pm me the schema information and data for the table that is having the problem. We are releasing a patch soon and hopeful...
The full command line documentation is at http://documentation.red-gate.com/displ ... mmand+line (we're working on the documentation currently)
You'll need to modify the /behaviour and /ignore options but this should give you just as much control over the tool as using the Schema Compare for Oracle UI. / comments
The full command line documentation is at http://documentation.red-gate.com/displ ... mmand+line (we're working on the documentation currently)
You'll need to modify the /behaviour and /ignore opti...
You can specify with -b and -i as compound expressions but if you specify -b you must also specify -i and vice versa. Using either clears all options so only those specified on the command line take effect.
The default options could currently be written like the following, although this is quite likely to change as new options are introduced and old options changed for new releases.
-bhdr -isdwqgva
If you use a -project it doesn't use the settings from that project? I've just had a play with this myself and it seems to be ok, in fact if you specify a project it will ignore any of the extra options on the command line in favour of the project file.
What it will do however is pay attention to the objects selected in the UI when using a project file. So it would deploy those objects that would have been deployed had you used the UI and not changed any of the checkboxes.
If you want new objects to be deployed you have to have the all objects checkbox selected in the UI before you save the project.
Hope this makes sense. / comments
You can specify with -b and -i as compound expressions but if you specify -b you must also specify -i and vice versa. Using either clears all options so only those specified on the command line tak...
This is now available. Just hit check for updates in the help menu or re-download it. / comments
This is now available. Just hit check for updates in the help menu or re-download it.
I've just had a look and it seems like there are number of recent options that hadn't made it into the command line. I've just fixed this so it'll be in the next release (hopefully very soon, days/weeks).
Also another possible confusion is that specifying any option either via -ignore or -behaviour clears all the default options. Again I've added information in the command line help to make this clearer what the current defaults would be.
Glad DCO is working for you at least [image] / comments
I've just had a look and it seems like there are number of recent options that hadn't made it into the command line. I've just fixed this so it'll be in the next release (hopefully very soon, days/...
Could you check your settings area before you logout and after you login again as it sounds like there could be something wiping the directories on your network login.
For example my projects are stored in...
C:\Users\richard.mitchell\AppData\Local\Red Gate\Source Control for Oracle 2
The settings (I think) are stored in...
C:\Users\richard.mitchell\AppData\Local\RedGate_Software / comments
Could you check your settings area before you logout and after you login again as it sounds like there could be something wiping the directories on your network login.
For example my projects are s...
Well thanks to Daire we now know exactly what is causing the problem. It is caused by using a UDT in a view on SQL Server 2000. We'll get this fixed as a priority. If in the meantime a workaround is to edit the comparison project and de-select 'Include indexed views' in the Options tab.
Thanks guys for all of your help. / comments
Well thanks to Daire we now know exactly what is causing the problem. It is caused by using a UDT in a view on SQL Server 2000. We'll get this fixed as a priority.If in the meantime a workaround is...
I think if you have the option of going back to 5.0 in the meantime and it worked for you that's probably the best. We're looking into this problem urgently (obviously [image] ) and we're hoping to get a fix out just as soon as we can replicate the problem. If anybody experiencing the problem has scripts or a database backup they can send in that exhibits the problem that would be great, you can email them to support@red-gate.com and mark them for my attention.
A few assumptions we're making on this problem.
1) Only SQL 2000 is affected
2) udts in tables cause the error
3) The problem isn't connected with upgrading a database from SQL 7 to 2000
If anybody out there is experiencing the problem and doesn't match the assumptions I'm interested in hearing from you.
If anybody can give me any more information on exactly how they created the UDT or what script was run to create the problem that would be great and also the exact version of SQL 2000 you're running. Like I said we're unable to re-create the error in house so far.
Thanks everybody for any help in getting to the bottom of this. / comments
I think if you have the option of going back to 5.0 in the meantime and it worked for you that's probably the best. We're looking into this problem urgently (obviously ) and we're hoping to get a f...