Free 10g software for windows

TierDeveloper .NET 6.1 is a powerful and easy-to-use tool that helps you develop real-life complex .NET database application in record times. TierDeveloper does this by letting you map objects to relational databases, put power SQL and business rules in them, and generate fully working code instantly. TierDeveloper also generates an ASP.NET application to either let you test the generated objects or to use as a powerful admin application.
Some of the main benefits of using TierDeveloper are:

• Speed up .NET Development: 50% of your code is generated instantly.
• Improve Code Quality: All generated code is consistent and based on a design pattern.
• Reduce Testing Effort: All generated code is based on pre-tested templates.

Major Features:

1. Object Mapping Features
   
   • Filtered Object Inheritance
   • Map stored procedures to objects
     
2. Objects
   
   • Map to a single table or multiple tables
   • Map to a view (read-only or in update mode)
   • Define unmapped objects and create tables for them automatically
   • Support for auto-generated keys (Identity keys and sequenced values)
   • Select subset of table-columns as object attributes
   • Support for formula (computed) fields in objects
   • Support for NULL values (IsNull and SetNull)
   • Name object attributes different from table-columns
   • Support all the data types in target language including BLOB
   • Data validation on attributes provided including range-checking, greater than, or less than checking
   • Extendible field validation framework. Add your own custom field validation logic
   • Required and optional field checking
   • Save an object only if it is "dirty" (meaning data is changed in it)
   • Serialization support for all objects
3. App GUI Designer Features (ASP.NET & Windows Forms)
   
   • App GUI Wizard (New)
   • Forms Designer
   • List Pages Designer
   • Ad Hoc Search Page Designer
   • Menu Designer
4. Transaction Support
   
   • Specify insert, update, delete, and single-row select operations
   • Specify multiple insert and single-row update operations
   • Specify bulk updates and deletes with custom where-clause
   • Specify transactional characteristics of objects for COM+
   • Full transaction support for non-COM+ components in a parent-child relationship
   • Non-COM+ components can also be part of client initiated transactions
   • Transaction isolation levels for each object
5. Queries
   
   • Query Timeout
   • Specify joins
   • Select subset of object attributes for retrieval
   • Specify custom where-clause with nested queries, UNIONs, and others
   • Accept run-time parameters
   • Return a collection of objects as the output of query
   • Support GetCount and GetPartialRows behavior in queries
   • Support SELECT DISTINCT on queries
   • Return Typed DataSets as query results
   • Automatically create queries based on indexes
6. Dynamic Queries: Same as normal queries but with following additional features:
   
   • Specify where-clause at run-time
   • Output of dynamic query is a collection of objects (just like normal queries)
7. Relationships:
   
   • Re-architected support for 1-1, 1-n, and m-n relationships
   • Added support for m-n relationships (thru a bridge table)
   • Parent-child relationships support for 1-1, 1-n, and m-n
   • Lazy loading of related objects in a relationships
   • Cascaded updates and deletes for all relationships provided
   • Automatically create relationships between objects
8. Parent/Child Relationships
   
   • In case of 1-1, 1-n, and m-n specify a parent-child characteristic
   • Parent object updates or deletes children as part of one transaction
   • Parent object loads all children
9. Stored Procedure Calls Relationships
   
   • Define methods in objects as calls to stored procedures
   • Specify input, input/output, and output parameters
   • Accept cursors as output of stored procedures
   • Use it when a stored procedure has complex business rules
   • Generate T-SQL stored procedures for all SQL used in objects
   • Generate CLR stored procedures for all SQL used in objects
   • TierDeveloper does this automatically and then generates objects code so it is calling these stored procedures
   • Improves performance
   • Use package syntax for generated Oracle stored procedures
10. Custom Hooks (safe code)
    
    • Write custom hooks to be called by the generated code from within the methods of objects
    • Custom hooks kept separate so objects code can be regenerated
    • Generate skeletons and a test application for custom code to make it easy for you to write custom code and test it independently
11. Typed Datasets
    
    • Support for Typed DataSets for all objects
    • Generate .xsd files for all objects and define relationships in them as well
12. NET Remoting Services
    
    • Select one of more objects and one or more methods in them and generate web services for them
    • Generates a Windows Forms remote client application
    • TierDeveloper support RPC-style web services
13. Code Generation
    
    • Support for Visual Studio 2008 and .Net Framework 3.0/3.5
      
    • Support for Microsoft Enterprise Library Security Application Block
      
    • Support for WCF
      
    • .NET Remoting App
    • Generate ASP.NET and Windows Forms application
    • Now you can generate code through TierDeveloper that supports .Net Nullable types
    • Complete re-architected template-based code generation engine
    • Code templates based on JavaScript language and are customizable
    • Customize names for classes, methods, and properties
    • Generate .NET components in C# and VB.NET
    • Generate either COM+ or non-GAC code
    • Generate updatable Datasets
    • Build .NET components as private or shared assemblies
14. WEB App Generation
    
    • Ajax Support
    • Generate a fully-working web application
    • Web app contains pages to test each and every object behavior
    • Generate web app with or without XML/XSLT
15. Schema Level View
    
    • Quickly view object mappings against all tables in the schema
    • Instantly view overlaps in objects on table-mapping
    • Easily see which tables haven't been mapped
    • Makes object design work very easy
16. SQL Query Tool
    
    • Quick compile and run SQL before committing it to objects
    • Invoke SQL Query Tool from query definition and stored procedure definition windows
    • Output of the SQL shown in a multi-column list in bottom window
17. Generate Design Docs
    
    • Generate meaningful design docs in HTML for generated objects
    • Easily update design docs whenever you change objects
    • 424Database Servers
    • Microsoft SQL Server 2000/2005/2008
      
    • Oracle 8i/9i/10g
    • IBM DB2 7.x, 8.1
    • MS Access 2000 or later
    • .NET code uses OleDb, SqlClient, and Oracle Client for database access
18. New TierDeveloper GUI
    
    • Completely redesigned GUI for TierDeveloper (consistent with VS.NET)
    • Stand-Alone and VS.NET integrated versions have identical GUIs
19. ASP.NET and Windows
    
    • FormsCompletely redesigned and easier-to-use GUI for generated ASP.NET app
    • Support for Windows Forms application generation with a nice GUI layout
    • Customize GUI layout for ASP.NET and Windows Forms apps
    • GUI layout customization from within VS.NET and/or XML file
    • Use drop-down controls with lookup values on forms
    • Re-arrange fields on the form, change their sizes, change labels, and more
    • Customize layout of list pages. Re-arrange column order, width, and titles
    • 1-1, 1-n, and m-n relationships supported in forms and lists
    • Support of partial classes
20. SQL Server Optimization
    
    • Generate SQL API based object code
    • Use Windows authentication for security
21. Oracle Optimization: Generate Oracle Native Data Provider based object code

Enhancements:

1. Support for Visual Studio 2008 and .Net Framework 3.0/3.5: If user opts to generate the code for .Net Framework 3.0/3.5, code is generated for Visual Studio 2008 for later versions.
   
2. Support for SQL Server 2008: Users will be able to connect to SQL Server 2008 databases.
   
3. Support for Microsoft Enterprise Library Security Application Block: Users can use Role-Based Authorization in their Factory methods. TierDeveloper uses Microsoft Enterprise Library Security Application Block along with Policy Injection block for security.
   
4. Support for WCF: Support for WCF is included in TierDeveloper 6.0. TierDeveloper generates:
   
   • WCF Business Services for components. (Class Library)
   • Host Application (Console)
   • Proxies for Services (Class Library)
5. Map stored procedures to objects: Map the output of a stored procedure call to an object. Then, when the stored procedure is called, it returns a collection of the mapped objects. This way, you can use objects for all your database interaction.
   
6. App GUI Wizard: Quickly specify the GUI of your application through an easy to use wizard. Wizard lets you select how many forms, list pages, ad hoc search pages you want and which objects they should be mapped to. It also lets you specify the menu of your application and a login page. Wizard then lets you generate either ASP.NET or Windows Forms application. This is the fastest way of generating a custom app GUI.

A high performance tool for Oracle Database Server administration and development EMS SQL Manager for Oracle is a high performance tool for Oracle Database Server administration and development. SQL Manager for Oracle works with any Oracle versions from 8.1.7 to 10g and supports all Oracle objects and all Oracle data types including the new BINARY_FLOAT and BINARY_DOUBLE types, and others.
EMS SQL Manager for Oracle offers plenty of powerful tools for experienced users such as Visual Database Designer, Visual Query Builder, and powerful BLOB editor to satisfy all their needs. SQL Manager for Oracle has a state-of-the-art graphical user interface with a well-described wizard system, so clear in use that even a newbie will not be confused with it.
Main features:
New state-of-the-art graphical user interface
- Office 11 and Windows XP visual schemes support
- Well-described Wizard System
- User-friendly database explorer for easy management of all Oracle objects
- Windows Toolbar to switch between windows easily, like in Windows Task Bar
- Navigation bars with hot actions in most of the windows
- Ability to save all program settings
- Customizable toolbars for all program windows
- Fully customizable program interface
- Powerful visual options module
- Localizable program interface
Easy management of all Oracle objects (including create/edit/ drop operations)
- Managing tables and all their subobjects: fields, primary, unique and foreign keys, indices, triggers, and check constraints
- Managing views and all their subobjects: fields, triggers, primary, unique and foreign keys
- Managing procedures, functions, sequences, packages and package bodies
- Managing users, roles, profiles, consumer groups and resource plans
- Managing database and schema triggers, clusters, synonyms, database links, materialized views and materialized view logs
- Managing object and array types, object type bodies, libraries
- Managing java sources, resources and classes
- Managing index types, operators, dimensions
- Managing contexts, directories, table spaces, rollback segments, redo log groups
- Duplicating database objects
- Viewing dependencies between database objects
Rapid database management and navigation
- Multiple host/database connections
- Registering selected databases to work with
- Schema restriction to see only required schemas
- Projects to work with the selected database objects only
- Multiple user-defined tabs for any tree node to access it in one-click
- Working with multiple selected objects at a time
- Grouping/Ungrouping registered databases
Advanced data manipulation tools
- Plenty of useful tools such as data grouping, fast search and filtering
Effective security management
- Grant manager displaying all database object grants in the form of a grid
- Ability to set permissions for table columns
- Easy management of database users, roles and profiles
Excellent visual and text tools for query building
- Multiple SQL editors with code completion and syntax highlight
- Large script execution (SQL script editor)
Latest Oracle version support
- Support of all server versions from 8.1.7 to 10g R2
- Support of all Oracle data types including the new BINARY_FLOAT and BINARY_DOUBLE types
- Powerful and easy management of object permissions, including column-level permissions
And other useful features
- Keyboard templates
- External tool manager
- To-do list
Other useful tools to make your work with Oracle server as easy as it can be
- Extracting metadata into text files or SQL script editor
- SQL Monitor
System requirements:
- 300-megahertz (MHz) or higher Pentium II-compatible processor; 600-MHz or faster processor recommended
- 64 MB RAM (128 MB or above is recommended)
- 50MB of available HD space for program installation
- Super VGA (800x600) or higher-resolution video adapter and monitor; Super VGA (1024x768) or higher-resolution recommended
- Microsoft Mouse or compatible pointing device
- Oracle Client 8.1.7 or higher
- Possibility to connect to any local or remote Oracle server

Dynamic 3i Free Edition ERP/MRP 3.2.2050 allows you to get access to all Enterprise and Manufacturing Resource Planning solutions. SDC's newest solution, DYNAMIC 3i Free Edition gives users access to all the power and functionality of the market-leading Enterprise Resource Planning and Manufacturing Resource Planning solutions without the heavy investment usually required to acquire these solutions.

DYNAMIC 3i Free Edition includes everything you need to get started for up to 4 users. The solution is built on Oracle's 10g XE database platform ensuring the very best in performance, reliability and the assurance of an industry standard for your database and ERP and MRP applications.

Enhancements:

• A fix allowing Dynamic3i Free databases older than 3.2.1331 to be upgraded automatically.