Post reply

Data Modelling an existing database

  • October 26, 2010 at 8:53 am

    #230941

    I have been assigned a pretty huge task at work. I have been asked to create a data model for the entire database. This database is a mysql database and they want explanation on every column. In addition to that my boss also wants the complete process flow and how the data comes in and what each step does. I am totally clueless on what approach I should take. I could reverse engineer using Visio. Initially i thought it would be easy to create the model using Visio. Since there are no relationships, I need to create them in my diagram manually. Has anybody else had the same project at work? I am looking for some smart and efficient ways of doing this.

    Thanks in advance.

  • October 26, 2010 at 9:20 am

    #1242365

    what a pain; too bad you can't go smack the developers for not adding relationships in the first place....that's so wrong. In some countries, that an offence punishable by cane-ing.

    I would create a copy of the database, and start adding relationships just as you describe, as you discover them.

    then i would use Visio or some other tool to create the diagrams.

    Since this is a SQL related web site, I'd use the Microsoft MySQL Migration Assistant to copy the DB to SQL Server, where i'm more comfortable, and then do the work above.

    this page has a link to the Migration Assistant:

    http://www.microsoft.com/sqlserver/2008/en/us/compare-mysql.aspx

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply