What is the steps for switching from access to MS SQL 2000
Do I need to create the database and tables manualy?
Thanks,
Do I need to create the database and tables manualy?
Thanks,
If this is your first visit, be sure to check out the FAQ. You must register before you can post.
IMPORTANT: Your first post will be checked for appropriate content. This may take a bit of time.
/****** Object: Table [dbo].[tblLog] Script Date: 8/1/2005 8:47:52 AM ******/
CREATE TABLE [dbo].[tblLog] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[Log_Date] [datetime] NOT NULL ,
[Log_Type] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Log_Data] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[tblSyslog] Script Date: 8/1/2005 8:47:52 AM ******/
CREATE TABLE [dbo].[tblSyslog] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[Syslog_Date] [datetime] NOT NULL ,
[Syslog_Facility] [int] NOT NULL ,
[Syslog_Severity] [int] NOT NULL ,
[Syslog_Hostname] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Syslog_Msg_Tag] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Syslog_Msg_Content] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[tblSyslogFacility] Script Date: 8/1/2005 8:47:53 AM ******/
CREATE TABLE [dbo].[tblSyslogFacility] (
[Facility_Code] [int] NOT NULL ,
[Facility_Description] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[tblSyslogSeverity] Script Date: 8/1/2005 8:47:53 AM ******/
CREATE TABLE [dbo].[tblSyslogSeverity] (
[Severity_Code] [int] NOT NULL ,
[Severity_Desc_Short] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Severity_Desc_Long] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[tblTemperature] Script Date: 8/1/2005 8:47:53 AM ******/
CREATE TABLE [dbo].[tblTemperature] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[Temp_Date] [datetime] NOT NULL ,
[Temp_Device] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Temp_Value] [numeric](10, 0) NOT NULL
) ON [PRIMARY]
GO
Provider=SQLOLEDB;Data Source=MEDIACENTER\SQLEXPRESS;Initial Catalog=HomeSeerDB;Trusted_Connection=yes
Provider=SQLOLEDB;Data Source=MEDIACENTER\SQLEXPRESS;Initial Catalog=HomeSeerDB;Trusted_Connection=yes
USE [HomeSeerDB]
GO
/****** Object: Table [dbo].[tblDeviceStatusLog] Script Date: 07/30/2009 19:42:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tblDeviceStatusLog](
[id] [int] IDENTITY(1,1) NOT NULL,
[ts] [datetime] NULL,
[hc] [char](1) NOT NULL,
[dc] [varchar](3) NOT NULL,
[status] [int] NOT NULL,
[data1] [int] NULL,
[data2] [int] NULL,
CONSTRAINT [pkID2] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
USE [HomeSeerDB]
GO
/****** Object: Table [dbo].[tblDeviceValueLog] Script Date: 07/30/2009 19:44:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tblDeviceValueLog](
[id] [int] IDENTITY(1,1) NOT NULL,
[ts] [datetime] NULL,
[hc] [char](1) NOT NULL,
[dc] [varchar](3) NOT NULL,
[data1] [int] NOT NULL,
[data2] [int] NOT NULL,
CONSTRAINT [pkID1] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
Comment