Post reply

Reverse engineering a 2005 database with Visio

  • November 30, 2005 at 4:38 pm

    #166699

    Has anyone successfully reverse engineered a SQL Server 2005 database with Visio Enterprise Architect? I have a database and am trying to create an ERD. I try to go through the reverse engineering wizard, but there is no driver for 2005 listed in the top dropdown. If I use a generic ODBC driver, it complains that some features will not be available. It then gives me a diagram with tables but no FKs. I have MDAC 2.8 SP1 installed. Any ideas?

    There is no "i" in team, but idiot has two.

  • December 1, 2005 at 4:40 am

    #606995

    Are you using VS2003 for Enterprise Architect or VS 2005 for Enterprise Architect?

    http://msdn2.microsoft.com/en-us/library/ms182014.aspx

    I know it is confusing but for VS 2003, Visio is 2002 (barely supports SQL2K, no UDF, Default constraints, etc.) and for VS 2005, Visio is 2003 (probably has bugs for SQL05).

    Oh the Fun being an early adopter, eh?

    Andy

  • December 1, 2005 at 8:11 am

    #607072

    can't you still use the standard driver for SQl server to connect to a SQL 2005 database?

    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 3 posts - 1 through 3 (of 3 total)

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