Ars Technica

Easy way to move a database from one SQL Server instance to another

I'm trying to copy a database from one server (SQL Server 2000 Enterprise Edition) to another (SQL Server 2005 Standard Edition) to make sure the second is suitable as a backend to some terrifying ...
Ars Technica

SQL Server - migrating to a new server

My inclination is to stop SQL Server services, copy the database and log files over to the new server, and then attach the database to the new server using the "attach" command. Is there a better or ...
dbta

Upcoming Webinar Shows How to Move MV Data to SQL Server using BlueFinity's mv.SSIS

BlueFinity will demonstrate how to create a simple SSIS transformation to move MultiValue data into Microsoft SQL Server using mv.SSIS in a free webinar on Tuesday, January 31. Microsoft SQL Server's ...
Network World

Upgrade your Database Compatibility Level

For instance, if you copy a SQL 2000 database to SQL Server 2008, the new copy is an upgrade to the new internal format but retains a Compatibility Level of “80” which represents SQL 2000 aka SQL 8.0.