I am curious to know if i script the replication scripts for creating
publisher, publication,etc on 2000, can i safely run them on sql 2005 or are
there some changes to the metadata ?
Thanks
Yes you can run them no problem.
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
"Hassan" <hassan@.hotmail.com> wrote in message
news:%23hK0gj8yHHA.1208@.TK2MSFTNGP03.phx.gbl...
>I am curious to know if i script the replication scripts for creating
>publisher, publication,etc on 2000, can i safely run them on sql 2005 or
>are there some changes to the metadata ?
> Thanks
>
|||Have a look in BOL at : "How to: Upgrade Replication Scripts".
The original ones should work OK but the recommendation is to make changes
to the security of the jobs.
Cheers,
Paul Ibison
sql
Monday, March 26, 2012
Replication scripts for 2000 same as 2005 ?
Labels:
creatingpublisher,
curious,
database,
microsoft,
mysql,
oracle,
publication,
replication,
run,
safely,
script,
scripts,
server,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment