Re: MS SQL 7 Script to Oracle

In article <960p46$pbv$1_at_nnrp1.deja.com>,   Roland Sippel <sippel.r_at_ks-keb.de> 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/
>

In your scripts are very fundamental table and user creation processes and permission granting. Do a search/replace for all [], replace the go with /, get rid of all your variable declarations then replace @ with & and your are almost done.

--
Jining Han
Sallie Mae


Sent via Deja.com
http://www.deja.com/