How to copy data from one branch to another. dev > main

[dominic-vie]

I just imported a large dataset into the dev branch of about 100k records. I want to copy the data from dev to prod after I merge the schemas. How do I do that.

I know merging the schemas has nothing to do with the data so I am trying to avoid having to reimport the dataset in production.

[orware]

Hello @dominic-vie,

I believe you received a reply already from your question in Discord, but for a more detailed example something along the lines of what is described in this discussion should be similar to what you would need to do:
#476 (comment)

The one extra tip that might be helpful to note is that for the pscale database restore-dump step it might be required to use the optional --overwrite-tables flag when overwriting the existing tables/data within your prod branch:
https://planetscale.com/docs/reference/database

I hope this is helpful!

[dominic-vie]

Thanks for your help and patience

…

On Tue, Jan 16, 2024 at 1:46 PM Omar Ramos ***@***.***> wrote: Hello @dominic-vie <https://github.com/dominic-vie>, I believe you received a reply already from your question in Discord, but for a more detailed example something along the lines of what is described in this discussion should be similar to what you would need to do: #476 (comment) <#476 (comment)> The one extra tip that might be helpful to note is that for the pscale database restore-dump step it might be required to use the optional --overwrite-tables flag when overwriting the existing tables/data within your prod branch: https://planetscale.com/docs/reference/database I hope this is helpful! — Reply to this email directly, view it on GitHub <#594 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/A7OXUGR4SLT4BUKY7HXNQ23YO3DKFAVCNFSM6AAAAABB5CAUIOVHI2DSMVQWIX3LMV43SRDJONRXK43TNFXW4Q3PNVWWK3TUHM4DCNBYGEYTG> . You are receiving this because you were mentioned.Message ID: ***@***.***>