Kinook Software Forum

Kinook Software Forum (https://www.kinook.com/Forum/index.php)
-   [VBP] Third Party Tools (https://www.kinook.com/Forum/forumdisplay.php?f=3)
-   -   Restoring a SQL Database on a remote machine (https://www.kinook.com/Forum/showthread.php?t=1522)

AndyC 02-03-2006 11:36 AM

Restoring a SQL Database on a remote machine
 
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 02-03-2006 01:17 PM

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 10-11-2007 02:28 PM

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

kinook 10-11-2007 03:05 PM

Yes.


All times are GMT -5. The time now is 01:00 AM.


Copyright © 1999-2023 Kinook Software, Inc.