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.
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.
The manual way is to export the data from Microsoft to text or csv files and import them into Aster via ncluster_loader.