Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> MS SQL 7 Script to Oracle
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 * frommaster.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')
select @loginlang = @@language exec sp_addlogin N'hoteluser', null, @logindb, @loginlangEND
/****** 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 * frommaster.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')
select @loginlang = @@language exec sp_addlogin N'idealbb', null, @logindb, @loginlangEND
/****** 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 * frommaster.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')
select @loginlang = @@language exec sp_addlogin N'idealscience', null, @logindb, @loginlangEND
/****** 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