如何将生产环境的字段类型从INT修改为BIGINT

BusinessEntityID BIGINT NOT NULL,PersonType NCHAR(<span style="color: #800080">2<span style="color: #000000">) NOT NULL,NameStyle dbo.NameStyle NOT NULL,Title NVARCHAR(<span style="color: #800080">8<span style="color: #000000">) NULL,FirstName dbo.Name NOT NULL,MiddleName dbo.Name NULL,LastName dbo.Name NOT NULL,Suffix NVARCHAR(<span style="color: #800080">10<span style="color: #000000">) NULL,EmailPromotion INT NOT NULL,AdditionalContactInfo XML(CONTENT Person.AdditionalContactInfoSchemaCollection) NULL,Demographics XML(CONTENT Person.IndividualSurveySchemaCollection) NULL,rowguid UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL,ModifiedDate DATETIME NOT NULL,CONSTRAINT PK_Person_BusinessEntityIDNEW

PRIMARY KEY CLUSTERED (BusinessEntityID ASC)

WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY =<span style="color: #000000"> OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS =<span style="color: #000000"> ON

) ON [PRIMARY]

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY];

GO

6000创建下一个SSIS包。增量插入。我每天都这样做，以保持数据传输时间的减少。下面提供了用于Person表的SSIS包中使用的查询。