Blackmagic Forum

We would like to move all our projects from the local disk databases to PostgreSQL.

The only way I found for now is to

• manually export .drp files one project at a time,
• switch to postgresql,
• import the .drp files one at a time.

When multiple projects are selected, Export and Export with Stills are greyed out.

And backups as .resolve.diskdb files can only be restored to disk, not to PostgreSQL. (I suspect that Backup/restore is really just a fancy way of zipping/unzipping the Disk Database folder).

We have now moved to v. 14, and the old 12.5 projects in .xml files seem to be converted to a sqlite database when saved. Could it be possible to write a script which reads the data in the Project.db sqlite file, and copies it to Postgresql? Are both using the same database structure?

I have this question too.

Albert Hofmann wrote:We would like to move all our projects from the local disk databases to PostgreSQL.

It's not very intuitive, but here's how it can be done:

1) move over to the specific local disk database you need to access.

2) highlight all the projects in the Project window. Copy to clipboard (⌘C on Mac, ^C on Windows)

3) move over to the specific PosgreSQL database you want to use.

4) Paste from clipboard (⌘P on Mac, ^P on Windows).

It takes some time, but eventually all the projects will be copied over to the new database. I have found in some cases if you have folders-within-folders, you may need to copy them from the actual projects and not just the folders. It's a little unpredictable, but it can work.

Thanks, Marc!

Thank you Marc for the answer.

This is exactly (unintuitive) the reason why I sometimes have my hairs pulled with DR.

You are the reason I still have some hairs

Thank you Marc!

Marc Wielage wrote:

Albert Hofmann wrote:We would like to move all our projects from the local disk databases to PostgreSQL.

It's not very intuitive, but here's how it can be done:

1) move over to the specific local disk database you need to access.

2) highlight all the projects in the Project window. Copy to clipboard (⌘C on Mac, ^C on Windows)

3) move over to the specific PosgreSQL database you want to use.

4) Paste from clipboard (⌘P on Mac, ^P on Windows).

It takes some time, but eventually all the projects will be copied over to the new database. I have found in some cases if you have folders-within-folders, you may need to copy them from the actual projects and not just the folders. It's a little unpredictable, but it can work.

Thank you Marc!

Same here , couldn't figure it without it.