SqlServerDataExtractor
Sometimes we need to drop a binary onto a box and extract the data. This application allows you to specify the connection string and SQL statement. Once the SQL statement executed, the data is output to a file in the application directory, which is loaded into a browser control on the second tab. The reason for using HTML to display the data, is that the application should be flexible enough to handle alot of data...
If you need help with SQL connection strings then check out: http://www.connectionstrings.com/
Some example connection strings are shown below.
- Data Source=IP;Initial Catalog=DB;User Id=USER;Password=PASS;
- Data Source=IP;Initial Catalog=DB;Integrated Security=SSPI;
Some example handy SQL statements are shown below:
- select @@version
- select user_name()
- select db_name()
- select * from sysusers
- select * from sysobjects where type = 'U' order by name
Features
- Nice little progress bar
- Handles large volumes of data
Requirements
- Windows 2000, Windows XP, Windows 2003 Server (Might work on others?). Has been tested on Vista x64.
- Microsoft .NET Framework v2.0
Screenshots



