SQLTeam.com | Weblogs | Forums

How im can transfer logins and jobs from sql server 2008 to sql server 2012?


#1

Dear Members

How im can transfer logins and jobs from sql server 2008 to sql server 2012 ?

Thanks
Almir


#2

Hi

One way would be using
SMO objects

Using SMO objects through
PowerShell
or
C#

Please google
if you need any help
please lets chat online

Thanks


#3

SSIS comes with a transfer logins and a transfer jobs task out of the box.


#4

how im can do that ?


#5

Download and install SQL Server Data Tools. Create a new SSIS Project. Add a Transfer Logins task. Select the logins. Configure the connection managers. Right click the task and execute task. Stop Debugging. Add a Transfer Jobs Task. Configure the connection managers. Add Jobs. Right click the task and execute task.


#6

Dear jotorre

I did it the way it worked.

** logins

Go to the Security> Logins menu.
Then on the right side I went into Object Explorer.
Selecte Logins, clicked with the right button and chose the option
"Script login AS> Create To > File" - And I saved the file
Then I opened it on the other dfe database and execute the query
And the logins were restored in SQL 2012

** Jobs

Go to SQL Server Agent> Jobs
Then on the right side I went into Object Explorer.
clicked with the right button > selected the Jobs,and chose the option
"Script Job As > Create To > File" and I saved the file
Then I opened file on Destination database and execute the query
And Jobs were restored in SQL 2012


#7

Awesome Solution


#8

You can follow step by step process to transfer SQL Server Jobs Task and SQL Server Logins Task in SSIS:
https://www.mssqltips.com/sqlservertip/2081/transfer-sql-server-jobs-task-and-transfer-sql-server-logins-task-in-ssis/