Upgrade to SQL 2017 new server- how to copy over logins & Jobs during upgrade

• Jeff Moden

  SSC Guru

  Points: 1003869

  More actions

  November 12, 2019 at 1:41 pm

  #3697020

  andreas.kreuzberg wrote:

  Hi,

  just take a look to dbatools.io.

  With a few commands you are able to copy database, jobs and logins from server a to server b.

  It is realy simple.

  Kind regards,

  Andreas

  If you're going to post something like that, it would be real handy to others if you posted the URL where they can get the tool(s).  Yep... I know.  Easy to find but it also helps people make sure they've got the right stuff.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• jennrani0804

  Grasshopper

  Points: 14

  More actions

  November 19, 2019 at 4:35 am

  #3698721

  This reply has been reported for inappropriate content.

  [

  geek squad appointment |

  best buy geek squad appointment |

  geek squad appointment scheduling |

  schedule a geek squad appointment online |

  schedule geek squad appointment |

  geek squad in home appointment