![]() ![]() ![]() SqlDBM was in beta at the time, it may have had settings or configurations available to adjust this problem… but I set it aside and tried a few other tools. Well, the generated script would not completely execute due to foreign keys, certain tables need to be generated first. I am not aware of any table (or entity) limitations, but after 21 tables I wanted to test the creation script and make sure everything would work before I got farther along. I reviewed a few and the one I chose to try was SQL Database Modeler. So, when I went looking for a data modeling tool to assist in visually designing and laying out related tables, I didn’t want to purchase an expensive tool, maybe some free tool or online service would do. So, with the database concerns and other architecture and security concerns, I pushed to do a re-design of the database and re-write of the web application.īesides this database, our other databases are small and/or not complicated. ![]() For those DBA’s that found this article, it would be a nightmare. At work our primary web application is supported or driven by a database that is not relational, has lots of redundant data, some tables don’t have Keys, there are not Foreign Keys or indexes. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |