Re: migration from MSSQL Server to Oracle Server

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 25 Mar 2001 23:08:02 +0200
Message-ID: <tbsndl5rf30af7@beta-news.demon.nl>

"Zdzich" <zdzislawsz_at_poczta.fm> wrote in message news:99lm4b$nra$1_at_news.tpi.pl...
> I've started migration from MSSQL Server to Oracle Server, so can you give
> me an answer for two questions?
> 1. Is there any tool for converting scripts from Transact-SQL to Oracle
SQL
> standard?
> 2. How can I make field with datatype integer to be automaticly
incrementing
> during INSERT command, I mean something like 'autonumbering'?
>
> Zdzich
>
>

Please download the Migration Workbench from http://technet.oracle.com It is supposed to address most of your needs.
With respect to the autonumbering, you need to study the sequence concept.

Regards,

Sybrand Bakker, Oracle DBA Received on Sun Mar 25 2001 - 15:08:02 CST