CODEWITHSUNDEEP
sql-server-2005sql-server-2008smo
Mathias F
Mathias F

Reputation: 15891

Transfer Database from SQL-Server 2005 to SQL-Server 2008

I have an existing application that transfers a Database from a source server to a target server via SMO "Transfer". We transfer only the data.

Both SQL-Servers are 2005.

Now we upgrade the target server to SQL-Server 2008. Will the transfer via SMO still work?

Upvotes: 0

Views: 445

Answers (2)

Mathias F
Mathias F

Reputation: 15891

This didn't work out of the box. I had to use the SMO-dll of SQL Server 2008. They have slightly different names. It was not necessary to change code.

My databases where set to use SQLServer 2005 compatibility mode. I had to change them to native SQLServer 2008 mode.

Upvotes: 0

Mladen Prajdic
Mladen Prajdic

Reputation: 15677

yes. they should. SMO hasn't really changed between version.

Upvotes: 1

Related Questions