stevegray
4Penny.net
Points: 55509

9/1/2023 12:23:41 PM

Create (and restore a database to) a TEST server for app testing

* This article, and all our great SQL (General) documentation, Is available on the SQL (General) menu

If you're just testing GP code, you can use a TEST  database. No problem. 

But in this case there are other linked dbs (documents, security) and I need to test on a separate server.

So, this is code that will backup up SQL database to a separate server

 

4Penny.net
Version: All
Section: SQL Scripts
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3