June 6, 2008 at 8:49 am
Does anyone have any experience with scripting out the settings for an instance of SQL 2005, by this I mean all logins, jobs, SSIS, linked servers etc. Is there anyway of doing this? Would Red Gate be able to do this or move confguration to a new server?
Buxton69
June 6, 2008 at 9:30 am
You can script most things like linked servers, logins, and jobs in SSMS. It's especially easy if you open the Summary tab (F7), highlight all, right-click, and script. SSIS packages are best saved to the file system.
Greg
June 6, 2008 at 10:24 am
Don't think there's a Red Gate tool to do this. Not sure you want to script server settings (sp_configure) to new servers. Maybe, but there are differences between servers you might want to change.
AFAIK, the best way to do this is use SSMS, script everything, and move it. SSIS needs to be moved separately. Suppose you could backup/restore MSDB. Might make me nervous. DTUTIL will export/import packages. Jobs you need to script.
No good way to clone the server. Ghost, maybe?
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
June 6, 2008 at 11:02 am
Greg Charles (6/6/2008)
It's especially easy if you open the Summary tab (F7), highlight all, right-click, and script.
Is this post-sp2 or something? What summary tab (F7)? (Prepared to feel stupid if the answer is obvious...:))
"Got no time for the jibba jabba!"
-B.A. Baracus
June 6, 2008 at 12:17 pm
ahutch (6/6/2008)
Greg Charles (6/6/2008)
It's especially easy if you open the Summary tab (F7), highlight all, right-click, and script.Is this post-sp2 or something? What summary tab (F7)? (Prepared to feel stupid if the answer is obvious...:))
On the Object Explorer you can press F7 and you should get a List view of the "selected folder" underlying objects ... ex: list of tables,sp,views, etc..
* Noel
June 6, 2008 at 1:17 pm
Erm...I hit F7 and nothing happens. Oh well...
I think I know what you are referring to, but not sure how this is any easier than using the generate scripts wizard...
"Got no time for the jibba jabba!"
-B.A. Baracus
June 6, 2008 at 2:20 pm
ahutch (6/6/2008)
Erm...I hit F7 and nothing happens. Oh well...I think I know what you are referring to, but not sure how this is any easier than using the generate scripts wizard...
you must have the Folder "highlighted".
For example Highlight the Jobs Folder then (F7) ...
* Noel
June 6, 2008 at 4:38 pm
Thanks for the replies, I've scripted out all the seperate parts before and just really wondered if there was a better way of doing it without restoring msdb or if there was a way to do it all together rather than doing all seperately.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply