That said, the MS site has volumes of data on migrations and upgrades, all of which really should be read fully before production data is moved... Here is one to start with..<br> SQL Server 2005 ...

The Connection Properties dialog opens. For my sample ITworld application, I changed the data source to Microsoft SQL Server (SQLClient), and entered the necessary Server, Log On, and database values.