[ 6366 ] Re: Re: Re: Re: H2DBから別のDBへの移植について
基本的に、設計書の通りに修正しています。
そして、チューニングして、DBのIndexなども見直したりします。
例えば、SQLSERVER2014のアカウントテーブルのスクリプトですが、
----Code----
USE [GSESSION]
GO
/****** Object: Table [dbo].[WML_ACCOUNT] Script Date: 2015/10/30 10:50:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[WML_ACCOUNT](
[WAC_SID] [int] NOT NULL,
[WAC_TYPE] [int] NOT NULL,
[USR_SID] [int] NULL,
[WAC_NAME] [varchar](max) NOT NULL,
[WAC_ADDRESS] [varchar](max) NOT NULL,
[WAC_SEND_HOST] [varchar](max) NOT NULL,
[WAC_SEND_PORT] [int] NOT NULL,
[WAC_SEND_USER] [varchar](max) NULL,
[WAC_SEND_PASS] [varchar](max) NULL,
[WAC_SEND_SSL] [int] NOT NULL,
[WAC_RECEIVE_TYPE] [int] NOT NULL,
[WAC_RECEIVE_HOST] [varchar](max) NOT NULL,
[WAC_RECEIVE_PORT] [int] NOT NULL,
[WAC_RECEIVE_USER] [varchar](max) NOT NULL,
[WAC_RECEIVE_PASS] [varchar](max) NOT NULL,
[WAC_RECEIVE_SSL] [int] NOT NULL,
[WAC_DISK] [int] NOT NULL,
[WAC_DISK_SIZE] [int] NOT NULL,
[WAC_BIKO] [varchar](max) NULL,
[WAC_ORGANIZATION] [varchar](max) NULL,
[WAC_SIGN] [varchar](max) NULL,
[WAC_SIGN_POINT_KBN] [int] NOT NULL,
[WAC_SIGN_DSP_KBN] [int] NOT NULL,
＜中略＞
[WAC_RECEIVE_DATE] [datetime2](7) NULL,
[WAC_JKBN] [int] NOT NULL,
[WAC_AUTO_RECEIVE_TIME] [int] NOT NULL,
[WAC_THEME] [int] NOT NULL,
[WAC_CHECK_ADDRESS] [int] NOT NULL,
[WAC_CHECK_FILE] [int] NOT NULL,
[WAC_COMPRESS_FILE] [int] NOT NULL,
[WAC_TIMESENT] [int] NOT NULL,
[WAC_QUOTES] [int] NOT NULL,
[WAC_DISK_SPS] [int] NOT NULL,
[WAC_AUTORECEIVE_AP] [int] NULL,
[WAC_TIMESENT_DEF] [int] NULL,
[WAC_COMPRESS_FILE_DEF] [int] NULL,
PRIMARY KEY CLUSTERED
(
[WAC_SID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
----Code----
ご参考まで
投稿者yangjiayi 最新書き込み2015/10/30 10:52:28
|