Here is the script to migrate the full database using nz_migrate utility
pre -request.
This will create the new database and there should not be DB available on target side with same name.
it will be helpful to migrate the UDF and it will ask you to enter the target OS user password to scp the files/ddl from source to target
nz_migrate -shost <source_server_name> -thost <target_server_name> -sdb <source_db_name> -tdb <target_db_name> -CreateTargetDatabase yes -table <tablename> -CreateTargetUDX YES -tuser admin -tpassword 'password' -CreateTargetTable yes -TruncateTargetTable False -format binary -threads 4
=======================================================================================
nz_migrate started on 2018-03-22 15:57:48
Migrating <sourcer_server_name>:"source_DB_name". --> <target_server_name>:"source_DB_name_NEW".
Data Format : binary
Log Directory : /tmp/nz_migrate.20180322_155615.28562
Log File : /tmp/nz_migrate.20180322_155615.28562/nz_migrate.output
Initiated From: SOURCE host
Top Level PID : 28562
SOURCE Version: 7.0 # of Dataslices: 46 Unloaded Via: nzsql
TARGET Version: 7.0 # of Dataslices: 184 Loaded Via: nzload
script version: 7.1
=======================================================================================
nz_migrate table 'Table_name'
.....processing table 1 of 1
.....migration process started at 2018-03-22 15:57:48
.....estimated # of records 165,915
.....nzload starting ( thread 1 of 6 )
.....nzload starting ( thread 2 of 6 )
.....nzload starting ( thread 3 of 6 )
.....nzload starting ( thread 4 of 6 )
.....nzload starting ( thread 5 of 6 )
.....nzload starting ( thread 6 of 6 )
.....unloading data ( thread 1 of 6 )
.....unloading data ( thread 2 of 6 )
.....unloading data ( thread 3 of 6 )
.....unloading data ( thread 4 of 6 )
.....unloading data ( thread 5 of 6 )
.....unloading data ( thread 6 of 6 )
.....data flowing.....
.....unload results ( thread 3 of 6 ) INSERT 0 28965
.....unload finished ( thread 3 of 6 ) elapsed seconds: 1
.....unload results ( thread 2 of 6 ) INSERT 0 28825
.....unload finished ( thread 2 of 6 ) elapsed seconds: 1
.....unload results ( thread 1 of 6 ) INSERT 0 28572
.....unload finished ( thread 1 of 6 ) elapsed seconds: 1
.....unload results ( thread 6 of 6 ) INSERT 0 25393
.....unload finished ( thread 6 of 6 ) elapsed seconds: 1
.....unload results ( thread 4 of 6 ) INSERT 0 29011
.....unload finished ( thread 4 of 6 ) elapsed seconds: 1
.....unload results ( thread 5 of 6 ) INSERT 0 25149
.....unload finished ( thread 5 of 6 ) elapsed seconds: 1
.....nzload finished ( thread 3 of 6 ) elapsed seconds: 6
.....nzload successful ( thread 3 of 6 )
.....nzload finished ( thread 2 of 6 ) elapsed seconds: 6
.....nzload successful ( thread 2 of 6 )
.....nzload finished ( thread 1 of 6 ) elapsed seconds: 6
.....nzload finished ( thread 6 of 6 ) elapsed seconds: 6
.....nzload successful ( thread 1 of 6 )
.....nzload successful ( thread 6 of 6 )
.....nzload finished ( thread 4 of 6 ) elapsed seconds: 6
.....nzload successful ( thread 4 of 6 )
.....nzload finished ( thread 5 of 6 ) elapsed seconds: 6
.....nzload successful ( thread 5 of 6 )
.....migration process ended at 2018-03-22 15:57:54
.....data flow finished
.....actual # of records unloaded 165,915
.....
.....migration completed TOTAL seconds: 6
.....
.....cksum process started at 2018-03-22 15:57:54
.....cksum process ended at 2018-03-22 15:57:54
.....confirmed cksum: 0.0 165915 Table_name
.....
.....cksum completed TOTAL seconds: 0
=======================================================================================
nz_migrate finished on 2018-03-22 15:57:54
Migrating <sourcer_server_name>:"source_DB_name". --> <target_server_name>:"source_DB_name_NEW".
Data Format : binary
Log Directory : /tmp/nz_migrate.20180322_155615.28562
Log File : /tmp/nz_migrate.20180322_155615.28562/nz_migrate.output
Total # of tables processed: 1
Total # of records unloaded: 165,915
# of seconds to unload/load the records : 6
# of seconds to compare/cksum the tables: 0
=======================================================================================
Don't forget to run GENERATE [EXPRESS] STATISTICS on your tables!
################################################################################
################################################################################
################################################################################
Per your request ( -CreateTargetDatabase YES ), the target database
was created for you. Additional details can be found here:
Source DDL: /tmp/nz_migrate.20180322_155615.28562/source.ddl
Target Output: /tmp/nz_migrate.20180322_155615.28562/target.ddl.out
################################################################################
Counts Statements/Messages
======= ============================
18 ALTER PROCEDURE
2 ALTER SEQUENCE
430 ALTER SYNONYM
27 ALTER TABLE
4 CREATE AGGREGATE
1 CREATE DATABASE
258 CREATE FUNCTION
2 CREATE LIBRARY
18 CREATE PROCEDURE
2 CREATE SEQUENCE
430 CREATE SYNONYM
27 CREATE TABLE
50 GRANT
1 SET VARIABLE
################################################################################
################################################################################
################################################################################
The script completed successfully with no errors.
pre -request.
This will create the new database and there should not be DB available on target side with same name.
it will be helpful to migrate the UDF and it will ask you to enter the target OS user password to scp the files/ddl from source to target
nz_migrate -shost <source_server_name> -thost <target_server_name> -sdb <source_db_name> -tdb <target_db_name> -CreateTargetDatabase yes -table <tablename> -CreateTargetUDX YES -tuser admin -tpassword 'password' -CreateTargetTable yes -TruncateTargetTable False -format binary -threads 4
=======================================================================================
nz_migrate started on 2018-03-22 15:57:48
Migrating <sourcer_server_name>:"source_DB_name". --> <target_server_name>:"source_DB_name_NEW".
Data Format : binary
Log Directory : /tmp/nz_migrate.20180322_155615.28562
Log File : /tmp/nz_migrate.20180322_155615.28562/nz_migrate.output
Initiated From: SOURCE host
Top Level PID : 28562
SOURCE Version: 7.0 # of Dataslices: 46 Unloaded Via: nzsql
TARGET Version: 7.0 # of Dataslices: 184 Loaded Via: nzload
script version: 7.1
=======================================================================================
nz_migrate table 'Table_name'
.....processing table 1 of 1
.....migration process started at 2018-03-22 15:57:48
.....estimated # of records 165,915
.....nzload starting ( thread 1 of 6 )
.....nzload starting ( thread 2 of 6 )
.....nzload starting ( thread 3 of 6 )
.....nzload starting ( thread 4 of 6 )
.....nzload starting ( thread 5 of 6 )
.....nzload starting ( thread 6 of 6 )
.....unloading data ( thread 1 of 6 )
.....unloading data ( thread 2 of 6 )
.....unloading data ( thread 3 of 6 )
.....unloading data ( thread 4 of 6 )
.....unloading data ( thread 5 of 6 )
.....unloading data ( thread 6 of 6 )
.....data flowing.....
.....unload results ( thread 3 of 6 ) INSERT 0 28965
.....unload finished ( thread 3 of 6 ) elapsed seconds: 1
.....unload results ( thread 2 of 6 ) INSERT 0 28825
.....unload finished ( thread 2 of 6 ) elapsed seconds: 1
.....unload results ( thread 1 of 6 ) INSERT 0 28572
.....unload finished ( thread 1 of 6 ) elapsed seconds: 1
.....unload results ( thread 6 of 6 ) INSERT 0 25393
.....unload finished ( thread 6 of 6 ) elapsed seconds: 1
.....unload results ( thread 4 of 6 ) INSERT 0 29011
.....unload finished ( thread 4 of 6 ) elapsed seconds: 1
.....unload results ( thread 5 of 6 ) INSERT 0 25149
.....unload finished ( thread 5 of 6 ) elapsed seconds: 1
.....nzload finished ( thread 3 of 6 ) elapsed seconds: 6
.....nzload successful ( thread 3 of 6 )
.....nzload finished ( thread 2 of 6 ) elapsed seconds: 6
.....nzload successful ( thread 2 of 6 )
.....nzload finished ( thread 1 of 6 ) elapsed seconds: 6
.....nzload finished ( thread 6 of 6 ) elapsed seconds: 6
.....nzload successful ( thread 1 of 6 )
.....nzload successful ( thread 6 of 6 )
.....nzload finished ( thread 4 of 6 ) elapsed seconds: 6
.....nzload successful ( thread 4 of 6 )
.....nzload finished ( thread 5 of 6 ) elapsed seconds: 6
.....nzload successful ( thread 5 of 6 )
.....migration process ended at 2018-03-22 15:57:54
.....data flow finished
.....actual # of records unloaded 165,915
.....
.....migration completed TOTAL seconds: 6
.....
.....cksum process started at 2018-03-22 15:57:54
.....cksum process ended at 2018-03-22 15:57:54
.....confirmed cksum: 0.0 165915 Table_name
.....
.....cksum completed TOTAL seconds: 0
=======================================================================================
nz_migrate finished on 2018-03-22 15:57:54
Migrating <sourcer_server_name>:"source_DB_name". --> <target_server_name>:"source_DB_name_NEW".
Data Format : binary
Log Directory : /tmp/nz_migrate.20180322_155615.28562
Log File : /tmp/nz_migrate.20180322_155615.28562/nz_migrate.output
Total # of tables processed: 1
Total # of records unloaded: 165,915
# of seconds to unload/load the records : 6
# of seconds to compare/cksum the tables: 0
=======================================================================================
Don't forget to run GENERATE [EXPRESS] STATISTICS on your tables!
################################################################################
################################################################################
################################################################################
Per your request ( -CreateTargetDatabase YES ), the target database
was created for you. Additional details can be found here:
Source DDL: /tmp/nz_migrate.20180322_155615.28562/source.ddl
Target Output: /tmp/nz_migrate.20180322_155615.28562/target.ddl.out
################################################################################
Counts Statements/Messages
======= ============================
18 ALTER PROCEDURE
2 ALTER SEQUENCE
430 ALTER SYNONYM
27 ALTER TABLE
4 CREATE AGGREGATE
1 CREATE DATABASE
258 CREATE FUNCTION
2 CREATE LIBRARY
18 CREATE PROCEDURE
2 CREATE SEQUENCE
430 CREATE SYNONYM
27 CREATE TABLE
50 GRANT
1 SET VARIABLE
################################################################################
################################################################################
################################################################################
The script completed successfully with no errors.
No comments:
Post a Comment