Path: newssvr20.news.prodigy.com!newsmst01a.news.prodigy.com!prodigy.com!news.glorb.com!postnews1.google.com!not-for-mail From: clayfix98@yahoo.com Newsgroups: comp.databases.oracle.server Subject: MSSQL to Oracle 9i - conversion Date: 28 Apr 2004 14:23:48 -0700 Organization: http://groups.google.com Lines: 20 Message-ID: NNTP-Posting-Host: 63.167.132.141 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1083187428 19312 127.0.0.1 (28 Apr 2004 21:23:48 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Wed, 28 Apr 2004 21:23:48 +0000 (UTC) Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:260336 Hi all, I am not very familiar with database but I have a general question about Database Scripts. -- We currently have a database script that executes on MSSQL 2000 (Windows). It builds the database for MSSQL 2000 for our application. Now, we want to take the same exact script and use it for Oracle 9i on UNIX. Is there a tool that would convert the database script from MSSQL 2000 to Oracle 9i (UNIX)? It would be great to find a program that would take my original MSSQL 2000 script and it convert it to the proper syntax so that Oracle can use it to build the my database. (Does Oracle have a tool or mode that will read MSSQL 2000 syntax?) Our database is not very fancy but I notice that SQL syntax for Oracle looks a lot different than the MSSQL script. Any recommendations would be greatly appreciated. --Rookie database person