Comments
Sort by recent activity
To clarify, the sync script you get from the sync wizard is a script to run on the target database that will make it the same as the source database.
Could you give an example of the sync script it generates going the wrong way, with the differences it should be syncing?
SimonC / comments
To clarify, the sync script you get from the sync wizard is a script to run on the target database that will make it the same as the source database.
Could you give an example of the sync script it...
SCO does not currently support object storage at all; this is something we're hoping to include in the next EAP release. Thanks for the feedback [image]
SimonC / comments
SCO does not currently support object storage at all; this is something we're hoping to include in the next EAP release. Thanks for the feedback
SimonC
Could you try the latest EAP build to see if that has fixed the issue? If it hasn't, could you enable verbose logging as described in http://www.red-gate.com/supportcenter/C ... ta_Compare\knowledgebase\logging_and_log_files.htm, and send us the resulting log file?
SimonC / comments
Could you try the latest EAP build to see if that has fixed the issue? If it hasn't, could you enable verbose logging as described in http://www.red-gate.com/supportcenter/C ... ta_Compare\knowledg...
Whats the dialog or error message that pops up? Is it an actual application crash, or an error displayed on the progress dialog? / comments
Whats the dialog or error message that pops up? Is it an actual application crash, or an error displayed on the progress dialog?
Could you describe the actions you do before the crash, and what the error message is? At what stage of comparison or synchronization does the crash take place at? / comments
Could you describe the actions you do before the crash, and what the error message is? At what stage of comparison or synchronization does the crash take place at?
Is it possible to email me query snapshots of the two databases you're comparing? These can be obtained using the 'RedGate.Oracle.QuerySnapshotter.exe' program in the SCO install directory. These contain the results of the queries we use to register the databases, and will greatly help us in finding & solving the issue.
thanks for the bug report [image]
SimonC / comments
Is it possible to email me query snapshots of the two databases you're comparing? These can be obtained using the 'RedGate.Oracle.QuerySnapshotter.exe' program in the SCO install directory. These c...
For the comparison options, we'll be adding different options as we progress through development (as you probably know, this is a very very early build!)
With regards to the registration and comparison errors, would it be possible to email me a query snapshot of the two databases you're comparing? This can be done using the 'RedGate.Oracle.CreateQuerySnapshot.exe' program in the install directory. This is a binary file containing the results of the queries SCO runs against the database when registering the schema, and will greatly help us in debugging the problems you're encountering.
Thanks very much for trying it out!
SimonC / comments
For the comparison options, we'll be adding different options as we progress through development (as you probably know, this is a very very early build!)
With regards to the registration and compar...
It looks like you haven't installed the ODP.NET assemblies that the program requires. You can have a look here for the required client install settings; you'll need to re-run the oracle client installer and install over the top of your existing install.
SimonC / comments
It looks like you haven't installed the ODP.NET assemblies that the program requires. You can have a look here for the required client install settings; you'll need to re-run the oracle client inst...
Is the object you click on a PLSQL object of some sort? Would it be possible for you to email me the text of the object in both schemas from the all_source dictionary view?
much appreciated
SimonC / comments
Is the object you click on a PLSQL object of some sort? Would it be possible for you to email me the text of the object in both schemas from the all_source dictionary view?
much appreciated
SimonC
SQL Compare only does a column rename when the old and new column names are reasonably similar to each other, otherwise it does a separate drop & add. Currently, you cannot map columns together like you can schemas (this is a feature to be considered for a future version)
The warning is given because SQL Server throws an error if a NOT NULL column is added to a table with data in it and no default is defined on the table. If you try this yourself, you'll find the following error is displayed: ALTER TABLE only allows columns to be added that can contain nulls, or have a DEFAULT definition specified, or the column being added is an identity or timestamp column, or alternatively if none of the previous conditions are satisfied the table must be empty to allow addition of this column.
In these cases, the user has to edit the script themselves to either add a default or perform the rebuild themselves. / comments
SQL Compare only does a column rename when the old and new column names are reasonably similar to each other, otherwise it does a separate drop & add. Currently, you cannot map columns together lik...