Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I am not a DBA/server admin, and unfortunately we don't really have any currently. My organization wants to move a SQL server 2008 instance running on Windows Server 2003 (physical) over to 2008R2 running on Windows Server 2008 (Virtual).

I am wondering if there are any tools that would make this process as painless as possible? We want to move over everything icluding logins, SQL agent jobs, etc if possible. It looks like we could use the built-in Copy Database Wizard to move the databases themselves, but how about the other server objects?

share|improve this question
1  
Is it just performing too quickly for you? there's got to be a reason why you'd want to make your first VM a DB server right? The first rule of virtualising is 'don't virtualise DB boxes without a lot of thought'. –  Chopper3 Jun 14 '12 at 16:53
    
We have other virtual servers running 2008 (web servers mostly), so my understanding is that it's pretty easy for them to set a new one up. If it will cause performance issues I could certainly make the case that we need a dedicated physical box. Again, I am not a DBA/server guy so forgive my lack of knowledge in the area. –  King Jun 14 '12 at 16:58
    
Seriously - hire a consultant for this. This site is meant for admins, which you admit that you're not. You're asking for a couple hundred bucks worth of free work. If you said : "I'm learning on the job, and here's what I've tried, and I got stuck here" that would be entirely different and in-line with the intent of this site. You're asking for someone to plan this project for you, and/or this is a shopping question for tools. –  mfinni Jun 14 '12 at 17:20
    
I don't need anything like that, all I really wanted to know is if there is a tool that would just help a little bit. A name or a link. If we need to script out what we can and do the rest manually then we will. I just figured if there were any helpful tools out there, this would be the place to ask. –  King Jun 14 '12 at 17:32
add comment

1 Answer

up vote 1 down vote accepted

I have never done this myself but I see no reason why it can't work, if you have access to integration services have a look at the following links.

http://www.mssqltips.com/sqlservertip/2064/transfer-database-task-and-transfer-sql-server-objects-task-in-ssis/

http://www.mssqltips.com/sqlservertip/2081/transfer-sql-server-jobs-task-and-transfer-sql-server-logins-task-in-ssis/

The second link was the top result of the google search for "migrate SQL jobs and logins", there are quite a few results so you may want to read through them and see if there are any more results that would suit you better

share|improve this answer
    
That looks like it could work. I also found this mssqltips.com/sqlservertip/1792/… from that link. It appears the wizard handles more than I initially thought. –  King Jun 14 '12 at 18:03
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.