0

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?

Mathias F
  • 15,906
  • 22
  • 89
  • 159

2 Answers2

1

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

Mladen Prajdic
  • 15,457
  • 2
  • 43
  • 51
0

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.

Mathias F
  • 15,906
  • 22
  • 89
  • 159