Link to home
Start Free TrialLog in
Avatar of mte01
mte01Flag for Lebanon

asked on

Urgent:Generating a Database from SQL Script

Hey experts,

I have a database in the form of an SQL script (its data & meta-data), and I want to generate a database on Access using this script......any help??
Avatar of mte01
mte01
Flag of Lebanon image

ASKER

Can anyone help...this question is a bit urgent....
What does the script look like?

Mike
Avatar of mte01

ASKER

Something like that:



/****** Object:  Table [dbo].[UPR10300]    Script Date: 07/30/2004 4:16:04 PM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UPR10300]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[UPR10300]
GO

/****** Object:  Table [dbo].[UPR10304]    Script Date: 07/30/2004 4:16:04 PM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UPR10304]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[UPR10304]
GO

/****** Object:  Table [dbo].[UPR41105]    Script Date: 07/30/2004 4:16:04 PM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UPR41105]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[UPR41105]
GO

/****** Object:  Table [dbo].[UPR41300]    Script Date: 07/30/2004 4:16:04 PM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UPR41300]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[UPR41300]
GO

/****** Object:  Table [dbo].[UPR41301]    Script Date: 07/30/2004 4:16:04 PM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UPR41301]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[UPR41301]
GO

/****** Object:  Table [dbo].[UPR41302]    Script Date: 07/30/2004 4:16:04 PM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UPR41302]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[UPR41302]
GO

/****** Object:  Table [dbo].[UPR41303]    Script Date: 07/30/2004 4:16:04 PM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UPR41303]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[UPR41303]
GO

/****** Object:  Table [dbo].[UPR41600]    Script Date: 07/30/2004 4:16:04 PM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UPR41600]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[UPR41600]
GO

/****** Object:  Table [dbo].[UPR10300]    Script Date: 07/30/2004 4:16:13 PM ******/
CREATE TABLE [dbo].[UPR10300] (
      [CMPANYID] [smallint] NOT NULL ,
      [USERID] [char] (15) COLLATE Latin1_General_BIN NOT NULL ,
      [PYRLACTV] [char] (7) COLLATE Latin1_General_BIN NOT NULL ,
      [DEX_ROW_ID] [int] IDENTITY (1, 1) NOT NULL
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[UPR10304]    Script Date: 07/30/2004 4:16:15 PM ******/
CREATE TABLE [dbo].[UPR10304] (
      [CMPANYID] [smallint] NOT NULL ,
      [BACHNUMB] [char] (15) COLLATE Latin1_General_BIN NOT NULL ,
      [UPRBCHOR] [smallint] NOT NULL ,
      [USERID] [char] (15) COLLATE Latin1_General_BIN NOT NULL ,
      [UPRBCHST] [smallint] NOT NULL ,
      [DEX_ROW_ID] [int] IDENTITY (1, 1) NOT NULL
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[UPR41105]    Script Date: 07/30/2004 4:16:16 PM ******/
CREATE TABLE [dbo].[UPR41105] (
      [CCode] [char] (7) COLLATE Latin1_General_BIN NOT NULL ,
      [CCodeDesc] [char] (31) COLLATE Latin1_General_BIN NOT NULL ,
      [DEX_ROW_ID] [int] IDENTITY (1, 1) NOT NULL
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[UPR41300]    Script Date: 07/30/2004 4:16:17 PM ******/
CREATE TABLE [dbo].[UPR41300] (
      [TAXCODE] [char] (7) COLLATE Latin1_General_BIN NOT NULL ,
      [DSCRIPTN] [char] (31) COLLATE Latin1_General_BIN NOT NULL ,
      [TXCALCTN_1] [smallint] NOT NULL ,
      [TXCALCTN_2] [smallint] NOT NULL ,
      [TXCALCTN_3] [smallint] NOT NULL ,
      [TXCALCTN_4] [smallint] NOT NULL ,
      [TXCALCTN_5] [smallint] NOT NULL ,
      [TXCALCTN_6] [smallint] NOT NULL ,
      [TXCALCTN_7] [smallint] NOT NULL ,
      [TXCALCTN_8] [smallint] NOT NULL ,
      [TXCALCTN_9] [smallint] NOT NULL ,
      [TXCALCTN_10] [smallint] NOT NULL ,
      [ESTDEDTN] [numeric](19, 5) NOT NULL ,
      [DEPEXMPT] [numeric](19, 5) NOT NULL ,
      [MXEICPMT] [numeric](19, 5) NOT NULL ,
      [EXWGLIMT] [numeric](19, 5) NOT NULL ,
      [EXTXRATE] [int] NOT NULL ,
      [DEX_ROW_ID] [int] IDENTITY (1, 1) NOT NULL
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[UPR41301]    Script Date: 07/30/2004 4:16:17 PM ******/
CREATE TABLE [dbo].[UPR41301] (
      [TAXCODE] [char] (7) COLLATE Latin1_General_BIN NOT NULL ,
      [TXFLGSTS] [char] (7) COLLATE Latin1_General_BIN NOT NULL ,
      [STSDESCR] [char] (31) COLLATE Latin1_General_BIN NOT NULL ,
      [LINCLIM] [numeric](19, 5) NOT NULL ,
      [PRSEXAMT] [numeric](19, 5) NOT NULL ,
      [INCPSNEX] [tinyint] NOT NULL ,
      [INCADALW] [tinyint] NOT NULL ,
      [INCLDEPN] [tinyint] NOT NULL ,
      [FDTXPRCT] [int] NOT NULL ,
      [FEDTXMAX] [numeric](19, 5) NOT NULL ,
      [FICATXPT] [int] NOT NULL ,
      [FICATXMN] [numeric](19, 5) NOT NULL ,
      [FLATAXRT] [int] NOT NULL ,
      [STDDMTHD] [smallint] NOT NULL ,
      [STDDPCNT] [int] NOT NULL ,
      [STDDEDAM] [numeric](19, 5) NOT NULL ,
      [STDEDMIN] [numeric](19, 5) NOT NULL ,
      [STDEDMAX] [numeric](19, 5) NOT NULL ,
      [SPCLEXAM] [numeric](19, 5) NOT NULL ,
      [SPCLSDED] [numeric](19, 5) NOT NULL ,
      [SPCLTXRT] [int] NOT NULL ,
      [DEX_ROW_ID] [int] IDENTITY (1, 1) NOT NULL
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[UPR41302]    Script Date: 07/30/2004 4:16:18 PM ******/
CREATE TABLE [dbo].[UPR41302] (
      [TAXCODE] [char] (7) COLLATE Latin1_General_BIN NOT NULL ,
      [TXFLGSTS] [char] (7) COLLATE Latin1_General_BIN NOT NULL ,
      [TXTBLTYP] [smallint] NOT NULL ,
      [TXTBLSEQ] [smallint] NOT NULL ,
      [TXBRULMT] [numeric](19, 5) NOT NULL ,
      [TXBRKTAM] [numeric](19, 5) NOT NULL ,
      [RXBRKTRT] [int] NOT NULL ,
      [TXBREXWG] [numeric](19, 5) NOT NULL ,
      [DEX_ROW_ID] [int] IDENTITY (1, 1) NOT NULL
) ON [PRIMARY]
GO

................etc


ASKER CERTIFIED SOLUTION
Avatar of Data-Man
Data-Man
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mte01

ASKER

Ahaa.....okk...thank you.....my problem has been solved right now because I re-installed MSSQL Server