Migrate All the Tables of SQL Server DataBase to TeraData in one go

Database
N/A

Migrate All the Tables of SQL Server DataBase to TeraData in one go

Hi,

I am working on a project which is intended to migrate our SQL Server DataBases to TeraData. We are using TD 13.10.

1. I have tried OleLoad. But using this we can only export one table at a time.

2. I have used EFS Tools. But data Conversion is wrong.

3. For using MultiLoad we have to write the script for all the table separately.

My requirement is that I will give the source database(from sql server) and then target as TeraData. Now it should happen that all the tables from the

source database should be migrated(With Schema if Table Doesn't exist) with data(if there), to the TeraData.

Kindly Provide solution for this.

Thank you in Advance :)

2 REPLIES
Enthusiast

Re: Migrate All the Tables of SQL Server DataBase to TeraData in one go

You can uses SSIS and Teradata connector to load data .. ou might have to do some transformation to support data types

Enthusiast

Re: Migrate All the Tables of SQL Server DataBase to TeraData in one go

Hi,

I think you can write a procedure that will generate all the Teradata equalent DDL's for all the tables in SQL Server. Once the DDL's are deployed then you can copy data using the following options:

  1. Export data from SQL Server using BCP utility
  2. Import data to Teradata using TPT Tdload command.

OR

  1. Use SSIS along with attutnity operators for Teradata.
Khurram