My New Project – Multiple SQL Server and Multiple Database Query Wizard

Good afternoon all. I have decided what my next project will be. It is for fun and like always will have a work application.

It will be written in 1.1 of the Framework. It will automatically create the SQL query statements that will allow joins between multiple servers and databases on each server. It will seek to allow joins between different databases and tables, along with criteria and sorts.

It will have a tab control. On the first tab, we allow them to add the servers. The second tab they add the databases. On the third tab they will add the tables from each database that they can select. On the fourth tab they pick the fields from each table that will be joined. On the fifth tab they enter their criteria for the query. On the sixth tab, they will pick the sort fields. Then finally the opportunity to save their selections to look at later and then to generate the SQL query.

At first, it will only be SELECT statements. Eventually I want to incorporate UPDATE and INSERT statements.

My goal is to make sure both non developer and developers find this tool useful and understandable.

Feel free to leave feedback of what you think of my ideas and make suggestions of what you would like to see in something like this. I am kind of excited and have already gotten started.

Make it a great day!

Technorati Tags: ,,,,,,,,,,,,, statements,,,,,

  1. #1 by John on February 15, 2009 - 1:01 pm

    Have you seen PrimalSQL from Sapien?

  2. #2 by Kelly on February 15, 2009 - 1:08 pm

    Nope. Does it do all this?

  3. #3 by John on February 15, 2009 - 3:57 pm

    The beta 2009 product does it and offers a way to export the query to vb, c#, vbscript and powershell. Its not perfect so I will be looking forward to your efforts.

  4. #4 by Kelly on February 15, 2009 - 8:51 pm

    Do you have the download? I can\’t find it anywhere.

Leave a Reply

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

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s

%d bloggers like this: