Solved

Pervasive database migration/upgrade

Posted on 2014-10-31
2
214 Views
Last Modified: 2014-10-31
Hi

We're having a lot of issues with a couple of our psql servers and are going to upgrade.

Current:  Windows 2003 standard x86, v9.x psql

New:  Windows 2008 standard x64, v11.x psql

Both environments are virtual on vmware ESXi 5.1.  My plan for migration is to shut down the old servers, detach the data drive, and attach it to the new server.

My question is:  Can the new psql just attach this database as is or would it be a better plan to attach the old data drive and a same size new data drive and do some kind of import activity?

Thanks!

Tony
0
Comment
Question by:tonyjoewalker
2 Comments
 
LVL 28

Accepted Solution

by:
Bill Bach earned 500 total points
ID: 40415516
The PSQL environment uses the data files only, and won't care if you just move the data volume to the new server.

However, you may wish to research performance issues due to "disk alignment" problems. Your older volumes from Server 2003 are likely misaligned, and this can slow things down, further hurting performance. For best results, I'd recommend moving the data to a new volume. You may wish to try running Microsoft's SQLIO to test the current volume, as well as a newly-created 2008 volume, and make your decision based on the results.
0
 

Author Closing Comment

by:tonyjoewalker
ID: 40415567
Thank you!  that is exactly what I was looking for!
0

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
A safe way to clean winsxs folder from your windows server 2008 R2 editions
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question