Unanswered: Tivoli tdpsql. Relocate datafiles from command line
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 ?
tdpsql -relocate datafile1 to e:\mssql\data\datafile1.dbf
datafile2 to e:\mssql\data2\datafile2.dbf