summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMark Wells <mark@freeside.biz>2016-03-20 16:41:14 -0700
committerMark Wells <mark@freeside.biz>2016-03-20 16:42:23 -0700
commit4c20bb23330aff5df05a211762106ec50402f7c7 (patch)
tree04306b1dbd51ce68153cdfccf50c1e082816c0e2
parent14d83a8b09462027016c0ea3511b8d54b1f2519a (diff)
add pgloader config to migrate from mysql, #39756
-rw-r--r--bin/freeside-mysql.load6
1 files changed, 6 insertions, 0 deletions
diff --git a/bin/freeside-mysql.load b/bin/freeside-mysql.load
new file mode 100644
index 000000000..02f47daf3
--- /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
+;