10 results found
-
Oracle-to-SQL Server migration/synchronization
I have 2 current opportunities with a couple of the largest company's in the US/UK for Oracle-to-SQL Server migration for both and synchronization for 1. This is a big space to get into, but judging from experience with Red Gate in the SQL Server space, I think Red Gate can grab significant market share from the likes of GoldenGate.
3 votesThanks for the product idea. At Redgate we favour tools that have repeat use cases. Platform migration tools are often used once or twice and then shelved. Also, for obvious reasons there are always decent free options provided by the platform vendors.
-
Include a "Open project"-button on dialog upon start-up
A very small wish....
When I start the program, a dialog-window with the latest project worked on is shown. That is good as long as this often is the project I shall work on.
But could you please add a "Open project"-button on this dialog.
1 voteYou can double-click project files to start the tool with a comparison loaded.
-
Provide an parameter to allow Schema Compare for Oracle to execute serially. I am frequently, but not alway getting Memory Exceptions when
Provide an option to allow Schema Compare for Oracle to execute serially. I am frequently, but not always, getting a Memory Exception when using Schema Compare for Oracle. The error always occurs during the “Registering database one” and “Registering database two steps”. These steps always run in parallel. It also always occurs during the “Populating table columns” part of the step. If I could run this serially, I think these errors would go away.
1 voteUsing the 64-bit version of the tools is believed to have fixed this issue.
-
Streamline the workflow
Hi,
I am developing on my local machines and then deploy to my customer's development machines. I am deploying at least 2 to 3 times a day to at least 2 different databases.
Every time I do this I get the OCP selection box, cancel, select the OCP file I need, click on compare, click on the differences I want to deploy, click on deploy, click on next (I always deploy directly to the destination), click on deploy now, click on are you sure.
I'm sure this can be streamlined and simplified. Don't use modal dialog boxes on top of…
1 voteIf you’re doing something very repetitive it may be worth trying to configure the command line so that it can do what you require. http://documentation.red-gate.com/display/SCO3/The+command+line+interface
-
Only prompt for save if options have changed
Hi,
First, thanks for this tool. It has been a life saver for me.
Secondly, everytime I do a compare it requests to save changes to the ocp file. Everytime I sit there and think about whether I changed anything or not. Most often I haven't.
It would make life easier if it didn't prompt every time.
Regards.
1 voteA project is modified if you change the selections to deploy as these are stored with the project.
-
Add an ignore option for Schema Compare to skip when errors occur, e.g. Error: Object reference not set to an instance of an object
Error: Object reference not set to an instance of an object is displayed and Schema Compare stops. It would be better if it were possible to continue beyond this error and just have a logfile of errors with details of the objects that failed.
1 voteThe problem with supporting this is that once the first error happens (e.g. failing to populate a table) the errors snowball (now the view that uses that table fails, the index for that table also fails) to such an extent that it’s very difficult to find the first failure.
Submitting error reports to us is the best way to get fixes.
-
Schema Compare - Local Indexes
when migrating indexes in schema compare,bitmap indexes on a partitioned table fail - local clause missing
1 voteYou have to turn off “ignore storage” to copy partition information from one database to another. I am in the progress of making this option more granular.
If you are submitting a bug report support@red-gate.com is the best way.
-
The function of Schema Compare that compares schemas with script folders has the problems that it ignores all extentions different than sql.
It would be useful to support files with different extensions, either by allowing to configure ignored extensions (all other will be treated as sql) or by allowing to configure extensions for specific types of objects.
2 votesWhat scenario are you trying to support here? We only support comparing to sql that we have generated initially and we always save the files ending in .sql.
It may work against arbitrary sql files (and I tend to fix issues when they’re reported) but it’s not something we “support”.
Without further information I’m closing this request.
-
Synonym comparison limitations?
I have a schema where synonyms are not being compared correctly. In particular this is a synonym that refers to a remote object. Is this a known limitation of Schema Compare?
2 votes -
Problem with report generation
after doing a schema compare which ran fine .. the report has several rendering issues (icons) . the big issue is this report contains three sections (different, create, drop) .. expanding second section (create) will not to scroll past second section .. cannot see third section when second section is expanded
1 voteWe’ve not received any more feedback on this issue so we’re closing it for now. If you’d like to provide more info in the future, please email oracle@red-gate.com or post a message on the Schema Compare support forum.
- Don't see your idea?