title: Database replication from SQLserver 2000 to SQLserver 2008
body: <p>I'm trying to replicate a rather large database from SQLServer 2000 to SQLServer 2008, located on two different servers. I found an article about attempting this and have been trying to follow its direction. Here is the article.</p>
  
  <blockquote>
    <p><a href="http://www.vinodunny.com/blog/post/Mixed-Mode-Bi-Directional-Transactional-Replication-between-SQL-2000-and-SQL-2008.aspx" rel="nofollow noreferrer">Mixed Mode Bi-Directional Transactional Replication between SQL 2000 and SQL 2008</a></p>
  </blockquote>
  
  <p>Here is the part I'm stuck on:</p>
  
  <blockquote>
    <p>"So, to create a publication, you will
    need to NOT use the publication wizard
    that you get in SQL 2008. Instead, use
    a generated publication script and for
    each <code>sp_addarticle</code> line that you have
    in it, make sure that the <code>@ins_cmd</code>,
    <code>@upd_cmd</code> &amp; <code>@del_cmd</code> parameters point
    to the appropriate stored procedures
    and run it on the SQL Server 2000
    server. Once this is done, go ahead
    and create a subscription to SQL
    Server 2008’s database normally."</p>
  </blockquote>
  
  <p>I was able to get the stored procedures in place for all of the tables but need some direction on creating a generated publication script. Does anyone have some direction or a good example of a generated publication script?</p>