Knowing that everyone's experience may be a bit different, I'm asking for advice on the best way to migrate my v16 database to v17. My v17 software is on a shiny new windows 2016 VM, and the database in question is about 50GB. The textbook answer seems to be to copy the database to the new server, open it in v17, then do an unload/reload. I tried that over the weekend, using the command line DBUNLOAD. No errors, but in the reload.sql file that was created, all the users (including DBA) had a blank password.

One option might be to do an unload on the v16 server, copy the data files over, then re-load on the v17 machine (drive letters are all the same). Not sure if there's an advantage to that, though.

asked 14 Oct, 09:35

Bud%20Durland%20MRP's gravatar image

Bud Durland MRP
1514615
accept rate: 50%

edited 14 Oct, 11:11

Volker%20Barth's gravatar image

Volker Barth
34.6k337491729


No errors, but in the reload.sql file that was created, all the users (including DBA) had a blank password.

If that is a problem "DBUNLOAD -up" is your friend - or the dbunload variants that do an automatic reload like -ac, -an, -ar...:)

That being said, I would always recommend to use the new version's DBUNLOAD if feasible to do the unload, not that of the old version.

permanent link

answered 14 Oct, 10:33

Volker%20Barth's gravatar image

Volker Barth
34.6k337491729
accept rate: 33%

converted 14 Oct, 16:17

1

'"DBUNLOAD -up" is your friend' Embarrassing. This is what I get for not reading all the way to the end of the documentation.

Thanks

(14 Oct, 13:50) Bud Durland MRP
Your answer
toggle preview

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "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

Question tags:

×143
×59
×51

question asked: 14 Oct, 09:35

question was seen: 133 times

last updated: 14 Oct, 13:50