Help on sql sync

Hi, all
We have prod. database and test db(new version of prod, table fields
changed).
Production db has users connected and updating records and I need to have
user transactions in production db updated in test db as well.
I can't use log shipping to sync them because of the table structures a
little diff or some datatype changed in new version(test db).
I can't do the DTS neither. It may have too many tables effected.
What is the best way to do the sync.
thanks in advanceThere is table replication in sql 2k?
Thanks
"mecn" <mecn2002@.yahoo.com> wrote in message
news:uiulJTD2GHA.476@.TK2MSFTNGP06.phx.gbl...
> Hi, all
> We have prod. database and test db(new version of prod, table fields
> changed).
> Production db has users connected and updating records and I need to have
> user transactions in production db updated in test db as well.
> I can't use log shipping to sync them because of the table structures a
> little diff or some datatype changed in new version(test db).
> I can't do the DTS neither. It may have too many tables effected.
> What is the best way to do the sync.
> thanks in advance
>
>
>
>
>|||Hi,
You can not use Logshiiping or Replication because based on my understanding
both environments are in read/write mode. Due to this we can not apply the
transaction log file. The best way for you is to write a batch file to do
frequent updates.
Thanks
Hari
SQL Server MVP
"mecn" <mecn2002@.yahoo.com> wrote in message
news:%23GpcOWD2GHA.1568@.TK2MSFTNGP03.phx.gbl...
> There is table replication in sql 2k?
> Thanks
>
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:uiulJTD2GHA.476@.TK2MSFTNGP06.phx.gbl...
>|||You can use transactional replication to replicate to tables of different
schemas. See this for more info.
http://www.dbazine.com/sql/sql-articles/cotter1
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"mecn" <mecn2002@.yahoo.com> wrote in message
news:uiulJTD2GHA.476@.TK2MSFTNGP06.phx.gbl...
> Hi, all
> We have prod. database and test db(new version of prod, table fields
> changed).
> Production db has users connected and updating records and I need to have
> user transactions in production db updated in test db as well.
> I can't use log shipping to sync them because of the table structures a
> little diff or some datatype changed in new version(test db).
> I can't do the DTS neither. It may have too many tables effected.
> What is the best way to do the sync.
> thanks in advance
>
>
>
>
>