xwrs
xwrs

Reputation: 1297

MS SQL database schema change without data loss

The task is to make changes to current tables structure without recreating these tables.

Is there a tool which resolves this task without making developers to write sql queries?

Thanks

Upvotes: 2

Views: 1310

Answers (1)

Cade Roux
Cade Roux

Reputation: 89661

Some kinds of changes can be made without loss and some can't.

Have a look at RedGate SQL Compare - it will tell you when operations have possible loss consequences.

Upvotes: 2

Related Questions