add pgloader config to migrate from mysql, #39756

[freeside.git] / bin / freeside-mysql.load

diff --git a/bin/freeside-mysql.load b/bin/freeside-mysql.load
new file mode 100644 (file)
index 0000000..02f47da
--- /dev/null
+++ b/bin/freeside-mysql.load
@@ -0,0 +1,6 @@
+LOAD DATABASE
+  FROM mysql://freeside@/freeside
+  INTO postgresql://freeside@/freeside
+WITH include drop, create tables, reset sequences, create indexes
+CAST type varbinary to varchar
+;