Restoring a SQL Database on a remote machine

[AndyC]

Hi,

Currently as part of the build process we restore a sql database on a test machine before running nunit tests. Could you tell me if VBP has commands / scripts for doing this?

Thanks,

Andy

[kinook]

If it's a SQL Server database, you can use a Run SQL step with a statement like

RESTORE DATABASE dbname FROM DISK = '%PROJDIR%\dbname.dat' WITH REPLACE;

[ambalboa]

Would the RESTORE DATABASE command go on the String text box found on the Input tab. I basically know nothing about SQL.

[kinook]

Yes.