# Duplicating a database **URL:** \ **Category:** Get Help\ **Created:** [April 5, 2022, 9:28pm UTC](https://community.fibery.io/t/duplicating-a-database/2690 "2022-04-05T21:28:11Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![xavier](https://avatars.discourse-cdn.com/v4/letter/x/2bfe46/32.png) [@xavier](https://community.fibery.io/u/xavier)\ **Post date:** [April 5, 2022, 9:28pm UTC](https://community.fibery.io/t/duplicating-a-database/2690/1 "2022-04-05T21:28:11Z")
Is there a way to duplicate a database? I created a database and want to create another one (different data) but don’t want to create it from scratch. ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [April 5, 2022, 11:01pm UTC](https://community.fibery.io/t/duplicating-a-database/2690/2 "2022-04-05T23:01:46Z")
Duplicate the space containing the db (i.e. share as template, rename original, import shared template) and then delete any databases in the space you don’t need 🙂 ---
**Author:** ![xavier](https://avatars.discourse-cdn.com/v4/letter/x/2bfe46/32.png) [@xavier](https://community.fibery.io/u/xavier)\ **Post date:** [April 6, 2022, 4:30am UTC](https://community.fibery.io/t/duplicating-a-database/2690/3 "2022-04-06T04:30:49Z")
I get this error. In the case below I’m trying to create another “bug” database named something else. Currently, nothing is named “bug”. I’m assuming this is the initial name of the database? Cannot rename database ‘Development/Priority\_Software Development/bug’ database cannot be renamed to ‘Development2/Priority\_Software Development/bug’ database because ‘Development2/Priority\_Software Development/bug’ database already exists. ---
**Author:** ![xavier](https://avatars.discourse-cdn.com/v4/letter/x/2bfe46/32.png) [@xavier](https://community.fibery.io/u/xavier)\ **Post date:** [April 6, 2022, 4:50am UTC](https://community.fibery.io/t/duplicating-a-database/2690/4 "2022-04-06T04:50:24Z")
Yeah, seems like there is some sort of internal/initial name in the database. Even when renamed it keeps the initial name. ‘Development/Priority\_Development/Database 1’ database cannot be renamed to ‘Development2/Priority\_Development/Database 1’ database because ‘Development2/Priority\_Development/Database 1’ database already exists. ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [April 6, 2022, 8:05am UTC](https://community.fibery.io/t/duplicating-a-database/2690/5 "2022-04-06T08:05:33Z")
What were you doing exactly when you got this message? ---
**Author:** ![xavier](https://avatars.discourse-cdn.com/v4/letter/x/2bfe46/32.png) [@xavier](https://community.fibery.io/u/xavier)\ **Post date:** [April 12, 2022, 3:48am UTC](https://community.fibery.io/t/duplicating-a-database/2690/6 "2022-04-12T03:48:43Z")
Here is an example. 1. Install Software Development Template 2. Rename space to “Software Development Template 1” 3. Rename “Bug” database to “Bug1” 4. Install Software Development Template 5. Move “Bug” database to space “Software Development Template 1” Cannot rename database ‘Software Development/Priority\_Software Development/bug’ database cannot be renamed to ‘Software Development 1/Priority\_Software Development/bug’ database because ‘Software Development 1/Priority\_Software Development/bug’ database already exists. ---
**Author:** ![schorsch](https://avatars.discourse-cdn.com/v4/letter/s/e0b2c6/32.png) [@schorsch](https://community.fibery.io/u/schorsch)\ **Post date:** [August 12, 2023, 10:51am UTC](https://community.fibery.io/t/duplicating-a-database/2690/7 "2023-08-12T10:51:04Z")
I’ve been trying to use templates as a workaround to “duplicate” databases as well: however the internal name/id prevents this from being done. as a safeguard it makes sense however I’m now stuck without a simple way to create “subtasks” for my existing and numerous projects and tasks… unless I rebuild all formulas and fields from “tasks” to a fresh/new “subtasks” db manually. ☹ Cannot rename database ‘PROJEKTE PROJECTX DB-DUPLICATOR/Typ\_PROJEKTE PROJECTX/Task’ database cannot be renamed to ‘PROJEKTE PROJECTX/Typ\_PROJEKTE PROJECTX/Task’ database because ‘PROJEKTE PROJECTX/Typ\_PROJEKTE PROJECTX/Task’ database already exists. ---
**Author:** ![schorsch](https://avatars.discourse-cdn.com/v4/letter/s/e0b2c6/32.png) [@schorsch](https://community.fibery.io/u/schorsch)\ **Post date:** [August 12, 2023, 10:54am UTC](https://community.fibery.io/t/duplicating-a-database/2690/8 "2023-08-12T10:54:28Z")
the issue occurs when trying to “move” the duplicated template/DB BACK to the original, intended target-workspace… even after renaming the duplicated-workspace-db… even after removing all relationships except for “USER”. obviously just “duplicating” a db for the sake of duplicating or using it exclusively in another, separate workspace is not much use. ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [August 13, 2023, 10:18pm UTC](https://community.fibery.io/t/duplicating-a-database/2690/9 "2023-08-13T22:18:34Z")
> [@schorsch](#): > > I’m now stuck without a simple way to create “subtasks” for my existing and numerous projects and tasks… unless I rebuild all formulas and fields from “tasks” to a fresh/new “subtasks” db manually It sounds like you might be wise to use a self-relation for the Task database, rather than creating another database with (almost) the same characteristics. ---
**Author:** ![schorsch](https://avatars.discourse-cdn.com/v4/letter/s/e0b2c6/32.png) [@schorsch](https://community.fibery.io/u/schorsch)\ **Post date:** [August 14, 2023, 5:05am UTC](https://community.fibery.io/t/duplicating-a-database/2690/10 "2023-08-14T05:05:59Z")
our current workaround is to use adjusted views/smartfolders from project-tasks and a duplicated/templated and hidden workspace, i.e. it’s needed db for the subtasks. adding new subtasks has to be circumvented in a separate table view, as nested levels view in a list (task ► subtasks) only allows addition of top-level objects, i.e. tasks, but not subtasks. it’s workable so far and can quickly be nested down further levels if need be imo, but not yet tested for subtasks lvl2, lvl3 etc. as we really don’t need this depth. I have not used self-relations at all yet: how would one go about handling “tasks → subtaskslvl1 → subtaskslvl2” when using self-relations. can they be nested at all? what would naming/handling and accessing nested subtasks roughly look like? self-relation can therefore be “one to many” too? ---
**Author:** ![schorsch](https://avatars.discourse-cdn.com/v4/letter/s/e0b2c6/32.png) [@schorsch](https://community.fibery.io/u/schorsch)\ **Post date:** [August 14, 2023, 5:28am UTC](https://community.fibery.io/t/duplicating-a-database/2690/11 "2023-08-14T05:28:04Z")
not sure if this is the way you suggest but I tried duplicating another template/workspace to test your suggestion: I created a one to many relation from “tasks” or “subtasks” to itself: however this kind of reference cannot be used in list level/nested views etc. unless I am doing things wrong here. currently list/nested and probably most/all views cannot be referenced to relations directed to “self”… so it seems quite a bit more limited for tasks-\>subtasks than the workaround we are currently using: ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/a/a954b908f9f03d045c3b99cbc20ffee8b99db81e.png) ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/3/3ae9a70892ebb6e6ff4180c7f50df58ee24e9ef9.png) so far it works quite nicely to edit data in “both” directions. as well as autopopulation/updating of existing assignees from tasks. or notification/differentiation on change/update of data for subtasks discernably as well. ---
**Author:** ![Seven](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/seven/32/7595_2.png) [@Seven](https://community.fibery.io/u/Seven)\ **Post date:** [September 8, 2023, 12:15pm UTC](https://community.fibery.io/t/duplicating-a-database/2690/12 "2023-09-08T12:15:40Z")
How to import shared template ? Only thing I found is “Add custom app” under “Select source to import data”, but when using a share as template link it just says “Version is required” ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/d/df0fd11ea2bd48b4c29c2cb58098c7fed7e289f7.png) ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/e/e535c940c675975cc4a015329ff97e97e78d5a4e.png) ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [September 8, 2023, 12:21pm UTC](https://community.fibery.io/t/duplicating-a-database/2690/13 "2023-09-08T12:21:24Z")
Assuming you have the URL of a Fibery space template, you just paste it into your browser address bar and then you get to choose the workspace you wish to import it into.