[Help] SQL SERVER – Combined Multiple .SQL files into One Single File

[Trong]

DB1:

CREATE TABLE [dbo].[Item](
    [ItemID] [nchar](10) NOT NULL,
    [Money] [bigint] NOT NULL,
 CONSTRAINT [PK_Item] PRIMARY KEY CLUSTERED 
(
    [ItemID] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Account](
    [Index] [int] IDENTITY(1,1) NOT NULL,
    [AccountID] [nchar](10) NOT NULL,
    [AccountName] [int] NOT NULL,
    [ItemList] [int] NOT NULL,
) ON [PRIMARY]
GO


CREATE TABLE [dbo].[Money](
    [AccountID] [nchar](10) NOT NULL,
    [Money] [bigint] NOT NULL,
 CONSTRAINT [PK_Money] PRIMARY KEY CLUSTERED 
(
    [AccountID] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO

 

DB2:

CREATE TABLE [dbo].[Item](
    [ItemID] [nchar](10) NOT NULL,
    [Money] [bigint] NOT NULL,
    [ItemName] [bigint] NOT NULL,
    [MoneyType] [bigint] NOT NULL,
 CONSTRAINT [Item] PRIMARY KEY CLUSTERED 
(
    [ItemID] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO


CREATE TABLE [dbo].[Account](
    [Index] [int] IDENTITY(1,1) NOT NULL,
    [AccountID] [nchar](10) NOT NULL,
    [AccountName] [int] NOT NULL,
    [ItemList] [int] NOT NULL,
) ON [PRIMARY]
GO


CREATE TABLE [dbo].[Money](
    [AccountID] [nchar](10) NOT NULL,
    [Money] [bigint] NOT NULL,
    [MoneyType] [bigint] NOT NULL,
 CONSTRAINT [Money] PRIMARY KEY CLUSTERED 
(
    [AccountID] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO

 

Compare and merge database.

alter table [Item] add [ItemName] bigint not null default(0)
alter table [Item] add [MoneyType] bigint not null default(0)
alter table [Money] add [MoneyType] bigint not null default(0)

Please help automate code AutoIt to generation new code for large sql file.
Thanks

[JLogan3o13]

You're asking for help on your AutoIt code, but I see no AutoIt code. What have you tried?

[Trong]

 I am looking for a solution without use AutoIt code.

If no solution I will start with AutoIt code

 

[JLogan3o13]

Ok, well that is pretty confusing based on this line in your OP:

 

1 hour ago, Trong said:

Please help automate code AutoIt to generation new code for large sql file.

 

[Trong]

Oh Sorry for not clearly.

 

http://stackoverflow.com/questions/41486195/sql-server-combined-multiple-sql-files-into-one-single-file

Edited January 5, 2017 by Trong