Setting Up a Category for a Connection in fusion for sql server

[franklt69]

Hi I have a doubt why in vs2013 don't show up when I create a new query fusion\New sql in the editor tab the icon or color that I have in the database explorer for this connection.

I don't have idea the query versus that server is going to execute, I didn't see any status bar that show me this query is conected to Server1\DB1 to execute, here https://www.devart.com/dbforge/sql/stud ... ories.html using the color in the tab and icon i can have idea, so the question

How I can see from Visual Studio the query versus which server is going to executed

regards
Frank

[.jp]

Hello,

The current connection of the document can be seen in the toolbar "Devart - Connection".

Best Regards.

[franklt69]

Thanks for you answer, I can see the Devart-Connection, it is a combobox with the database where the sql file is going to execute, not the server, I mean you have 2 query, tab1 - query1 - db1, tab2-query2-db2 when you switch between tab I can see the combobox change the database and that is good but guest it, I have 2 connection one for developer environment and other for production both connection have the same database but in different server, what happen if need truncate a table? the combobox don't give me enough information about the server if this query is going to run versus developer or production, using the approach in dbforge studio for sql you can see the icon in the tab, in the combobox you can see the connection not the database and you have the statusbar where you can see the server and database where I am connected, how I can see it from fusion?

regards
Frank

[alexa]

You can assign one of the available document categories to a connection as follows:

1. Right-click a connection in Database Explorer and select 'Modify Connection...' from the popup menu. The 'Database Connection Properties' dialog opens.
2. Switch to the 'Connection' tab.
3. In the 'Document Category' drop-down menu, select one of the available options or add a new one by clicking the three-dotted button.

[franklt69]

Ok I know that you can assign document categories to a connection , the problem is it

Guest I have 2 connection one for developer with green square in document category
other Red Circle for Production, in both connection I have the same database only are in different server, when I go in visual studio Fusion\New SQL I can see in the combobox the database versus I am going to execute the query, but I can't see which server is because in the tab where I am going to write the sql I don't have information about versus which server is going to execute, you don't have this issue in dbForge Studio for SQL Server because you have a icon in the tab and a status bar where I can see versus the server is going to execute, it simple feature I can't see in fusion in VS2013



regards
Frank

[alexa]

Unfortunately, due to technical difficulties in implementing tab icon indication, this feature is missing in dbForge Fusion for SQL Server unlike in dbForge Studio for SQL Server.

As we suggested to you previously, you can view the current server in the 'Connection' drop-down menu that is on the 'Devart - Connection' toolbar. Please note that another toolbar 'Devart - SQL' has the 'Database' drop-down menu that you should have been mistakenly looking at.

[franklt69]

Ok I was wrong I was confusing the database with the connection.

Thanks for u help

Regards
Frank

[alexa]

Hello Frank.

Thank you for updating us on this issue.

Please let us know if any questions arise.