mte01
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??
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??
What does the script look like?
Mike
Mike
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].[UPR1030 0]') 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].[UPR1030 4]') 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].[UPR4110 5]') 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].[UPR4130 0]') 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].[UPR4130 1]') 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].[UPR4130 2]') 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].[UPR4130 3]') 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].[UPR4160 0]') 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
/****** 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].[UPR1030
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].[UPR1030
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].[UPR4110
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].[UPR4130
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].[UPR4130
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].[UPR4130
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].[UPR4130
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].[UPR4160
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ahaa.....okk...thank you.....my problem has been solved right now because I re-installed MSSQL Server
ASKER