December 7, 2006 at 10:25 am
Hi Does anybody know any good software to create database models?
Also, why does DTS (SQL Server 2005 import/export) take so long now?!
Thanks!
December 8, 2006 at 2:10 am
Hi , for create database model for free try to use DBDesigner developed by a Team called FabForce, it can do reverses engineering also (some little bug but it works well most of the time).
For MSSQL2005 import/export, which type of import/export are you talking about DB to DB , DB to file or else ?
December 8, 2006 at 5:46 am
We use Erwin by Computer Associates. It's pretty nifty. Took me a little time to get used to it, but now I love the Reverse Engineering and Complete Compare tools. With Reverse Engineering, you get all your tables, columns, etc. on the model and then all you have to do is organize it on the chart. With Complete Compare, once you have your model, you can update it from changed schema on the database. OR update the database based on changed schema on the model.
Too cool! @=) Of course, you need some sort of plotter printer to be able to print the models because regular printers squeeze them up so tiny they're impossible to read. @=)
December 8, 2006 at 7:42 am
ERWIN or ERStudio
December 8, 2006 at 8:19 am
Also Database Diagrammer which is part of SQL Srever 2005 SSMS. It does not have logical design layer, but for reverse engineering it's quite good.
December 8, 2006 at 4:28 pm
ERWin and ER Studio are 2 of the best. I have used both of them and prefer ERWin. But it is pricy $3,500 retail. As to the printing issue mentioned, you can also create subject areas and put into each subject only the tables that deal with the subject area and print those subject areas and not the main subject area which contains all of the tables. It helps when looking at big models.
Cheaper and pretty good is Case Studio. I have also used it.
Free... what is wrong with the database diagram tool in SQL Server? You can also create subject area diagrams with it and do about the same as you can with ERWin. It is just limited to SQL Server.
December 8, 2006 at 6:51 pm
Robert, while i agree every bit with you on ERWIN and ERStudio.
Specifically the subject area feature in ERWIN is very nice to handle logical portions of the diagram. ER Studio is also very good.
But somehow Enterprise Manager never came anywhere closer to these tools. May be I am wrong.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply