SQL 2000 to SQL 2005 Replication

• Jonathan Turlington

  Old Hand

  Points: 360

  More actions

  May 3, 2010 at 12:40 pm

  #221157

  I need to move a database from a 2000 Server to a 2005 Server and then keep them up to date.

  Does anyone know of an article or any type of step by step that might help me with this?

• Nunnery

  Ten Centuries

  Points: 1293

  More actions

  May 3, 2010 at 12:47 pm

  #1161454

  Give the following article a read and see if it helps:

  http://www.aspfree.com/c/a/MS-SQL-Server/Moving-Data-from-SQL-Server-2000-to-SQL-Server-2005/

• Jonathan Turlington

  Old Hand

  Points: 360

  More actions

  May 3, 2010 at 1:36 pm

  #1161479

  This appears to be a method by which we will be able to move the data but what about some way to keep it up to date?

• Nunnery

  Ten Centuries

  Points: 1293

  More actions

  May 4, 2010 at 9:06 am

  #1161865

  Here is an article on database mirroring in sql server 2005:

  http://searchsqlserver.techtarget.com/tip/Database-mirroring-setup-in-SQL-Server-2005

• noeld

  SSC Guru

  Points: 96590

  More actions

  May 4, 2010 at 1:23 pm

  #1162054

  Google is your friend:

  http://www.databasejournal.com/features/mssql/article.php/1438201/Setting-Up-Transactional-Replication-A-Step-by-step-Guide.htm

  
  * Noel