export SQL user, maintenance tasks and operators

Hi Experts,

I have to do a SQL DB migration from SQL2008 to SQL2014.
The new SQL2014 is ready and installed with availability groups.
On the old system I have a lot of SQL users installed and maintenance tasks and one operator.
The operator sends all 2 hours an TSQL script to the server and the output comes via email to us.

Is it possible somehow to export all users with password, maintenance tasks and operator function to my new SQL2014 server ?
Eprs_AdminSystem ArchitectAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ste5anSenior DeveloperCommented:
The normal approach would be a full backup of your old server (including the system database). Then restoring them on the new server.

But i'm  not really a fan of this strategy, cause it means to migrate also the bad stuff. Also the maintanence plans need to be reworked, cause under most circumstances things like paths neeed to be adjusted.

For the users: Is using Windows authentication no option?
0
Eprs_AdminSystem ArchitectAuthor Commented:
I know, I always make a full backup of the DB.
But I never migrated the system DBs.

From history a lot of users are created locally in SQL, not windows local user.
How to export the local sql users under SECURITY-LOGINS ?
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
I don't think migrating system databases is a "normal" task. In fact, I think is abnormal task and not recommended.

You may want to migrate jobs and for that you can use SSMS by right-clicking on the job name and chose the option Script Job as (it's possible to select more than one job so you don't need to repeat it for each single job). Or if you have SSIS then it will be very easy to do it with the Transfer Jobs Task.
 
For logins you can use Microsoft's script or once again, use SSIS with the Transfer Logins Task.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Eprs_AdminSystem ArchitectAuthor Commented:
Ok this sounds easy.
But my old SQL server is 2008 and the new one is 2014.
Can I also use TRASFER LOGINS from SQL2008 ?
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Yes, from SQL 2008 to 2014 should work fine. The only login that can't be transferred is sa.
0
Eprs_AdminSystem ArchitectAuthor Commented:
SSIS is not the Management Studio, is it another tool ?
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
SSIS stands for SQL Server Integration Services. You need to run the SQL Server installation media and chose Integration Services in the Features screen.
0
Eprs_AdminSystem ArchitectAuthor Commented:
ok. In this case I will use your first solution, not SSIS.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.