Database Backup

Database
LY_
Fan

Database Backup

Hi,

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.

Thanks,

LY

Tags (1)
2 REPLIES
Teradata Employee

Re: Database Backup

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...?

LY_
Fan

Re: Database Backup

Hi Fred,

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?

Thanks

LY