How to copy and paste a db?

jkurz

New Member
We are trying to move a progress db to a new server without carrying over any of it security properties. My question is:


Is there anyway to "Copy and Paste" a db from one server to another without carrying over changed security settings, changing it back to default settings.

Thanks for everyones input!

-Jon
 

tamhas

ProgressTalk.com Sponsor
You could use procopy if the drive of one is mounted on the other, but otherwise I would do a binary dump and load or a regular dump and load if it isn't too large. That will give you complete control over the destination.
 

TomBascom

Curmudgeon
When you say "security properties" do you mean things like OS level file and directory permissions? Or do you mean user permissions to tables, fields and such within the db?

To copy a database without the latter you need to dump it, recreate it and then load it while skipping the security related bits. (You will need read permissions on the source db).

If you are just concerned about the os level security then you can use procopy or probkup/prorest.

Using OS tools to copy a db is not a good idea. There are several internal pointers to the bits and pieces of the db that need to be updated when you do this as well as consistency checks regarding timestamps and so forth. If you make even a small mistake it is very easy to have an unusable collection of bytes on disk.
 
Top