Flask-SQLAlchemy - Transfer / Import Data From SQLite to MySQL
up vote
0
down vote
favorite
I am relatively new in database system design. I need to build a tool using Flask-SQLAlchemy which accepts relatively smaller SQLite databases (intermediate DBs) as its input and stores the data into a MySQL database (central DB / master record).
My questions are:
- What is the most efficient (and possibly performant) programmatic way to achieve this goal? What libraries / extensions do I need to use?
- I did some research and found some suggestions to convert the intermediate DBs to other format first, e.g. CSV, XML, before inserting the data to the central DB. Do I need to perform this conversion?
Few notes:
- I have the schema for the central DB already defined using Flask-SQLAlchemy ORM.
- The schemas of intermediate DB and central DB are not one-to-one. However, the columns in intermediate DB can be seen as the subset of the columns in the central DB.
mysql sqlite flask sqlalchemy flask-sqlalchemy
asked Nov 21 at 7:15
Sam Tatasurya
119110
add a comment |
up vote
0
down vote
favorite
I am relatively new in database system design. I need to build a tool using Flask-SQLAlchemy which accepts relatively smaller SQLite databases (intermediate DBs) as its input and stores the data into a MySQL database (central DB / master record).
My questions are:
- What is the most efficient (and possibly performant) programmatic way to achieve this goal? What libraries / extensions do I need to use?
- I did some research and found some suggestions to convert the intermediate DBs to other format first, e.g. CSV, XML, before inserting the data to the central DB. Do I need to perform this conversion?
Few notes:
- I have the schema for the central DB already defined using Flask-SQLAlchemy ORM.
- The schemas of intermediate DB and central DB are not one-to-one. However, the columns in intermediate DB can be seen as the subset of the columns in the central DB.
mysql sqlite flask sqlalchemy flask-sqlalchemy
asked Nov 21 at 7:15
Sam Tatasurya
119110
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I am relatively new in database system design. I need to build a tool using Flask-SQLAlchemy which accepts relatively smaller SQLite databases (intermediate DBs) as its input and stores the data into a MySQL database (central DB / master record).
My questions are:
- What is the most efficient (and possibly performant) programmatic way to achieve this goal? What libraries / extensions do I need to use?
- I did some research and found some suggestions to convert the intermediate DBs to other format first, e.g. CSV, XML, before inserting the data to the central DB. Do I need to perform this conversion?
Few notes:
- I have the schema for the central DB already defined using Flask-SQLAlchemy ORM.
- The schemas of intermediate DB and central DB are not one-to-one. However, the columns in intermediate DB can be seen as the subset of the columns in the central DB.
mysql sqlite flask sqlalchemy flask-sqlalchemy
asked Nov 21 at 7:15
Sam Tatasurya
119110
I am relatively new in database system design. I need to build a tool using Flask-SQLAlchemy which accepts relatively smaller SQLite databases (intermediate DBs) as its input and stores the data into a MySQL database (central DB / master record).
My questions are:
- What is the most efficient (and possibly performant) programmatic way to achieve this goal? What libraries / extensions do I need to use?
- I did some research and found some suggestions to convert the intermediate DBs to other format first, e.g. CSV, XML, before inserting the data to the central DB. Do I need to perform this conversion?
Few notes:
- I have the schema for the central DB already defined using Flask-SQLAlchemy ORM.
- The schemas of intermediate DB and central DB are not one-to-one. However, the columns in intermediate DB can be seen as the subset of the columns in the central DB.
mysql sqlite flask sqlalchemy flask-sqlalchemy
mysql sqlite flask sqlalchemy flask-sqlalchemy
asked Nov 21 at 7:15
Sam Tatasurya
119110
asked Nov 21 at 7:15
Sam Tatasurya
119110
asked Nov 21 at 7:15
Sam Tatasurya
119110
asked Nov 21 at 7:15
Sam Tatasurya
119110
asked Nov 21 at 7:15
Sam Tatasurya
119110
119110
add a comment |
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53406981%2fflask-sqlalchemy-transfer-import-data-from-sqlite-to-mysql%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
