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

** 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

 

Thanks,

Sheikvara

+91-9840688822

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s