RavenDB to SQL Server sql script sample

script

CREATE TABLE [dbo].[OrderLines]
(
    [Id] int IDENTITY CONSTRAINT PK_OrderLines PRIMARY KEY NONCLUSTERED,
    [OrderId] [nvarchar](50) NOT NULL,
    [Qty] [int] NOT NULL,
    [Product] [nvarchar](255) NOT NULL,
    [Cost] [int] NOT NULL
);

CREATE CLUSTERED INDEX IX_OrderLines_OrderId
ON [dbo].[OrderLines]([OrderId]);
 
CREATE TABLE [dbo].[Orders]
(
    [Id] [nvarchar](50) NOT NULL CONSTRAINT PK_Orders PRIMARY KEY,
    [OrderLinesCount] [int] NOT NULL,
    [TotalCost] [int] NOT NULL
);