# Copying dremio from 4.6 to 4.7

**URL:** <https://community.dremio.com/t/copying-dremio-from-4-6-to-4-7/6326>\
**Category:** Uncategorized\
**Created:** [September 22, 2020, 7:07pm UTC](https://community.dremio.com/t/copying-dremio-from-4-6-to-4-7/6326 "2020-09-22T19:07:46Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![rajupillai](https://avatars.discourse-cdn.com/v4/letter/r/edb3f5/32.png) [@rajupillai](https://community.dremio.com/u/rajupillai)\
**Post date:** [September 22, 2020, 7:07pm UTC](https://community.dremio.com/t/copying-dremio-from-4-6-to-4-7/6326/1 "2020-09-22T19:07:46Z")

</div>

Is it possible to script out the creation of all the tables in dremio, so it can be replayed in another cluster ?

---

<div class="post-metadata">

**Author:** ![doron](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/doron/32/294_2.png) [@doron](https://community.dremio.com/u/doron)\
**Post date:** [September 23, 2020, 12:53am UTC](https://community.dremio.com/t/copying-dremio-from-4-6-to-4-7/6326/2 "2020-09-23T00:53:01Z")

</div>

You can use our catalog REST API to walk all the sources and spaces and extract the definitions and then use the API to recreate.

---

<div class="post-metadata">

**Author:** ![rajupillai](https://avatars.discourse-cdn.com/v4/letter/r/edb3f5/32.png) [@rajupillai](https://community.dremio.com/u/rajupillai)\
**Post date:** [September 24, 2020, 4:13pm UTC](https://community.dremio.com/t/copying-dremio-from-4-6-to-4-7/6326/3 "2020-09-24T16:13:22Z")

</div>

thanks. I would have been super easy if the backup and restore service could do this. Also when I use the

```auto
GET /api/v3/catalog/{id}. ---> to retrieve the info 

and then use 

POST /api/v3/catalog/{id} -- > to recreate the object 

Am I posting the exact same content from the GET output ?
```

---

<div class="post-metadata">

**Author:** ![doron](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/doron/32/294_2.png) [@doron](https://community.dremio.com/u/doron)\
**Post date:** [September 24, 2020, 4:27pm UTC](https://community.dremio.com/t/copying-dremio-from-4-6-to-4-7/6326/4 "2020-09-24T16:27:04Z")

</div>

You would not use the the ID when you POST to recreate, as the id would be regenerated. You should be able to POST the results of the GET, minus the id parameter.