Opening diagram just saved before

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
bdeluard
Posts: 6
Joined: Sun 19 Feb 2012 23:26

Opening diagram just saved before

Post by bdeluard » Tue 30 Oct 2012 09:16

Hello,
I'm trying dbForge before buying... I have two problems:
- I saved a sample diagram with some tables and relations.. When I want to reopen it, I have no objects on diagram, and warnings for all tables and relations saying : "Table (relation) databasename.dbo.tablename (relationname)" is missed"

- I tried to use cobtrol version with TFS, but when I choose TFS in the dialog box, I have a messagebox with "RFS client not found". I'm using VS2012

I you can help me, most important is the first topic.

Bruno

.jp
Devart Team
Posts: 345
Joined: Wed 09 Sep 2009 06:55
Location: devart

Re: Opening diagram just saved before

Post by .jp » Tue 30 Oct 2012 09:46

I you can help me, most important is the first topic.
Diagram does not store information about database object details offline. So, when you open the diagram, dbForge Studio tries to establish connection with your database, containing objects of the diagram. If connection cannot be established, the diagram cannot be opened.

Diagram stores the following information when saved to file:

- layout information
- information about containers, notes, stamps
- connection information
- diagram database object names and owners
- names of the foreign keys, displayed on the diagram as relations

If the diagram database was modified after saving the diagram, Database Designer updates information about all database objects, displayed on it, when opening. But the newly created objects in the database does not appear on the diagram. If the diagram object was deleted from the database, it is deleted from the diagram.

Also please have a look at:
http://blogs.devart.com/dbforge/getting ... igner.html
http://blogs.devart.com/dbforge/adaptin ... abase.html

alexa

Re: Opening diagram just saved before

Post by alexa » Tue 30 Oct 2012 12:50

- I tried to use cobtrol version with TFS, but when I choose TFS in the dialog box, I have a messagebox with "RFS client not found". I'm using VS2012
This issue will be fixed in one of the next builds of the product. We will notify you once the product build including the fix of the issue is available for downloading.

bdeluard
Posts: 6
Joined: Sun 19 Feb 2012 23:26

Re: Opening diagram just saved before

Post by bdeluard » Tue 30 Oct 2012 17:38

.jp wrote:
I you can help me, most important is the first topic.
Diagram does not store information about database object details offline. So, when you open the diagram, dbForge Studio tries to establish connection with your database, containing objects of the diagram. If connection cannot be established, the diagram cannot be opened.

Diagram stores the following information when saved to file:

- layout information
- information about containers, notes, stamps
- connection information
- diagram database object names and owners
- names of the foreign keys, displayed on the diagram as relations

If the diagram database was modified after saving the diagram, Database Designer updates information about all database objects, displayed on it, when opening. But the newly created objects in the database does not appear on the diagram. If the diagram object was deleted from the database, it is deleted from the diagram.

Also please have a look at:
http://blogs.devart.com/dbforge/getting ... igner.html
http://blogs.devart.com/dbforge/adaptin ... abase.html
I just find my problem : I had recreated the database with the first char in uppercase in the name, and so I concluded that dbForge is sensible to the case (unlike SQL!).
Thanks for your informations which are a good complement.
Bruno

alexa

Re: Opening diagram just saved before

Post by alexa » Wed 31 Oct 2012 15:02

Thank you for updating us on this matter. We added the according information in the article in our blog.

alexa

Re: Opening diagram just saved before

Post by alexa » Thu 17 Jan 2013 14:00

- I tried to use cobtrol version with TFS, but when I choose TFS in the dialog box, I have a messagebox with "RFS client not found". I'm using VS2012
We have reproduced this error. This problem appears when there is only tfs client v. 11 on you computer.

This issue will be fixed in one of the next builds.

Workaround:

1. Close dbForge Studio for SQL Server if it is not closed yet.
2. Open the "C:\Program Files\Devart\dbForge Studio for SQL Server" folder in your windows explorer and replace the "dbforgesql.exe.config" file with the newly created one having the following content:

Code: Select all

<runtime>
     <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
        <dependentAssembly>
           <assemblyIdentity name="Microsoft.TeamFoundation.VersionControl.Client" publicKeyToken="b03f5f7f11d50a3a" culture="neutral" />
           <bindingRedirect oldVersion="10.0.0.0" newVersion="11.0.0.0"/>
        </dependentAssembly>
        <dependentAssembly>
           <assemblyIdentity name="Microsoft.TeamFoundation.Client" publicKeyToken="b03f5f7f11d50a3a" culture="neutral" />
           <bindingRedirect oldVersion="10.0.0.0" newVersion="11.0.0.0"/>
        </dependentAssembly>
        <dependentAssembly>
           <assemblyIdentity name="Microsoft.TeamFoundation.Common" publicKeyToken="b03f5f7f11d50a3a" culture="neutral" />
           <bindingRedirect oldVersion="10.0.0.0" newVersion="11.0.0.0"/>
        </dependentAssembly>
     </assemblyBinding>
</runtime>
3. Start dbForge Studio for SQL Server.

Post Reply