I meant updating sql server 2008 R2 database with sql server 2000 (i.e. 2000 >2008) ?
I successfully restore the 2000 database into 2008 but what i need to know is a method to update 2008 database when ever change occur and using restoring for that is not a goog idea (I think !).what do u say ?
Can i use DTs packages in 2000 to achieve that but 2008 didn't support DTs ?