Teradata SQL Assistant Options for SQL Server Users

At first glance SQL Assistant seems quite different from SQL Server Management Studio.  However there are two options that go a long way in making SQL Assistant behave more like SSMS. 

The first option to set will display all databases for which the user has access.  This will make the database tree view in SQL Assistant a little more familiar for SSMS users.

Select Tools—>Options from within SQL Assistant.

image

Then click on DB Tree.  Click on the 2nd radio button in the list.  “Load the databases and users from a Table or View”.

image

 

The second option can be a lifesaver for a SQL Server DBA new to Teradata.  By default SQL Assistant will run every script in the window regardless of what is highlighted.  There is an option to change that.

On the Options window click on the Query tab and select – “Submit only the selected query text when highlighted”.

image

 

Hopefully these two options will ease the transition between SSMS and SQL Assistant.

Advertisements
This entry was posted in Database Administration, Teradata and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s