用于检查存储过程和视图中错误的SQL Server Management Studio工具

hec6srdp  于 2022-12-10  发布在  SQL Server
关注(0)|答案(1)|浏览(113)

我对SQL Server中某些表的架构进行了一些更改,并重命名了某些列,是否有办法将我所做的所有更改保存在单独的文件中,以便应用于生产数据库?
另外,是否有办法发现由于这些更改而在存储过程和视图中发生的错误?

clj7thdc

clj7thdc1#

I've done this 2 ways:

  1. The manual way, using a large SQL script created from a number of smaller scripts from SQL Server Management Studio or created by myself. It can be tricky but not so difficult once you've created a few of them.
  2. The automatic way - using RedGate SQL Compare. Much easier if you have access to it.
    When using both methods I would use require a Pre-Prod database (a copy of Production) for testing.

相关问题