/
n-dimens
/
pgloader
Обзор
Документация
Войти
/
n-dimens
/
pgloader
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
test/parse/AdventureWorks2008R2.load
16 строк
629 B
Dimitri Fontaine
Add a new database source type in the parser.
17 ноя 2014, 02:23
17 ноя 2014, 02:23
87e157b
Код
Авторство
О чём код?
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; $$;