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 |
|
maximus_vj
Yak Posting Veteran
88 Posts |
 Posted - 2008-01-21 : 15:16:14
|
| Hello,I have a database in SQL Server 2000. In that database I have a large table.I want to replicate this to a new SQL Server 2000 database. But while replicating I want to split the data in this large table to several tables based on the Year column.Is this possible?Thanksmaximus_vj |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2008-01-21 : 15:17:58
|
| You can hack the replication insert/update/delete procs to do a custom insert into your tables but that may not be supported.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
maximus_vj
Yak Posting Veteran
88 Posts |
Posted - 2008-01-21 : 15:41:36
|
| Is there any other way to do this that is built into SQL Server? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2008-01-21 : 16:16:20
|
| can use column filters and have multiple publications...but...probably not the right tool for the job. better to partition the data after its been replicated |
|
|
|
|
|
|
Replication Question