Skip to main content
Software Engineering

Return to Answer

syntax highlighting
Source Link
edit approved Feb 1, 2019 at 8:49
Glorfindel
edit approved Feb 1, 2019 at 8:49
Glorfindel
  • 3.2k
  • 6
  • 28
  • 34

You need to write/generate scripts that have the changes you made in them. For example if you add a few columns to the table the SQL for this might be:

ALTER TABLE dbo.doc_exa ADD column_b VARCHAR(20) NULL, column_c INT NULL ;

ALTER TABLE dbo.doc_exa ADD column_b VARCHAR(20) NULL, column_c INT NULL ;

Depending on the toolsets you have and the databases you use, there are various products that will help automate the generation of code. For example, In the SQL server world you could use Visual Studio database projects or Redgate. Other platforms will have similar tools available.

You need to write/generate scripts that have the changes you made in them. For example if you add a few columns to the table the SQL for this might be:

ALTER TABLE dbo.doc_exa ADD column_b VARCHAR(20) NULL, column_c INT NULL ;

Depending on the toolsets you have and the databases you use, there are various products that will help automate the generation of code. For example, In the SQL server world you could use Visual Studio database projects or Redgate. Other platforms will have similar tools available.

You need to write/generate scripts that have the changes you made in them. For example if you add a few columns to the table the SQL for this might be:

ALTER TABLE dbo.doc_exa ADD column_b VARCHAR(20) NULL, column_c INT NULL ;

Depending on the toolsets you have and the databases you use, there are various products that will help automate the generation of code. For example, In the SQL server world you could use Visual Studio database projects or Redgate. Other platforms will have similar tools available.

added 5 characters in body
Source Link
Lobsterpants
Lobsterpants
  • 193
  • 8

You need to write/generate scripts that have the changes you made in them. For example if you add a few columns to the table the SQL for this might be:

ALTER TABLE dbo.doc_exa ADD column_b VARCHAR(20) NULL, column_c INT NULL ;

Depending on the toolsets you have and the databases you use, there are various products that will help automate the generation of code. For example, In the SQL server world you could use Visual Studio database projects or Redgate. OtehrOther platforms will have similar tools available.

You need to write/generate scripts that have the changes you made in them. For example if you add a few columns to the table the SQL for this might be:

ALTER TABLE dbo.doc_exa ADD column_b VARCHAR(20) NULL, column_c INT NULL ;

Depending on the toolsets you have and the databases you use there are various products that will help automate the generation of code. For example, In the SQL server world you could Visual Studio database projects or Redgate. Otehr platforms will have similar tools available.

You need to write/generate scripts that have the changes you made in them. For example if you add a few columns to the table the SQL for this might be:

ALTER TABLE dbo.doc_exa ADD column_b VARCHAR(20) NULL, column_c INT NULL ;

Depending on the toolsets you have and the databases you use, there are various products that will help automate the generation of code. For example, In the SQL server world you could use Visual Studio database projects or Redgate. Other platforms will have similar tools available.

Source Link
Lobsterpants
Lobsterpants
  • 193
  • 8

You need to write/generate scripts that have the changes you made in them. For example if you add a few columns to the table the SQL for this might be:

ALTER TABLE dbo.doc_exa ADD column_b VARCHAR(20) NULL, column_c INT NULL ;

Depending on the toolsets you have and the databases you use there are various products that will help automate the generation of code. For example, In the SQL server world you could Visual Studio database projects or Redgate. Otehr platforms will have similar tools available.