Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> MS SQL 7 Script to Oracle

MS SQL 7 Script to Oracle

From: Roland Sippel <sippel.r_at_ks-keb.de>
Date: Fri, 09 Feb 2001 12:51:20 GMT
Message-ID: <960p46$pbv$1@nnrp1.deja.com>

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 - 06:51:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US