M
M
MaxLich2018-01-30 14:58:15
Microsoft SQL Server Management Studio
MaxLich, 2018-01-30 14:58:15

How to view the history of changes to database structures in MS SQL Server Management Studio?

Hello. Some changes were made to the finished database (tables were created, columns were added, columns were deleted, keys and an index were created, etc.). You need to look at the history of these changes over a certain period of time. How can this be done in this program? Or is there no such possibility?

Answer the question

In order to leave comments, you need to log in

3 answer(s)
A
Artyom Karetnikov, 2018-01-31
@art_karetnikov

Of course, there is such a possibility. Make a trigger for changes, there are two steps:
1. Create a table where changes will be written.
2. create a trigger on the database.
In this case, I store: who, when, how it was, how it became, the date-time of the change.

K
Konstantin Tsvetkov, 2018-01-30
@tsklab

MICROSOFT SQL SERVER MANAGEMENT STUDIO You need to look at the history of these changes over some period of time. How can this be done in this program? Or is there no such possibility?
No.
To track changes in the database structure , after the change, you need to make a complete "Create Database" script and feed it to any version control system.
There are third-party programs that can make a script difference between database versions.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question