kosta
Member
Joined: 09 Aug 2015
Posts: 161
Location: Salonic
|
 Posted: 28/02/2017 21:05 Post subject: SQL Simple Utilities |
 |
|
SQL Simple Utilities
Alexandros Pappas
This project provides utilities for SQL server, such as executing a list of SQL scripts, exporting data to an SQL script, and displaying relationships between records.
This project provides three utilities for SQL server:
Execute SQL scripts: The user may select a folder with SQL scripts, or a file containing a list of SQL scripts. The order of the scripts may be specified, and the SQL scripts may be executed.
Export to SQL script: The user may specify a list of tables to be exported. Based on the table relations (foreign keys), the utility calculates the order (parent tables before child tables). The tables' data may then be exported to an SQL script, by preserving the relations.
Show references: The user may specify a record in the database. Based on the table relations (foreign keys), the utility finds all related records up to a certain distance, and displays the graph using svg.
This project also demonstrates how to handle toolbars in MDI applications, how to display svg in a WebBrowser control, how to make a WebBrowser control zoomable, how to fill a DataSet with an asynchronous call to the database, how to write recursive SQL queries with Common Table Expressions (CTE), how to write a depth-first graph search algorithm, and how to display a graph.
[URL=https://userscloud.com/j8qfs42immun]SqlSimpleUtilities_Src.zip - 1.6 MB[/URL]
https://www.codeproject.com/Articles/596224/SQLplusSimpleplusUtilities |
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
