20 Dec 21 ·  Manish-Suri in general ·        Bookmark ·  Report ·  More actions.. Lock comments ·  Pin thread

Download DDL/DML files from teradata using python

Hi all,

What approach should I follow to download DDL, DML and Stored Procedures from the teradata database using python.

I have created the sample code but what is the approach to download these sql files for data migration process.

udaExec = teradata.UdaExec(appName="HelloWorld", version="1.0",logConsole=False)

session = udaExec.connect(method="odbc", system="xxx",username="xxx", password="xxx");

for row in session.execute("show tables {} > {}".format(tables, export_tables)):

print(row)

Unlike MSSQL which had mssql-scripter to download .sql files, does Teradata provide any such option to download? Also, does it provide support to download sequences, views and procedures?

For the Schema Migration process, what should be the best approach to download these files from the Teradata as a source?

Manish-Suri

posted on 20 Dec 21

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds




nVector09-Jan-22

I Havent scripted this in Python.

But downloading the ddls is relatively straight forward in Teradata.

Try this guide