Friday, March 23, 2012

Saving and restoring configuration

Hi all,

I have an SQL Server 7 machine which took me a while to get set up correctly. I have it fully documented in case I need to rebuild it but I'd like to have a (semi) automated rebuild procedure. Ideally this would involve me manually building the Windows and basic SQL Server installatoin then applying my SQL Server configuration on top. I can't use GHOST for various reasons.

I know that I can generate SQL scripts for various parts of the SQL Server configuration but does anyone know of a tool/utility which will help me do this?

TA,

H.May check tools from Redgate (http://www.red-gate.com) website.|||Thanks for the tip|||Hi,

the Red Gates stuff identifies differences (via the DTS Compare tool) but doesn't create a script of any sort.

Any other ideas anyone?

H.|||Check this article (http://www.informit.com/isapi/product_id~%7BFFF8022C-84BB-4509-9D52-68D4F1BC43AE%7D/content/index.asp) to create own unattended installation files for SQL Server configuration apart from generating SQL scripts.sql

No comments:

Post a Comment