Friday, November 25, 2005

1440.aspx

Phase 1 of migration over

Mail, blog and web sites are all happily running on my laptop.


My server used a free MSDE DB but decided to try the SQL Server 2005 Standard Edition I got at the Italian Visual Studio 2005 Launch Event when I moved it to my laptop.


I was really impressed with the "Copy Database" feature in SQL Server 2005. It can copy the data using the standard SQL data management objects present in SQL Server 2000, but it can also attache a SQL Server 2000 database directly. I took my old MSDE DB offline, copied it to my laptop, attached the DB in the Microsoft SQL Server Management Studio and was up an running in less than a minute. It just worked.


Impressive.


Phase 2 (re-installing my server and moving everything back again) will take place tomorrow night.


Let me know if you find any problems.

No comments:

Post a Comment