Is it possible to migrate data from MySQL to PostgreSQL through Django dumpdata?











up vote
1
down vote

favorite












I'm trying to convert my database from MySQL to PostgreSQL, and I'm using AWS RDS. I was trying AWS DMS to migrate data, however it didn't work well and was complicated.



While struggling with that, an idea came to mind. What if I use migrate migrations to the new PostgreSQL, and dumpdata from MySQL and loaddata to PostgreSQL? Would that work? Does anyone have experience to migrate database? Am I approaching a right direction?






django django-migrations







share|improve this question






















  • It should work. The data is dumped in an agnostic json format. I do recall small little issues arising auto-incremented fields but your specific problems will surface when you try it out.
    – Victor 'Chris' Cabral
    7 hours ago















up vote
1
down vote

favorite












I'm trying to convert my database from MySQL to PostgreSQL, and I'm using AWS RDS. I was trying AWS DMS to migrate data, however it didn't work well and was complicated.



While struggling with that, an idea came to mind. What if I use migrate migrations to the new PostgreSQL, and dumpdata from MySQL and loaddata to PostgreSQL? Would that work? Does anyone have experience to migrate database? Am I approaching a right direction?






django django-migrations







share|improve this question






















  • It should work. The data is dumped in an agnostic json format. I do recall small little issues arising auto-incremented fields but your specific problems will surface when you try it out.
    – Victor 'Chris' Cabral
    7 hours ago













up vote
1
down vote

favorite









up vote
1
down vote

favorite











I'm trying to convert my database from MySQL to PostgreSQL, and I'm using AWS RDS. I was trying AWS DMS to migrate data, however it didn't work well and was complicated.



While struggling with that, an idea came to mind. What if I use migrate migrations to the new PostgreSQL, and dumpdata from MySQL and loaddata to PostgreSQL? Would that work? Does anyone have experience to migrate database? Am I approaching a right direction?






django django-migrations







share|improve this question













I'm trying to convert my database from MySQL to PostgreSQL, and I'm using AWS RDS. I was trying AWS DMS to migrate data, however it didn't work well and was complicated.



While struggling with that, an idea came to mind. What if I use migrate migrations to the new PostgreSQL, and dumpdata from MySQL and loaddata to PostgreSQL? Would that work? Does anyone have experience to migrate database? Am I approaching a right direction?






django django-migrations




django django-migrations






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked 8 hours ago









Jay

390111




390111












  • It should work. The data is dumped in an agnostic json format. I do recall small little issues arising auto-incremented fields but your specific problems will surface when you try it out.
    – Victor 'Chris' Cabral
    7 hours ago


















  • It should work. The data is dumped in an agnostic json format. I do recall small little issues arising auto-incremented fields but your specific problems will surface when you try it out.
    – Victor 'Chris' Cabral
    7 hours ago
















It should work. The data is dumped in an agnostic json format. I do recall small little issues arising auto-incremented fields but your specific problems will surface when you try it out.
– Victor 'Chris' Cabral
7 hours ago




It should work. The data is dumped in an agnostic json format. I do recall small little issues arising auto-incremented fields but your specific problems will surface when you try it out.
– Victor 'Chris' Cabral
7 hours ago












1 Answer
1






active

oldest

votes

















up vote
0
down vote













I've done this in the past and it has worked, but with some bumps in the road. Be sure your database is frozen - you might want to put users with access into read-only mode.



Good luck.






share|improve this answer





















  • Do you remember what kind of bumps you had? I just finished manage.py loaddata and it seems to be working very well for now. Like you advised, I'm gonna freeze MySQL database for a while, and then delete it when I'm sure everything is okay.
    – Jay
    4 hours ago











Your Answer






StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});














 

draft saved


draft discarded


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53399818%2fis-it-possible-to-migrate-data-from-mysql-to-postgresql-through-django-dumpdata%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown

























1 Answer
1






active

oldest

votes








1 Answer
1






active

oldest

votes









active

oldest

votes






active

oldest

votes








up vote
0
down vote













I've done this in the past and it has worked, but with some bumps in the road. Be sure your database is frozen - you might want to put users with access into read-only mode.



Good luck.






share|improve this answer





















  • Do you remember what kind of bumps you had? I just finished manage.py loaddata and it seems to be working very well for now. Like you advised, I'm gonna freeze MySQL database for a while, and then delete it when I'm sure everything is okay.
    – Jay
    4 hours ago















up vote
0
down vote













I've done this in the past and it has worked, but with some bumps in the road. Be sure your database is frozen - you might want to put users with access into read-only mode.



Good luck.






share|improve this answer





















  • Do you remember what kind of bumps you had? I just finished manage.py loaddata and it seems to be working very well for now. Like you advised, I'm gonna freeze MySQL database for a while, and then delete it when I'm sure everything is okay.
    – Jay
    4 hours ago













up vote
0
down vote










up vote
0
down vote









I've done this in the past and it has worked, but with some bumps in the road. Be sure your database is frozen - you might want to put users with access into read-only mode.



Good luck.






share|improve this answer












I've done this in the past and it has worked, but with some bumps in the road. Be sure your database is frozen - you might want to put users with access into read-only mode.



Good luck.







share|improve this answer












share|improve this answer



share|improve this answer










answered 7 hours ago









FlipperPA

6,69922043




6,69922043












  • Do you remember what kind of bumps you had? I just finished manage.py loaddata and it seems to be working very well for now. Like you advised, I'm gonna freeze MySQL database for a while, and then delete it when I'm sure everything is okay.
    – Jay
    4 hours ago


















  • Do you remember what kind of bumps you had? I just finished manage.py loaddata and it seems to be working very well for now. Like you advised, I'm gonna freeze MySQL database for a while, and then delete it when I'm sure everything is okay.
    – Jay
    4 hours ago
















Do you remember what kind of bumps you had? I just finished manage.py loaddata and it seems to be working very well for now. Like you advised, I'm gonna freeze MySQL database for a while, and then delete it when I'm sure everything is okay.
– Jay
4 hours ago




Do you remember what kind of bumps you had? I just finished manage.py loaddata and it seems to be working very well for now. Like you advised, I'm gonna freeze MySQL database for a while, and then delete it when I'm sure everything is okay.
– Jay
4 hours ago


















 

draft saved


draft discarded



















































 


draft saved


draft discarded














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53399818%2fis-it-possible-to-migrate-data-from-mysql-to-postgresql-through-django-dumpdata%23new-answer', 'question_page');
}
);

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







-

Popular posts from this blog

Berounka

Image
Berounka.mw-parser-output .entete.map{background-image:url("//upload.wikimedia.org/wikipedia/commons/7/7a/Picto_infobox_map.png")} Caractéristiques Longueur 139  km Bassin 8 861  km 2 Bassin collecteur Elbe Débit moyen ? Cours Source Confluence de la Mže et de la Radbuza · Localisation Pilsen · Altitude 305  m · Coordonnées 49° 45′ 13″ N, 13° 23′ 24″ E Confluence Vltava · Localisation Prague · Altitude 187  m · Coordonnées 49° 59′ 43″ N, 14° 24′ 04″ E Géographie Pays traversés   République tchèque modifier   La Berounka est une rivière de la République tchèque. Elle porte le nom de Mže depuis sa source en Allemagne près de la frontière jusqu'à sa confluence avec la Radbuza à Plzeň. Elle continue ensuite sous le nom de Berounka jusqu'à sa confluence avec la Vltava, près de Prague. La rivière est une destination prisée pour les amateurs de canoë, qui appréc...
Read more

Sphinx de Gizeh

Image
Pour les articles homonymes, voir Sphinx. Sphinx de Gizeh.mw-parser-output .entete.egypte-antique{background-image:url("//upload.wikimedia.org/wikipedia/commons/c/cc/Picto_infobox_ancient_Egypt.png")} Site d'Égypte antique Le visage du sphinx de Gizeh. Noms en arabe أبو الهول , Abou al-Hôl Localisation Région Basse-Égypte Coordonnées 29° 58′ 31″ nord, 31° 08′ 16″ est Géolocalisation sur la carte : Égypte Sphinx de Gizeh modifier   Le sphinx de Gizeh est la statue thérianthrope qui se dresse devant les grandes pyramides du plateau de Gizeh, en Basse-Égypte. Sculpture monumentale monolithique la plus grande du monde [ 1 ] avec 73,5 mètres de longueur, 14 mètres de largeur et 20,22 mètres de hauteur, elle représente un sphinx couchant. Réalisée vers -2500, elle serait attribuée à Djédefrê, l'un des pharaons de la IV e  dynastie, représentant son père le pharaon Khéops. Sommaire 1 Étymologie 2 Desc...
Read more

Different font size/position of beamer's navigation symbols template's content depending on regular/plain...

Image
3 Let's suppose I'd like to divert the navigation symbols template (e.g. in order replace them by the frame numbers, see this bug report ;) I would be facing troubles regarding the font size/position, depending on regular/plain frames, as shown by the following MCE. How could I get rid of these troubles? documentclass{beamer} usetheme{PaloAlto} setbeamertemplate{navigation symbols}{insertframenumber/inserttotalframenumber} begin{document} begin{frame} frametitle{A regular frame} end{frame} begin{frame}[plain] frametitle{A plain frame} end{frame} end{document} beamer header-footer share | improve this question asked Dec 10 '18 a...
Read more