pgloader/test/parse/AdventureWorks2008R2.load
Dimitri Fontaine 87e157bee2 Add a new database source type in the parser.
Now it's possible to parse a command to load data from MS SQL. The
parser was until now parsing all database URI within the same common
rule and that isn't possible anymore if we want to distinguish in
between source database right from the parser, which we actually want to
do.

This patch also implement in-passing fixes all over the place, including
the transformation function float-to-string that only happened to work
on double-float data.
2014-11-17 00:23:06 +01:00

17 lines
629 B
Fish

load database
from mssql://dim:pass@localhost/AdventureWorks2008R2
into postgresql:///advworks
-- WITH include drop, create tables, no truncate,
-- create indexes, reset sequences, foreign keys
SET maintenance_work_mem to '128MB', work_mem to '12MB'
BEFORE LOAD DO
$$ drop schema if exists humanresources cascade; $$,
$$ drop schema if exists person cascade; $$,
$$ drop schema if exists production cascade; $$,
$$ drop schema if exists public cascade; $$,
$$ drop schema if exists purchasing cascade; $$,
$$ drop schema if exists sales cascade; $$;