How to copy an ASP/MS SQL site to a local machine

How to copy an ASP/MS SQL site to a local machine

Customer wants to copy his/her site to a local PC to show off in a "live" demo.

You might want to look at http://www.w3schools.com/asp/asp_install.asp.
It has a brief tutorial on how to set up Personal Web Server on a
PC/Laptop which supports ASP (maybe not a full implementation, but
still might be enough for your needs).



As for the MS SQL portion, you can definately look at MSDE from Microsoft: http://www.microsoft.com/sql/msde/default.mspx. It's a stripped down version of MS SQL 2000, which may or may not be enough for your needs.



Once you are ready to copy the site, just copy all of the web content
off of the server to your laptop into the predefined folder set up in
PWS and then "dump" the database from the MS SQL 2000 server in our
cluster and reimport it into your MSDE, changing hard links where/if
appropriate. That should get you all set up and ready to go.
    • Related Articles

    • Restoring MSSQL via MS SQL Studio - VPS/Cloud/Dedicated only

      To restore a MSSQL database to your VPS or dedicated server, you would do the following steps: 1) Login to MS SQL Studio via remote desktop -- you will want to use an admin login and if you do not have this please contact us. 2) Right click the ...
    • Restoring a MSSQL database from a .sql file using EMS Sql Manager Lite

      How do I restore an MSSQL database from a .sql file? If you don't have a SQL management program, go to http://sqlmanager.net/en/products/studio/mssql to download the freeware version and install to your local computer.   Start EMS Sql Manager. If ...
    • Redirect non www domain to www in classic asp

      If you are running your site on classic .asp, on a IIS 6 web server. Here is a method you can use to forward all non www. requests to www.example.com. Create a new file for example named: redirect.asp | and insert this code into the file redirect.asp ...
    • Extract or backup a MSSQL database to a .sql file using EMS Sql Manager Lite

      How do I extract or restore an MSSQL database to a .sql file? If you don't have a SQL management program, go to http://sqlmanager.net/en/products/studio/mssql to download the freeware version and install to your local computer.   Start EMS Sql ...
    • How do I enable detailed errors in classic ASP?

      You can enable detailed error messages for your classic ASP site defaulted to Windows/IIS by using a web.config file with the following: <configuration> <system.webServer> <httpErrors errorMode="Detailed" /> </system.webServer> </configuration> Note: ...