Re: MS SQL 7 Script to Oracle

Jining Han wrote:

In your scripts are very fundamental table and user creation processes and permission granting.
Do a search/replace for all [], replace the go with /,

## ok its easy !

get rid of all your variable declarations

## what means this delete all ?
 declare @logindb nvarchar(132), @loginlang nvarchar(132)

then replace @
with & and your are almost done.

sure thats it ?
N'guest'
N'autoclose', N'false'

in oracle i think

N.'guest'
N.'autoclose', N.'false'

and IMHO master.dbo.syslanguages doesn´t exist

if &loginlang is null or (not exists (select * from master.dbo.syslanguages where name = &loginlang) and &loginlang <> N.'us_english')

Thanks Roland

> 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
> >

> Received on Sun Feb 11 2001 - 09:08:12 CST