copy a SQL database from one server to another server on IBM netezza Aginity workbench

Question

I need to copy a sql database from one server to another server on IBM netezza Aginity workbench.

I know how to do it in MS SQL server.

But, I am not familiar with IBM netezza.

Do I need to copy the database to a local drive and then copy it to the target server from the local drive ?

Any help would be appreciated.

thanks

Answer 1

You could use a tool like WinSQL to map the fields from your MS SQL Server to your Netezza Server. From there you would need to dump out all your data in SQL Server using BCP one table at a time. Then use Netezza Transient External Tables or NZload to load to the new box.