Hi,
So I have two connections to two servers LIVE and TEST. I started assessing dbForge yesterday with a sql on our TEST connection. when I try continuing today, the document opens the live connection, and complains when I try changing the connection back to test with "cannot change connection for non-empty query document". I've tried documentation with out much luck..
Can you help?
Thanks
newbie trying to Switch Connection
-
alexa
Re: newbie trying to Switch Connection
The connection of the existing .sql document can be changed as follows:
1. Open the folder with the existing .sql document.
2. Remove the file that has the same name, but only the different extension .sql.design
3. Navigate back to dbForge Studio for SQL Server and open the existing .sql document.
4. Open the connection that you want to reassign the existing .sql document to.
5. Change the connection of the existing .sql document.
6. Right-click on the bottom pane containing the 'Text' tab at the bottom of the SQL document and select 'Query Builder' from the popup menu. The 'Query Builder' view containing a diagram for the .sql document opens.
7. Save the new document.
1. Open the folder with the existing .sql document.
2. Remove the file that has the same name, but only the different extension .sql.design
3. Navigate back to dbForge Studio for SQL Server and open the existing .sql document.
4. Open the connection that you want to reassign the existing .sql document to.
5. Change the connection of the existing .sql document.
6. Right-click on the bottom pane containing the 'Text' tab at the bottom of the SQL document and select 'Query Builder' from the popup menu. The 'Query Builder' view containing a diagram for the .sql document opens.
7. Save the new document.