Download free copy of Migrate Microsoft SQL Server Transact-SQL to Oracle PL/SQL

SwisSQL - SQL Server to Oracle Migration Tool helps you migrate MS SQL Server Transact-SQL Procedures, Functions and Triggers to Oracle PL/SQL language. When enterprises migrate from MS SQL Server to Oracle, application migration is one of the tedious tasks and there are no good tools which can ease the process of migrating MS SQL Server Stored Procedures to Oracle PL/SQL. Using SwisSQL - SQL Server to Oracle Migration Tool and through AdventNet’s superior support, enterprises can realize significant time and cost savings during the migration and testing process.SwisSQL - SQL Server to Oracle Migration

SwisSQL Features: SwisSQL SQL Server to Oracle Migration Tool converts

1. Full-fledged support for conversion of Inline and Multi-Statement Table valued user-defined functions in SQL Server.
2. Option to generate Index Organized Tables in Oracle.
3. Configurability to separate the Constraint definitions from the Table definition so that the Oracle database can be built with ease (in that order)
4. Option to specify the TABLESPACE to be used for Tables and Indexes in Oracle while creating them.
5. Procedures, Functions, Triggers, Tables, Views and other database objects to Oracle PL/SQL.
6. Transact-SQL built-in and user-defined Datatypes To Oracle PL/SQL.
7. Transact-SQL Built-in Functions conversion into corresponding Oracle PL/SQL Functions.
8. SQL-Server SQL queries conversion into Oracle SQL Queries.
9. Cursor Declaration, OPEN, FETCH, CLOSE and DEALLOCATE Statement Conversion.
10. Single Result-Set Processing conversion from T-SQL to PL/SQL.
11. SET and SELECT assignment statements and T-SQL Labels.
12. Transact SQL Conditional and Control Statements.
13. Support for EXECUTE / EXEC Statements conversion.
14. @@FETCH_STATUS, @@ROWCOUNT, @@ERROR, @@LANGUAGE, @@MAX_CONNECTIONS and @@VERSION Global Variables.
15. Transact SQL Temporary table.
16. Transaction features COMMIT, ROLLBACK and SAVEPOINT.
17. Bitwise operators.
18. Database definitions (CREATE DATABASE.. construct).
19. User accounts (Logins) present in SQL Server database into equivalent scripts in Oracle.
20. SCOPE_IDENTITY() function.
21. Almost all other SQL Server Transact SQL syntaxes into Oracle PL/SQL.
22. Option to customize the database object names while migrating the SQL Server Transact-SQL scripts to Oracle PL/SQL.
23. Support for runtime customization of data types (mapping data types in SQL Server to any preferred data type in Oracle) before conversion.
24. Support for handling the conversion of variable names with length greater than 30 characters.
25. Migration Assessment Tool : This new tool can be used to assess the complexity and percentage of automated conversion of the source SQL Server database objects that needs to be migrated to Oracle. The detailed assessment reports generated by the tool will be helpful in arriving at an estimation for the migration project to be undertaken.

SwisSQL SQL Server to Oracle Migration Tool GUI Features:

* Provides an Intuitive and Easy to use GUI for handling the migration.
* One click conversion of Transact SQL to PL/SQL.
* Provides a tree view of loaded Transact SQL files and converted PL/SQL files.
* Options to load Transact SQL files from local directory or import them from SQL Server database for Oracle PL/SQL conversion.
* Project driven organization to ease maintenance.
* Generates formatted Oracle PL/SQL SQL code with comments.
* Comprehensive migration reports with detailed information such as total number of files loaded, total number of files converted, total number of files not converted, destination directory of converted files.
* Provides a unified view with loaded Transact SQL file, converted PL/SQL file, log report and error reports.
* Provision to compile the converted PL/SQL code.
Screenshot:

Want to Migrate
Data too ?
SwisSQL
Data Migration
Migrate Schema and Data from
SQL Server to Oracle.
More Info SwisSQL Data Migration Tool More Info
Download SwisSQL Data Migration Tool Download
Download free copy of Migrate Microsoft SQL Server Transact-SQL to Oracle PL/SQLlink3.2

Share This

Download free copy of MySQL GUI - Navicat MySQL Manager (supports Access to MyS
Discription:
Navicat is an ideal solution for MySQL administration and development. This is an all-inclusive mysql front end provides a powerful graphical interface for databases management, development and maintenance. Easy installation and intuitive interface make it an irreplaceable tool for mysql on the web or your local desktop. Navicat supports all verions of MySQL and let you converts Access to MySQL, MS SQL to MySQL, Excel to MySQL, synchronizes and backups database in a snap through helpful wizards. Major features include Visual Query Builder, Import/ Export, Report Builder, Backup/ Restore, SSH and HTTP Tunneling and Data Transfer. Navicat also supports to import data from ODBC, batch job scheduling (create schedule for Import/Export, Data Transfer and saved queries), printing of table structure. It also includes a full featured graphical manager for setting the users and access privileges. Navicat version 8 supports Code Completion, Form View and email Notification Services, etc. Navicat is the number 1 MySQL database administration shareware in Download.com with over 350,000 downloads and 1,100,000 installations worldwide. Some of the users including Sony Music, Intel, Kodak, FedEx, KPMG Consulting, Ericsson, Siemens AG, Yahoo!, NTT DoCoMo (Japan), Hitachi (Japan), Imation, Lexmark, Cisco Systems, RSA Security, Avis (Europe), U.S. Department of Energy, UPS, Disney, Oxford University, Harvard University, NASA Space Flight Center, MIT, Michigan State University, University of Michigan, …Navicat delivers a personal experience, simplifying the way you work. The program is available for Windows, Mac OS X and Linux and supports multiple languages.
Download free copy of MySQL GUI - Navicat MySQL Manager (supports Access to MyS 8.0.22link

Share This

Download free copy of Collectorz.com Movie Collector
Collectorz.com Movie Collector is the Movie edition of the Collectorz.com series of collection managers. It organizes your DVDs, VHS tapes, Video CDs etc. The program is IMDb enabled, you can add your movies to the database by just typing the movie title; the rest of the info will be automatically retrieved from the Internet Movie Database. The attractive and easy to read interface lets you group, sort and filter the data in every possible way and displays a web-style page for every movie in your collection. Additional features include detailed statistics, loan management, customizable fields and more.

Download free copy of Collectorz.com Movie Collector 5.3.2link

Share This

Download free copy of of TOAD for Oracle
Description
TOAD® empowers developers and DBAs to be more productive by providing an intuitive graphical user interface to Oracle. TOAD is a powerful, low-overhead tool that makes PL/SQL development faster and easier and simplifies database administration tasks. Advanced editors allow users to work on multiple files simultaneously even different file types such as SQL, PL/SQL, HTML, Java, and text. Hot keys, auto-correct, type-ahead, syntax highlighting, version control and numerous other productivity features speed development, while editing and testing are made easier with integrated result sets, explain plans, tracing, and DBMS_OUTPUT views.

Download free copy of of TOAD for Oracle 8.5 link-1
link-2

Share This