Reverse Enginerer


J

Jay

I've been using Visio to model DB's on SQL Server 2000 for a while now and I
just tried to reverse engineer a database from SQL Server 2005. Everything
wen't fine until I tried to login to the server (the test connection was
good) and I got the message:

The currectly selected Visio driver is not compatable with the data
source.

I ended up pushing the DDL to a 2000 box and got the diagram just fine.
However, since at some point in time, I won't have a 2000 instance, I'm
going to need to get this working with 2005 (sooner, rather than later).

Thanks,
Jay

PS. Happy to see the group, sorry to see so few posts in it.
 
Ad

Advertisements

J

Jay

Oh, almost forgot:

Windows XP Pro
Visio Pro 2003 SP2 (11.7218.8132)

Selected "Microsoft SQL Server" for the Visio driver and
"SQL Server" for the "driver for which you want to setup a data source".

As previously stated, the test connection was fine.
 
Ad

Advertisements

B

Barb Way

Jay -
SQL 2005 came out 2 years after Visio 2003 was released, so the drivers in
Visio do not support 2005 version SQL. You can see all the listed versions
for database modeling in this article:
899598 You cannot use the Reverse Engineer Wizard on certain DBMS database
in Visio 2003
http://support.microsoft.com/default.aspx?scid=kb;EN-US;899598

There are two current versions of Visio which support SQL 2005 as a
database modeling source, however:
Visio for Enterprise Architects / bundled with Visual Studio 2005 (Team
editions)
Visio 2007 Professional

Barb Way
Product Support - Visio
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
From: "Jay" <[email protected]>
References: <[email protected]>
Subject: Re: Reverse Enginerer
Date: Wed, 5 Dec 2007 15:31:22 -0800

Oh, almost forgot:

Windows XP Pro
Visio Pro 2003 SP2 (11.7218.8132)

Selected "Microsoft SQL Server" for the Visio driver and
"SQL Server" for the "driver for which you want to setup a data source".

As previously stated, the test connection was fine.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

reverse engineering 0
Reverse Engineering 2
Reverse Engineering 1
Reverse Engineering problem 1
Reverse Engineering opportunities 0
MySQL Reverse Enginering 3
SQLServer reverse enginering 1
Oracle reverse engineer 0

Top