The Windward Studio

Windward Blog Home

Speed Up Connections to Large Database Sets Using Build SQL Schema

by
Posted on 02/09/2015

Please Share This

 

Does your SQL database have more than 50,000 nodes?  If so, when you connect to it in AutoTag you won’t see anything past node 49,999.  We have designed AutoTag this way because having to scroll through that many nodes makes the databin unusable.

Not to worry! We have an option that will be much better for you: the AutoTag program BuildSqlSchema.exe. 

BuildSQLSchema_Icon

You can use Build SQL Schema to create a schema file that you can then use as your datasource. This will allow you to narrow down your schema to just the tables, views and stored procedures that you need to work with in your current report template.

How Build SQL Schema works

You will need to open a command prompt (DOS box) and navigate to the AutoTag installation directory (typically found here: C:\Program Files\Windward Studios\AutoTag). Here you will find BuildSQLSchema.exe.

BuildSQLSchemaConnectorWhen you run this program with the correct parameters, it will build an XML file that returns the schema listing of your database. This allows you to open the generated XML file and remove items, thereby narrowing the schema down to only the items you want visible.

Once the schema file is created and narrowed down to the items you want visible, it can be in AutoTag as a SQL Schema data source. In the data source connection window from the vendor list, select SQL Schema and then browse for the schema XML file that you created. Connecting to the data source now becomes instantaneous.

An Alternate Approach

There is an alternate method that requires unchecking the “read metadata” check box in the data source connection window. This prevents AutoTag from reading the schema structure of all foreign key and primary key relationships between database tables during connection.

But if you take this approach, automated table joining in the AutoTag SQL Wizard will not function because foreign key and primary key relationship information is needed in order to automatically join tables during column selection.

Get More Details on Build SQL Schema

If this sounds like something you would like to try, head on over to our documentation wiki for more information!

Please Share This



Author: Valerie Schilling

Valerie is passionate about people. Her strengths, with many years in the tech industry, are deeply rooted in relating and communicating. Valerie has an unparalleled tenacity to ensure the people she works with get what they need. Even if your problem is not solved immediately, your day will be brightened by her intelligent and cheerful demeanor.

Other posts by