Devart Forums

gregor wrote:Same problem is with dbforge. fbForge cannot connect on x64 windows. Direct mode is working ok...
Gregor

If you mean dbForge Studio for Oracle, we are aware of this problem and working over it. As a workaround you can install 32-bit Oracle client.

This is a known issue. Because of the deeper problems with MySQL metadata, which might be hidden in your case, we decided to assume that there are no databases (database objects) on one server with names differing ONLY in letter case.

We've created a special forum powered by UserVoice for discussing new functionality of the next versions of dbForge Studio for Oracle:

http://devart.uservoice.com/forums/1328 ... for-oracle

If you are interested in our product, we offer to participate in forming the feature list for the next version. There you can write your feature requests or vote for the features on the list.

Devart Team

Unfortunately, UNION statements are not supported by Query Builder.

You need to design first query, copy its text to another SQL document.
Then design the second query and append its text to the first one (putting UNION between).

When we work over a new version of a product we release hot-fixes only for critical bugs that have no workaround. Otherwise is will cause unnecessary delays in a new version release.

I cannot promise you this feature in the near future.

It seems that although "Add Folder" option is available to Oracle Database Project in VS2010, however it doesn't create physical folder and as the result it does not reflect the files that we add to the folder.

The workaround for this problem is to create folder on disk manually, move file to this folder and add it as an existing file.

Another issue that exists is that it is not possible to add the project to Team Foundation Source control through VS2010 and TSC check-in/check-out functionality is not available for Oracle Database projects.

Source control integration is not supported.

Unfortunately, you cannot deploy project from command line or from MsBuild.
We'll consider adding this feature to the future versions.

We've checked both installations by downloading and running them. Both work fine. We suppose that the problem is on your side.

By default Triggers and Indexes are checked to be exported on the Wizard Table/View settings, however upon exporting only Triggers are exported and indexes are not

I'd checked that indexes were exported before answering. Maybe problem lyes deeper.

Would guide me to "Security Manager"? Is it in Devart tool or Oracle out of the box tools?

Main Menu->Tools->Devart OraDeveloper Tools->Database->Security Manager

myaesubi wrote: Although in the Oracle Wizard project, it asks for importing Indexes and Grants, however when I finish importing, no index or grant is imported.

Indexes are exported successfully (please check Table/View settings group on DDL Generation Options page of the wizard).

Users and grant currently cannot be exported with this wizard. As a workaround you can open Security Manager, select required user and run Generate DDL comand from the popup menu. Then include created file into project.

myaesubi wrote: There are no option available to re-run the wizard after the project is created and re-import the database objects again!

Indeed, there is no such option. You'll need to delete the old project and re-create it again.

I agree that propagating spot changes is not worth of separate tool. Its primary purpose is to detect schema differences and perform major schema upgrades.

Right now we are developing tool that accomplishes this task. It's called dbForge Schema Compare fo Oracle

Early access preview is already available. Later we plan to integrate it to Studio.

Try to increase the connection timeout. Default value is 15 seconds. You can find this setting in Database Connection Properties dialog box on Advanced page.

No, the program won't do it automatically, I meant changing your database schema.

If you change comparison key for a pair of tables this does not affect dependent tables.
In your example data in CROSS_TAB remains different.

We are about to release the version 2.0 of Data Compare for Oracle.
In this version there is a workaround for comparing data in CROSS_TAB without changing the main schema. You can create a view (e.g. vCROSS_TAB) referencing IDENT columns instead of IDs. Then you compare the views and see that data is equal.