Import database to Aster from Microsoft SQL Studio Management

Aster
Enthusiast

Import database to Aster from Microsoft SQL Studio Management

Hello folks,

Can someone explain me how to import database from Microsoft SQL Studio Management to Aster Database.

I have tried to import 60k of rows from .csv but it takes me 25 minutes to load it in Aster. 

So, how much time do I need to export the whole database that has more than 70 mil of rows at this moment?

Also, I tried to setup ODBC connection but without success.

 

Thank you in advance.

 

3 REPLIES
Teradata Employee

Re: Import database to Aster from Microsoft SQL Studio Management

Unfortunately, there is no automated way to import all data from Microsoft to Aster. Teradata Professional Services can assist with migration of whole databases. They have developed scripts and functions that help to automate the process.

Enthusiast

Re: Import database to Aster from Microsoft SQL Studio Management

Is there any manual workaround process to resolve this?

Teradata Employee

Re: Import database to Aster from Microsoft SQL Studio Management

The manual way is to export the data from Microsoft to text or csv files and import them into Aster via ncluster_loader.