Thursday, April 10, 2008

MS SQL 2005 Express

I have successfully transferred my entire website project from my laptop to my desktop. Logically one would setup a database that is accessible through the internet. However, I still wanted a local database copy to work from (which is great for getting data out of sync between the two sources). Thus, I had to do a backup database, and then sent the backup to the destination computer, and restored database (allowing overwrite). I know, probably a really bad way to transfer a database, but it worked.

The only issues I ran into while transferring this project is that database mdf file for personalization requires MS SQL 2005 Express. After installing sql express, success!