Dear Members
How im can transfer logins and jobs from sql server 2008 to sql server 2012 ?
Thanks
Almir
Dear Members
How im can transfer logins and jobs from sql server 2008 to sql server 2012 ?
Thanks
Almir
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
SSIS comes with a transfer logins and a transfer jobs task out of the box.
how im can do that ?
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.
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
Awesome Solution
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/