| gmcbath |
| Newbie |
|
|
|
|
| None Specified |
|
| Friday, September 29, 2006 |
| Saturday, November 29, 2008 1:51:23 PM |
4
[0.02% of all post / 0.00 posts per day] |
|
I have DatabaseSpy 2008 Release 2 and want to know if there is an option to reverse enginner a database design from an existing database.
I want the tool to be able to accept a connect, scan the existing database for tables, fields, and relationships and drop them onto a design surface so I dont have to create everything from scratch.
I scanned the included help file and didnt see anything about reverse engineering.
Thanks very much!
|
Gandalf, thank you very much for the response. Everything sounds good.
There is simply not enough time or resources to get everything in a 1.0 release before it's time to launch.
I purchased 2 years of maintenance since it was a 1.0 release and will happily wait for my updates!
|
I just purchased my DatabaseSpy and have a few questions that perhaps someone can answer:
I am using SQL Server 2000 and an XP SP2 machine.
Comment (1) - In the SQL query designer if I drag and drop a table the results are in CAPS such as SELECT [AFW].[dbo].[FirstName], however when I use the auto-complete option everything is in lower case such as "inner join."
Question (1) - How can I make auto-complete display UPPER CASE keywords?
---***---
Comment (2) - I am used to the query designer in Access 2003 where I can drag and drop tables and then graphically join the tables and select inner, left, and right join options.
Question (2) - Does DatabaseSpy allow me to drag and drop tables on the query designer and then graphically link them together?
When I reviewed the tutorials on building queries, they ask the user to load predefined queries that are installed with DatabaseSpy, and some of them have joins, however I didn't see any tutorials on how to graphically join tables.
---***---
Comment (3) - When using auto-complete in the query designer, once I type "se" and hit return (presumably auto-complete keys on the SELECT keyword), the tool starts reading all of the tables in my database which can take quite a while.
Question (3) - How can I abort this process once it starts?
I have tried ESC, CTRL+C, CTRL+break, but to no avail. I have to kill the process with Task Manager.
---***---
Comment (4) - In addition to standard data types like int, decimal, nvarchar, some of my SQL Server tables have data types that are user-defined data types that I load with the system proc named sp_type.
DatabaseSpy generates errors when it reads a table with fields that contain user-defined types.
Question (4) - Does DatabaseSpy support SQL Server user-defined types? If not, is that planned in the future?
---***---
---***---
---***---
That's all for now.
I own XMLSpy Suite and UModel in addition to DatabaseSpy and have software maintenance on them all! Great products!
Thanks!
|
|
