on 2019 Oct 14 10:35 AM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
'"DBUNLOAD -up" is your friend' Embarrassing. This is what I get for not reading all the way to the end of the documentation.
Thanks
User | Count |
---|---|
79 | |
11 | |
10 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.