Hi. My name is Olga and I'm a Content Developer in Toad for SQL Server Team. Today, I want to show you how you can easily import connections in Toad. I've got the latest Beta installed in my computer, but I declined integrations, so I do not have any connections or setting here, so I need to create connections manually. I click this button and fill in the server name, TOAD_LAB/SQL2012.
It's my development group, so I select Category and click Save. So now, I see this connection in Connection Manager. I can also create groups of connections. And the name for the group will be Development. After it, I drag the connection into the group.
After upgrading to the [INAUDIBLE] version of Toad, you won't probably like to create each connection by yourself, so you can use Import Connections. Toad stores all connection information in the XML file in its Application Data Folder. Depending on the operating system, it has different locations, but you can find it with Help, About, Application Data. So I click the link, and here it is. It's Connection XML file. And here, we have the only connection that we just created.
But if we go up, we see the application data for the previous version of Toad. And this is the file I want to import in my Toad for SQL Server Beta. Now I close this folder and this one, and I click Import Connections.
We'll quickly go through this dialog. I've selected Toad XML File. Also, you've got Import Connections From the Management Studio. I need to pick up a file from the Toad for SQL Server 5.7, so I go up and select this note, and select this file, click Open, and then Next.
This is the list of connections I've got in the previous version of Toad, and this is the only connection we have just created. So I select the connections I want to import. For example, I can import the entire folder. I click it, and click this button, so I've got all production connections here. Or I can import connections one by one like this. And for example, this one.
So I click Next. Here's the list of connections I went to import. Next again. And here it is. I have a list of connections. So in my Connection Manager, you can see all connections that I have just imported and a connection we have created.
Toad also allows you to export connections. It can be real helpful if you want to share connections with your colleagues. So you click Export Connections and select those you want to export, for example this, and click Export button. And you just save the file. And after this, you can send it to your colleagues and share them.
To learn more about Toad for SQL Server, visit Quest.com/Toad-for-SQL-Server, or join community at ToadforSQLServer.com. Thank you for attention, and good bye.
03:45