Duplicating databases

Would be nice to be able to duplicate a database with a simple click, maybe listed under “Move database to another space” instead of using the workaround described here.

With or without the data?
What’s the underlying need?

Without the data in my use case. I want to use the existing database as a template for a new database.

1 Like

Is that because the new database needs to have a lot of the same fields?
How similar are they? If a lot, then perhaps you don’t need two dbs, just one db with suitable filtered views…

Fair enough. I think you’re probably right that in most cases, if you need most of the same fields, you should probably just do a filtered view of the existing db. I’ll update this thread if I come across a more compelling use case for this/if others have their own compelling use cases

Hi @ChrisG, wondering if you have a solution for me. I have a use case for duplicating DBs.
I need the following:

Quote
Quote Line Item

Purchase order
Purchase Order Line Item

Bill
Bill Line Item

I’ve created the Bill and bill line Item DBs and want to duplicate for quotes and POs.

These items have a lot of detail and relations (tax code, chart of account, supplier info ect)

I suppose I need to manually recreated everything twice? Would this be a use case for DB duplication?

Thanks!

It’s not pretty, but the easiest way to clone databases in a workspace is as follows:

Share the Space that contains the databases as a template.
Copy the sharing link to the clipboard.
Rename the space to something random (e.g. just add an X to the space name)
Paste the sharing link into the browser and choose to import into the source workspace.
Now you will have two spaces (the original, now named BlahX and the new one, named Blah).

Of course, my natural question would be why you want to have the same db twice within a workspace?

1 Like

Migrating a single database that is currently tied to an integration to a database that is not.
In my experience, removing a single database from the sync does not actually turn the database into a normal one.

Hmm, why do you think this is the case? If you disable sync you should have perfectly normal database

Earlier this week I tested removing the connection between Hubspot and my Sales Tasks database.
The integration no longer let me configure the fields to sync but all the fields stayed locked/formula fields.

@Chr1sG or @mdubakov is this expected/desired behavior?
I’m actively looking to move one of my most important integration databases to a Fibery native database and will halt manual recreation if this is a bug that will be fixed.

If you want to turn integration dbs into native dbs, you should choose ‘Disconnect and Migrate’. At this point, there should be no integration configuration options.
Is that what you have done?

No, is it possible to disconnect only one database when choosing to disconnect and migrate?
I’ve used that option in the past to completely disconnect all databases from the integration but it has been over 6 months.
In my case, I only want to disconnect one database and not the rest.

That isn’t currently possible, I’m afraid

1 Like

Thanks. Will move forward with recreating then.