Re: Moving SQL Server 7.0 database to SQL Server 2000

Hi John

Although SQL 7 is very similar to SQL 2000 and you can restore a SQL 7
backup onto SQL 2000, you will need to check that there is no issues with
your application running on SQL 2000 before you do the upgrade. If there are
any issue you will have to implement them before upgrading the database.

For your replication questions the microsoft.public.sqlserver.replication
newsgroup may be a better place to ask. I don't think there is any reason
why you can't do what you require, but you should read the BOL sections:
"Replication and Upgrading"
"Replication Between Different Versions of SQL Server"

Values such as timestamp datatypes will not have their literal value
transferred see "Data Needs and Characteristics" in BOL, this may cause
compliance issues.

John

"John" <John@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2DE2263D-9E3F-49A9-A940-D8F851AE7558@xxxxxxxxxxxxxxxx
> Hi, we are moving databases from 7.0 to 2000 server. here are the steps to
> fulfill:
>
> 1. We are taking backup of existing databases and move to 2000 server
> (with
> robocopy from server to server)
> 2. then we are going to set up Replication (Snapshot), because our
> business
> is 24/7 online.
>
> is there any other way to move the databases and insync online , please
> advice.
>
> thanks in advance


.

Relevant Pages

  • Re: Change distribution server
    ... This is more of a maintenance question regarding replication. ... With all the SQL Agent jobs and replication pieces, ... Remember my scenario has the remote distributor on SQL2000 if that matters. ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: SQLEXPRESS Replication?
    ... The way the Technet SQL BOL is arranged it is difficult to know just how to setup the required permissions to do replication which is the major stumbling block. ... You can replication from SQL Server 2005 Workgroup edition and above ... to a SQL Server Express subscriber using transactional replication. ...
    (microsoft.public.sqlserver.replication)
  • Re: SQL 2000 and MSDE/Express/Compact edition..
    ... What is does is downloads .Net Framework and SQL Server Express if they are not installed and then configures SQL Server as a subscriber. ... string DotNetFramework2Location = ... LogMe("Creation of Replication Account failed."); ...
    (microsoft.public.sqlserver.replication)
  • Re: Advice Needed: Asynchronous Replication/Mirroring to central o
    ... Looking for a SQL Server replication book? ... geographically-dispersed remote locations. ...
    (microsoft.public.sqlserver.replication)
  • Re: Subscriber Transaction Logs Too Large
    ... Its not so critical to shrink the db files or transaction logs in SQL 2005. ... Director of Text Mining and Database Strategy ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
Loading