Display properties allows you to display the properties of the connection that you already have saved, and then import and export connections will be covered in another video, but I just wanted to point these out, because obviously, if you already have connections in the Management Studio established, or if you have a central management server, you can import those here, and you can export any connections that you make in the environment. You have your connect and your disconnect buttons. This allows you to basically clone a connection that you already have and modify it.
This we'll get to in a second, this is create like. So, obviously, we've already covered the create new connection. You can create a connection in the toolbar of the connection manager itself, or you can right-click anywhere in the Connection Manager and choose create as well.īefore I start a connection, let's talk about the toolbar itself. In the ribbon bar, there is a button that has a create new connection and then also connect to an established connection that's saved. So to create a connection in Toad, you have several options. And now you'll see it every time you open up Toad. This way, it does not pop up every time Toad for SQL Server starts, and click cancel.įor those folks that want to see that dialog box upon startup if they like that workflow, and it's been unchecked or you inadvertently unchecked it, you can come to options, and under environment general, you can click show on startup dialog box. I will not use this for the demo, as it is the same as the connection manager in the upper left. When starting Toad for SQL Server for the first time, you're presented with a connection dialog box. This video covers getting started with connections in Toad for SQL Server. Hello, my name is Robert Pound, and I am a product technologist at Quest.