CrTablesForBackup.sql

USE [OrdersDb]
GO
CREATE TABLE [dbo].[Order](
	[Id] [bigint] IDENTITY(1,1) NOT NULL,
	[Description] [nvarchar](50) NOT NULL
) ON [PRIMARY]
GO
insert into [dbo].[Order] (Description) 
select 'The first [Order] Description' union all
select 'The second [Order] Description' ;

USE [CustomersDb]
GO
CREATE TABLE [dbo].[Customer](
	[Id] [bigint] IDENTITY(1,1) NOT NULL,
	[Description] [nvarchar](50) NOT NULL
) ON [PRIMARY]
GO
insert into [dbo].[Customer] (Description) 
select 'The first [Customer] Description' union all
select 'The second [Customer] Description' ;

USE [DataWarehouseDb]
GO
CREATE TABLE [dbo].[OrderDimension](
	[Id] [bigint] IDENTITY(1,1) NOT NULL,
	[Description] [nvarchar](50) NOT NULL
) ON [PRIMARY]
GO
insert into [dbo].[OrderDimension] (Description) 
select 'The first [OrderDimension] Description' union all
select 'The second [OrderDimension] Description' ;