LOBS error while table migration to in-memory optimized

Here is my code.I think nvarchar(max) is not supported by in memory optimized.If it is not,where is the error?

CREATE TABLE [dbo].[TransactionLine2](
[OID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
[Active] [int] NULL,
[CreatedOn] [datetime] NULL,
[CreatedBy] [uniqueidentifier] NULL,
[LastModifiedOn] [datetime] NULL,
[LastModifiedBy] [uniqueidentifier] NULL,
[LastLogoFeedBack] [datetime] NULL,
[LogicalRef] [int] NULL,
[LogoImportTime] [datetime] NULL,
[LogoExportTime] [datetime] NULL,
[LineNumber] [int] NULL,
[LineType] [int] NULL,
[ItemID] [int] NULL,
[UnitID] [int] NULL,
[UnitConv1] [float] NULL,
[UnitConv2] [float] NULL,
[Amount] [float] NULL,
[Price] [float] NULL,
[Total] [float] NULL,
[VatRate] [float] NULL,
[SpecialCode] [nvarchar](100) NULL,
[DeliveryCode] [nvarchar](100) NULL,
[SourceWarehouseID] [int] NULL,
[Description] [nvarchar](100) NULL,
[TransactionID] [int] NULL,
[InvoiceID] [int] NULL,
[VariantID] [int] NULL,
[CostRate] [float] NULL,
[DestinationWarehouseID] [int] NULL,
[LogoProductionOrderLineRef] [int] NULL,
[PayPlanID] [int] NULL,
[OrderLine] [int] NULL,
[DependedTransactionLineID] [int] NULL,
[ControlStatus] [int] NULL,
[ControlQuantity] [int] NULL,
[OptimisticLockField] [int] NULL,
[CaseStockCardID] [int] NULL,
[CaseAmount] [float] NULL,
[CaseRequiredAmount] [float] NULL,
[UserDefinedSalesDispatchLineID] [int] NULL,
[UnitSetID] [int] NULL,
[Percent] [float] NULL,
[Currency] [int] NULL,
[CurrencyRate] [float] NULL,
[GLAccountID] [int] NULL,
[ExpenseCenterID] [int] NULL,
[ProjectID] [int] NULL,
[DueDate] [datetime] NULL,
[DetailedDescription] [nvarchar](max) NULL,
[OutputCode] [nvarchar](100) NULL,
[ReturnCostType] [int] NULL,
[CollateralAffectRisk] [bit] NULL,
[AffectRisk] [bit] NULL,
[Locked] [bit] NULL,
[ActiveUser] [uniqueidentifier] NULL,
[ConvFactor1] [float] NULL,
[ConvFactor2] [float] NULL,
[QualityControlForm] [uniqueidentifier] NULL,
[LaboratoryTestResultID] [int] NULL,
[SpecialCode1] [nvarchar](10) NULL,
[SpecialCode2] [nvarchar](10) NULL,
[SpecialCode3] [nvarchar](10) NULL,
[SpecialCode4] [nvarchar](10) NULL,
[SpecialCode5] [nvarchar](10) NULL,
[SpecialCode6] [nvarchar](10) NULL,
[SpecialCode7] [nvarchar](10) NULL,
[SpecialCode8] [nvarchar](10) NULL,
[SpecialCode9] [nvarchar](10) NULL,
[SpecialCode10] [nvarchar](10) NULL,
[SpecialValue1] [float] NULL,
[SpecialValue2] [float] NULL,
[SpecialValue3] [float] NULL,
[SpecialValue4] [float] NULL,
[SpecialValue5] [float] NULL,
[SpecialValue6] [float] NULL,
[SpecialValue7] [float] NULL,
[SpecialValue8] [float] NULL,
[SpecialValue9] [float] NULL,
[SpecialValue10] [float] NULL,
[SpecialDate1] [datetime] NULL,
[SpecialDate2] [datetime] NULL,
[SpecialDate3] [datetime] NULL,
[SpecialDate4] [datetime] NULL,
[SpecialDate5] [datetime] NULL,
[SpecialDate6] [datetime] NULL,
[SpecialDate7] [datetime] NULL,
[SpecialDate8] [datetime] NULL,
[SpecialDate9] [datetime] NULL,
[SpecialDate10] [datetime] NULL,
[PackageID] [int] NULL,
[WorkOrderID] [int] NULL,
[IsPeriodLocked] [bit] NULL,
[ShippedDate] [datetime] NULL,
[PLAmount] [float] NULL,
[ShippedAmount] [float] NULL,
[ShippingStatus] [int] NULL,
[ShippedTransactionLineID] [int] NULL,
[DemandingFicheLine] [int] NULL,
[subcontractorDemanFicheLineID ] [int] NULL,
[PackagingFicheID] [int] NULL,
[TransferFicheLineID] [int] NULL,
[LastControl] [bit] NULL,

September 1st, 2015 2:18am

Hi Ceakn,

You are right if you are using SQl Server 2014.This was a limitation in SQl Server 2014 but this feature is vailable in SQL Server 2016.

Please find the below image about the enhancements  in Sql Server 2016

Free Windows Admin Tool Kit Click here and download it now
September 1st, 2015 2:40am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics