Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add an easy way to migrate from sqlite to mysql and vice versa. #360

Open
JVT038 opened this issue May 20, 2023 · 2 comments
Open

Add an easy way to migrate from sqlite to mysql and vice versa. #360

JVT038 opened this issue May 20, 2023 · 2 comments
Labels
enhancement New feature or request

Comments

@JVT038
Copy link
Collaborator

JVT038 commented May 20, 2023

No description provided.

@JVT038 JVT038 added the enhancement New feature or request label May 20, 2023
@leepeuker
Copy link
Owner

I am not 100% sure what you mean. A way to migrate the existing data from one db type to the other?

@JVT038
Copy link
Collaborator Author

JVT038 commented May 21, 2023

Yeah.
So that users can switch from sqlite to mysql and from mysql to sqlite.
This is in case tables have become very big (more than 100k rows) and they have to switch from sqlite to mysql.
Or in case of something else and they want to switch from mysql to sqlite.

So we would need to make a script that can easily fetch all the tables, get the rows and create the same tables in the other database and then insert the rows from the old database into the new database.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants