Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Deltaur
Starting Member
29 Posts |
 Posted - 2009-08-06 : 08:55:12
|
| I am trying to make myself clear how to make this kinda operation. So, i need to only oneway "copy" of database from certain tables, can someone point me somekind best-practice instructions? I tried to google but didnt know where to start.Thanks!Edit: I have now backupped the SQL2000 database and restored it to SQL2005 server. How i create replication from SQL2000 to SQL2005 server so that only changed data is copied to SQL2005 server database. And also that it is only oneway, only SQL2000 -> SQL2005 is allowed not SQL2005->SQL2000.Edit 2:Ok, now i have transactional replication configured, but one error is popping up "Invalid column name 'TYPE_DESC'". |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-08-07 : 16:59:41
|
| the error message probably also mentioned a table name? check the schema of the tables on both publisher and subscriber.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
|
|
|
Replication from SQL2000 -> SQL2005