Re: MS SQL 7 Script to Oracle

Not that I am aware of other than exploring the reverse engineering capabilities of a product such as ERwin. But even if I could do it ... I wouldn't.

Oracle's SQL implementation is far richer and more capable than TSQL.

And, looking below at your CREATE DATABASE statements ... it is easy to see that they would be totally meaningless in Oracle. And as an editorial aside ... it is easy to see from the "simplicity" why Oracle so easily outperform SQL Server.

Daniel A. Morgan

Roland Sippel wrote:

> Hey,
> i have a Microsoft SQL 7.0 or SQL 2000 Script.
>
> Is there is a way to import the script (about 400 Lines), in Oracle
> 7.43 or Oracle 8i ?
>
> Thanks Roland
>
> ###
> Here is a short strip SQL 7.0:
>
> /****** Object: Database adalbb Script Date: 1/27/2001 3:39:47 PM
> ******/
> IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name =
> N'idealbb')
> DROP DATABASE [idealbb]
> GO
>
> CREATE DATABASE [idealbb] ON (NAME = N'idealbb_Data', FILENAME =
> N'C:\MSSQL7\Data\adalbb_Data.MDF' , SIZE = 2, FILEGROWTH = 10%) LOG ON
> (NAME = N'idealbb_Log', FILENAME = N'C:\MSSQL7\Data\adalbb_Log.LDF' ,
> SIZE = 1, FILEGROWTH = 10%)
>
> GO
> exec sp_dboption N'idealbb', N'autoclose', N'false'
> GO
> exec sp_dboption N'idealbb', N'bulkcopy', N'false'
> GO
>
> /****** Object: Table [dbo].[Topics] Script Date: 1/27/2001 3:39:52
> PM ******/
> if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].
> [Topics]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
> drop table [dbo].[Topics]
> GO
>
> /****** Object: Login hoteluser Script Date: 1/27/2001 3:39:47 PM
> ******/
> if not exists (select * from master.dbo.syslogins where loginname =
> N'hoteluser')
> BEGIN
> declare @logindb nvarchar(132), @loginlang nvarchar(132) select
> @logindb = N'master', @loginlang = N'us_english'
> if @logindb is null or not exists (select * from
> master.dbo.sysdatabases where name = @logindb)
> select @logindb = N'master'
> if @loginlang is null or (not exists (select * from
> master.dbo.syslanguages where name = @loginlang) and @loginlang <>
> N'us_english')
> select @loginlang = @@language
> exec sp_addlogin N'hoteluser', null, @logindb, @loginlang
> END
> GO
>
> /****** Object: Login idealbb Script Date: 1/27/2001 3:39:47 PM
> ******/
> if not exists (select * from master.dbo.syslogins where loginname =
> N'idealbb')
> BEGIN
> declare @logindb nvarchar(132), @loginlang nvarchar(132) select
> @logindb = N'idealbb', @loginlang = N'us_english'
> if @logindb is null or not exists (select * from
> master.dbo.sysdatabases where name = @logindb)
> select @logindb = N'master'
> if @loginlang is null or (not exists (select * from
> master.dbo.syslanguages where name = @loginlang) and @loginlang <>
> N'us_english')
> select @loginlang = @@language
> exec sp_addlogin N'idealbb', null, @logindb, @loginlang
> END
> GO
>
> /****** Object: Login idealscience Script Date: 1/27/2001 3:39:47
> PM ******/
> if not exists (select * from master.dbo.syslogins where loginname =
> N'idealscience')
> BEGIN
> declare @logindb nvarchar(132), @loginlang nvarchar(132) select
> @logindb = N'idealscience', @loginlang = N'us_english'
> if @logindb is null or not exists (select * from
> master.dbo.sysdatabases where name = @logindb)
> select @logindb = N'master'
> if @loginlang is null or (not exists (select * from
> master.dbo.syslanguages where name = @loginlang) and @loginlang <>
> N'us_english')
> select @loginlang = @@language
> exec sp_addlogin N'idealscience', null, @logindb, @loginlang
> END
> GO
>
> /****** Object: User dbo Script Date: 1/27/2001 3:39:47 PM ******/
> /****** Object: User guest Script Date: 1/27/2001 3:39:47 PM ******/
> if not exists (select * from dbo.sysusers where name = N'guest' and uid
> < 16382 and hasdbaccess = 1)
> EXEC sp_grantdbaccess N'guest'
> GO
>
> /****** Object: User idealbb Script Date: 1/27/2001 3:39:48 PM
> ******/
> if not exists (select * from dbo.sysusers where name = N'idealbb' and
> uid < 16382)
> EXEC sp_grantdbaccess N'idealbb', N'idealbb'
> GO
>
> /****** Object: Table [dbo].[Category] Script Date: 1/27/2001
> 3:39:54 PM ******/
> CREATE TABLE [dbo].[Category] (
> [Cat_ID] [int] IDENTITY (1, 1) NOT NULL ,
> [Cat_Name] [varchar] (50) NULL ,
> [Cat_Order] [int] NULL
> ) ON [PRIMARY]
> GO
>
> /****** Object: Table [dbo].[Forum] Script Date: 1/27/2001 3:39:55
> PM ******/
> CREATE TABLE [dbo].[Forum] (
> [Forum_ID] [int] IDENTITY (1, 1) NOT NULL ,
> [F_Name] [varchar] (50) NULL ,
> [F_Description] [varchar] (300) NULL ,
> [F_Cat] [int] NULL ,
> [F_Count] [int] NULL ,
> [F_Last_Post] [datetime] NULL ,
> [F_Moderator] [int] NULL ,
> [F_ReplyCount] [int] NULL ,
> [F_Order] [int] NULL ,
> [F_AllowAnonymous] [int] NULL ,
> [F_AllowMember] [int] NULL ,
> [F_AllowModerator] [int] NULL ,
> [F_AllowAdministrator] [int] NULL ,
> [R_AllowAnonymous] [int] NULL ,
> [R_AllowMember] [int] NULL ,
> [R_AllowModerator] [int] NULL ,
> [R_AllowAdministrator] [int] NULL
> ) ON [PRIMARY]
> GO
>
> Sent via Deja.com
> http://www.deja.com/
  Received on Fri Feb 09 2001 - 23:56:27 CST