I am trying to figure out how to do database backup using teradata studio express and TTU 15.0 - Can anyone plese advise how I can go about doing this?
I am basically trying to obtain a backup copy of a teradatabase and test restoring it in SQL server environment.
Any help would be greatly appreciated.
This is well outside the scope of the intended use of Studio. What does "restoring it in SQL Server environment" mean? Just table definitions / contents? What about permissions, character set differences, and on and on...?
I am experimenting importing a teradata archive database into MS SQL. To do this, I need to have an archive of the teradata db. I am happy if I can only copy table definitions and contents into MS SQL. Do you have any idea about the file extension of teradata archives?