Free stored procedures software for windows

The SQL Load Test was designed to generate a Visual Studio 2005 Unit Test from a SQL Server Profiler trace. The tool extracts all the SQL statements and stored procedure calls from the trace and turns them into a single Visual Studio Unit Test, which can then be configured as a Visual Studio Load Test.
The tool does not interact with the database itself when it generates the test code and so it can be used "offline".
The generated code needs to be customised to include a connection string to the database under test. The generated code also includes hooks to allow the user to customise the parameters that are passed to the SQL statements and stored procedures, so that variability can be introduced into the data to prevent caching from giving artificially high performance figures.
The tool is intended to be used in conjunction with a client program that exercises the database. A trace of the clients SQL Server activity is captured using the SQL Server Profiler. This represents a test scenario, which is then processed by the tool to produce a Unit Test that replays the scenario.
The tool requires a trace to be collected using the SQL Server Profiler tool. The tool assumes that the trace only contains records pertaining to a single client session. So it is important to ensure that the trace is set up to only collect trace records generated by the activity of the client being used to generate the scenario.
It is therefore advisable to run the client on a machine from which no other activity on the SQL Server database is being generated, and to set the SQL Server Profiler filter accordingly.
System requirements:
- SQL Server 2005 SDK and the SQL Server 2005 Management Tools are installed.
Version restrictions:
- Only supports code that operates against a single database with a single connection.
- Prepared statements are not supported.
- The tool cannot (yet) configure and capture the trace for you, it requires you to use the SQL Profiler yourself to get a trace. With SQL 2005 it is possible to automate this.
- Not (yet) integrated into Visual Studio or the DB Pro edition.
- The tool has only been tested in an English environment, it is unlikely to work correctly in other environments, particularly with dates. In a future version this could be resolved by requiring the ExistingConnection event class, which lists language and date format.
- The tool does not support the XML data types.
- InputOutput parameters that are initialised with a NULL cannot be distinguished from Output-only parameters, so they are treated as Output only.
- When the trace passes a NULL to a binary parameter (e.g. image, binary, varbinary) the generated code will generate a runtime error. The generated code needs to be modified to pass SqlBinary.Null. The custom code generation extensibility point can be used to work around this.
- Positional parameters passed to SQL statements (as opposed to stored procedure calls) are not supported.

Navicat Lite for Oracle 8.2.7 is considered as a professional and useful GUI for Oracle server administration and development). Navicat for Oracle offers powerful visual tools such as Query Editor with syntax highlight capability, SQL Preview, SQL Console, TEXT, Hex and BLOB viewer/editor, SSH Tunnel and more, to increase your productivity.

Also, it provides a number of tools allowing to perform all the necessary database operations such as creating, editing, and duplicating database objects. It also offers a well-described wizard system that simplifies your database development tasks.

Navicat for Oracle full version includes more powerful features such as Data/Structure Synchronization, Import/Export, Backup, Report, task scheduling, code completion, etc. Together with comprehensive and instant support services, Navicat Oracle makes database and application development faster and easier while simplifying day-to-day administration tasks. Navicat for Oracle can connect to any Oracle Database version 9i and later. Moreover, the versions for PosgreSQL and MySQL are also available.

Note: Free for non-commercial use.

Major Features :

1. Native Connection Options:
   • Navicat Oracle offers three connection modes to the Oracle server: connection through the Oracle Call Interface (OCI) in Basic mode, alias entry from a tnsnames.ora file in TNS mode and direct connection over TCP/IP in Direct mode.
2. Support of SSH Tunnel:
   • Establish a secure SSH session through SSH Tunneling in Navicat. Enjoy a strong authentication and secure encrypted communications between two hosts.
3. Export Registry Record(.reg) via Navicat Oracle:
   • You can easily transfer your connection settings while migrating Navicat from one computer to another new machine.
4. Create, edit and drop tables fields, indexes, foreign keys, uniques, checks, triggers and privileges:
   • With Table Designer - the basic Navicat Oracle tool for working with tables, you can create, edit and drop tables fields, indexes, foreign keys, checks, triggers, privileges and much more.
5. Support of tablespace, package, sequence, synonym, trigger, type and more:
   • Navicat allows you to create, edit and drop directories, tablespaces, publice database links, public synonyms, database links, indexes, materialized views, materialized view logs, packages, sequences, synonyms, triggesr and types.
6. SQL Preview:
   • The SQL Preview area shows you SQL representation of the oracle objects you are creating. This ability allows you to preview SQL before execution.
7. Dump object definition as sql file:
   • Backup object definition and data with ease by dumping as sql file.
8. Print Schema / Table Structure:
   • Present the schema / table definition by printing their structures in Navicat.
9. Import data from ODBC:
   • You can import data from ODBC after setting up a data source connection. All available tables will be included if connection success. Just simply choose the tables you wish to import or specify a query using Add Query button.
10. Import data from up to 11 most popular formats including MS Access, MS Excel, XML, HTML, TXT and CVS:
    • - Import Wizard allows you to import data into a table from diverse format. On top of that, you can save your settings as an import profile for setting schedule.
11. Export Data to different file formats: TXT, CSV, DBF and XML:
    • Likewise, Export Wizard allows you to export data into various format. Save your settings as an export profile for setting schedule.
12. Export data and create records as INSERT statements in sql file:
    • During Data Transfer, you can choose to export data as sql file with record options like complete insert statements / extended insert statements etc.
13. Form View:
    • Manipulate the current record with Form View. Enjoy a clear display of field name and its value with focus on current record.
14. Support of Foreign Key Data Selection:
    • With the GUI tool - Foreign Key Data Selection, you can locate the foreign key values from the reference table.
15. Data and Structure Synchronization:
    • Navicat for Oracle allows you to transfer data from one Oracle database to another with detailed analytical process. Likewise, you can compare and modify the table structures
16. Support of Data Transfer between local / remote Oracle databases:
    • Transfer tables/views/stored procedures/functions from one Oracle database to another Oracle database, or to a plain text file.
17. Support of Backup and Restore Oracle databases:
    • Regular backup on database is important to users. Backup/restore all tables and records, views and stored procedures for your Oracle database using Navicat. You can also schedule backups between databases.
18. Create Schedule for Backup, Import / Export, Data Transfer, Saved Queries and Data Synchronization:
    • Create a batch job for setting schedule to execute at one or more regular intervals, beginning and ending at a specific date and time. Batch job can be created for Query, Backup, Data Transfer, Data Synchronization, Import and Export.
19. Send notification e-mail for schedule task:
    • Generate notification e-mails to recipients you specify, connecting them to the latest schedule information. Read directly through your email account on the results returned from a schedule.
20. Visual User Manager:
    • Navicat provides users a visual tool for user management. You can easily add, delete, edit users / roles, and grant privileges on the selected schemas, tables/views, fields and stored procedures.
    • Visual Query / View Builder - which is divided into two portions: the upper Graphical View, and the lower Syntax View, allows you to create and edit queries / views visually without knowledge of SQL.
21. Query Editor:
    • It allows you to create and edit SQL text for a query, prepare and execute selected queries.
22. Support of Parameter Query:
    • Set query parameters to add variable values to a query each time you run it.
23. Code-Completion for Query, View, Stored Procedure and oracle objects:
    • Experience a quick way in constructing SQL statements in SQL Editor with the Code-completion feature. Whether you want to select available properties of database objects or SQL keywords, all it takes is a pick from the drop-down list.
24. Virtual Grouping:
    • Have a better organization over objects in Navicat. You can categorize objects into groups with the Virtual Grouping feature. Virtual Grouping can be applied on Connection, Table, View, Stored Procedure, Query, Report, Backup and Schedule.
25. Server Monitor:
    • Select the servers that you want to monitor by checking them in the checklist box of the Server Monitor Window. Click on either Process List, Variables or Status Tab to show and / or modify the properties of Oracle servers.
26. SQL Console:
    • To use a command-line interface, you can open SQL Console in Navicat. It provides you an interactive text-based screen to query input and result output from database.
27. Docking:
    • You can customize your window behaviour style into Docking Windows or Floating Windows. Choose either dock the opened windows to the main window or dock windows or inherit the last docking style.
28. Profile System:
    • For most of the tasks, Navicat allows you to save / load profiles to increase convenience. Profile can be applied on Data Transfer, Data / Structure Synchronization, Batch Job, Backup, Import / Export etc.

With great features, such as:
* Automatic source code generation to execute procedures.
* Advanced visual Query Builder for more complex SQL statements.
* Easy-to-use Stored Procedure wizard, including CURSOR statements.
* Create and manage table triggers.
* One-click backup and restore databases.
* Export tables to XML / Excel files.
* Perform text searches on stored procedures.
These are just a small number of features in FastQuery. To see how this product can help speed up your development time, download a demo version and try it out for youself.

Requirements: .NET Framework 1.1, MSDE/SQL Server 2000, MDAC 2.7

Whats new in this version: N/A