We're migrating our server from SQL 2008 to SQL 2016 and we have a PA 6.2 database there.. how can we migrate it to another server?

Thanks a lot!

This question is marked "community wiki".

asked 16 Aug '17, 20:57

BCBCGA's gravatar image

accept rate: 0%

I'd recommend using whatever procedure is suggested by SQL Server to move databases between them, and then go into Database Settings and point at the new database.

In the past I have disconnected a database from one server, moved the database files to the new server, and then attached those files to the new server. I've not done that with SQL 2016, and I'm not sure if you can move them directly from 2008 to 2016, but it was a very fast and easy way to move databases between servers when the servers are the same version.


answered 03 Oct '17, 11:45

Doug's gravatar image

Doug ♦♦
accept rate: 21%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: 16 Aug '17, 20:57

Seen: 2,958 times

Last updated: 03 Oct '17, 11:45