Copy SQL Server Database with PURE ASP!
Posted on 2004-08-22
Here is the senario.
We need to copy an SQL Server Database from it's current location to another SQL server on a completly different network (accessible over internet http)
We do not have file level access to the SQL Server...
The server sits behind a firewall, and is not exposed to the internet..... hence enterprise manager connection is not possible.
The only way we can go about this is with pure ASP script. The Webserver is exposed to the internet, and is the only machine that can see the sql server. .... The SQL server the DB will be copied to is freely accessible also from the webserver.
I'm looking for code here.... not links to the many places I've already googled for.