RISE to Bloome Software
Log In    
Home
RISE
Marshal
Download
 
 
r2bsoftware.se r2bsoftware.se
 
 
 
Click to hide navigation tree
 

Marshal SQLUtility

 
The Marshal SQLUtility is a Free simple to use generic utility for ODBC databases. It allows you to test ODBC connections, execute single statements or batches of statements and discover tables and columns. All you need to do is to enter the connection string to your database. You can read more about connection strings in the article Connection Strings.
 
The Marshal SQLUtility is embedded in the Marshal Editor. You can also, free of charge, download and install the Marshal SQLUtility as a standalone application.
Marshal SQLUtility
 
 

The Start Tab

The start tab displays the online documentation for the Marshal SQLUtility.
 
The Marshal SQLUtility start tab
 
 

The Schema.Table Tab

Use the Schema.Table tab to discover the tables and views of your database. When you click on the Find button in the Schema.Table tab, all tables and views of your database that you have permission to view are listed. You can choose Save Selected Datagrid in the File menu to save the list of tables and views in a text file. Double-click on a row to display the columns of the table or view.
 
 
Schema Table, Discover the tables and views of your database
 
 

The Schema.Column Tab

Enter the name of the table or view for which you want to list the columns and click on the Find button. You can choose Save Selected Datagrid in the File menu to save the list of columns in a text file.
 
Schema Column, discover the columns of a selected table or view
 
 
 

The Find Column Tab

You can search for columns in your database. The utility will scan the schema for all tables and view to find the columns matching your search criteria. This might be time consuming for large databases. The schema is however cached making the search instant the next time. To clear the cache, select Clear Schema Cache in the Tools menu. You can choose Save Selected Datagrid in the File menu to save the list in a text file.
 
Find Column, find columns matching a pattern in your database
 
 
 

The Query Tab

The Marshal SQLUtility contains a SQL prompt allowing you to execute any query supported by your database server. The utility supports batch execution of statements. Each statement is delimited by the statement delimiter. The default delimiter is "GO". The delimiter is case sensitive and must be placed on a separate row. The number of statements identified is automatically displayed. The resultset of each query is presented in a separate tab.
 
If the result contains BLOB fields, you can double-click on the cell to save the blob to file. You can double-click on any cell to display the content. This is useful for cells containing much data.
 
You can choose Save Selected Datagrid in the File menu to save the result of your query in a text file.
 
Query, execute single queries or  batches of queries
 
 
 

Save Datagrid to File

You can choose Save Selected Datagrid in the File menu to save the content of the datagrid of the currently selected tab as a text file.
 
Save as Text
 
 
 

The Message Tab

The message tab contains a log of all actions that you have performed. It will also view all errors, e.g. because of invalid connection strings, query syntax errors etc.
 
 
Message
 
 

The File Menu

New Query Tab Opens a new Query Tab for execution of statements. You can have multiple query tabs opened simultaneously.
Close Query Tab Closes the currently selected query tab. Only query tabs created by the user can be closed.
Open SQL File Opens a file containing SQL statements in a new query tab.
Save Selected Data Grid Saves the datagrid content of the currently selected tab to a text file.
Print Prints the selected tab.
Print Preview Displays the print preview form.
Page Setup Displays the page setup form.
Exit Exits the application.
 
 

The Tools Menu

List Tables and Views 
Opens the Schema.Table Tab and lists the Tables and Views of the currently selected database.
Find Column
Opens the Find Column Tab.
View Messages
Opens the Message tab.
Clear Schema Cache
The database schema is cached in order to improve performance. This option clears the schema cache for the currently selected database..

The Help Menu

Contents
Displays the online documentation and related articles for the Marshal SQLUtility
About
Displays the About form for the Marshal SQLUtility.