Hi guys,

I have to restore from one DB to another.
We use Tivoli for MSSQL to perform this.

The problem is that datafiles are located in different path.
So when I use the GUI I have to manually relocate every datafile, and they are more than 30.
I would like to write it once in a file and then run it.
Does anyone know how to do that ?


i.e.:
tdpsql -relocate datafile1 to e:\mssql\data\datafile1.dbf
datafile2 to e:\mssql\data2\datafile2.dbf

It's very time consuming if I have to use GUI.

Thanks in advance.