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.