SQL Power Software Forum

Cool thanks

Hemiptera

When using the find function the resulting list of found objects should be sortable.

I think you're thinking of a much heaver weight refactoring tool.

Right now I'd be happy with it just spitting out the scripts (with an option to run) and updating the playpen. Kind of like a variant of the forward engineering feature.

Milestones would be nice, but it's not a critical feature. At least not for me. I can handle the milestones myself. Perhaps it should be designed with milestones in mind, but I think actually implementing them would be overkill.

I wouldn't go for changes from any state, that seems like you're asking for DB corruption. Milestones would be the way to go.

Hemiptera

It would be nice if the architect had some explicit support for refactoring a DB kind of like the Eclipse refactor menu. I'm sure there are a number of common task that we could automate.

The few that would be useful to me at the moment are.

Merging two one to one tables

Breaking a table up into two tables (or 3 if I decided I needed a many to many relation).

I'd also like to deal with a few more pathological cases. We have some data which should be in a normal many to one relation, but either it's all in extra columns in one table or we have the first n in the parent table and the rest in a child table

. I'd like to be able to move these into a normal 1 to many relation.

Oh and one to replace natural identifiers with surrogate keys.

I'd be willing to give you guys a hand with this. Let me know how, any concerns with this idea, etc..

Hemiptera

If you run the ddl generator and have too many quick fix errors, any buttons get lost off of the bottom of the screen.

For testing and deployment purposes I'd like to find out if the structure and the data in a new database is identical to our basic clean environment. The compare DM tool does the structure. But there is nothing that lets me compare the tables. Would it be possible to add a tool that lets me choose a subset of the tables and lets me compare the data.

Oh and a test connection on the the new connection dialog would be nice.

Hemiptera

Could you guys add a way to move data between databases?

Hemiptera

Why is anti-aliasing disabled by default?

Hemiptera

Hi,

I was poking around the preference window when I noticed you have some sort of error reporting. What's the deal on that?

Hemiptera

Hi,

When I connect to a database the first database is black and all the rest are greyed out. Why is this?

Hemiptera