Unable to compare Diagram with database

[dancj]

Where is that setting? I can't find it.

[donose.mihai]

1. The setting for the memory is located on: C:\Program Files\DbSchema\DbSchema.bat (Edit with Notepad)
2. See the attached images

[dancj]

Thanks, but is there any way to get at those settings without creating a new project? When I create a new connection for an existing project I get the same connection dialogue box, but not the Database Objects one.

[donose.mihai]

Please let me understand, so the project your working on it's offline?
It would be great if you can post some screenshots.

[dancj]

The project is online - created using the cops2 connection in the attached pic. I guess I didn't untick procedures when I originally created it and now I can't find a way to do so - but I've put hours of work into the layouts in this project and don't want to have to create a new project just to unselect procedures and packages.

I tried creating a new connnection (COPS2 in the pic), but that didn't help.

[roberto]

You can do some tricks to fullfill your target:
1. the project file is an XML. You can reimport the schema in a new project file and copy over the layouts from one XML in the other. During the import get rid of the outofmemory exception by not importing the procedures.
2. If you select all / some tables in the layout or tree you have a option 'Refresh' which should do the synchronization only for the selected tables. Usually the synchronization would import again all tables, which will lead to out of memory problems. But doing so you will again not import all objects.

Hope this will help,
Roberto Luca

[dancj]

Thanks.

The XML editing method works to update the file (losing the virtual foreign keys though - sadly). Unfortunately if I then try to compare this new file it looks at all of the procedures and gets a memory leak again, so as it stands I'd need to do this every time I refresh the file.

This will tide me over until the new version is released though.

Thanks again.

Dan

[donose.mihai]

Hi Dan,

Can you please let us know if in the latest version your issue has been fixed?

Thanks

[dancj]

It's not giving the error any more - and it's going much faster.

Unfortunately it claims there are no differences even though I just added a column to a table.

[donose.mihai]

Did you edit the schema mapping?

From the menu:

Databases -> Edit Schema mapping