Unable to Migrate a SQL 7.0 Database to SQL 2000 SP 2 
Author Message
 Unable to Migrate a SQL 7.0 Database to SQL 2000 SP 2

Hi and thank you in advance
I am trying to use the SQL 2000 Copy Database Wizard to transfer a database
found in another machine running SQL 7.0 SP 3, but everytime I try to run
the DTS that the Wizard in 2000 create it return the following message.

Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Unspecified error

Step Error code: 80004005
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:1100

Please note. That I setup the database in SQL 7.0 to be read-only according
to manual.
Please help
I need to move database between SQL 7.0 to SQL 2000, and it seems that it is
going to be a problem.
Thank you
Tomas



Sat, 22 May 2004 03:57:52 GMT
 Unable to Migrate a SQL 7.0 Database to SQL 2000 SP 2

Don't know what your problem is with DTS, but if you stop
the DB on SQL7 copy the MDF and LDF to the new machine.  
Then use Attach on SQL 2000 your done.
 Note this is a one way thing.  7 --> 2000

KlK, MCSE

Quote:
>-----Original Message-----
>Hi and thank you in advance
>I am trying to use the SQL 2000 Copy Database Wizard to
transfer a database
>found in another machine running SQL 7.0 SP 3, but

everytime I try to run
Quote:
>the DTS that the Wizard in 2000 create it return the
following message.

>Step Error Source: Microsoft Data Transformation Services
(DTS) Package
>Step Error Description:Unspecified error

>Step Error code: 80004005
>Step Error Help File:sqldts80.hlp
>Step Error Help Context ID:1100

>Please note. That I setup the database in SQL 7.0 to be
read-only according
>to manual.
>Please help
>I need to move database between SQL 7.0 to SQL 2000, and
it seems that it is
>going to be a problem.
>Thank you
>Tomas

>.



Sun, 23 May 2004 02:51:07 GMT
 Unable to Migrate a SQL 7.0 Database to SQL 2000 SP 2
Hi Tomas,

Two possible causes for this problem:  
1)  The less likely, the share OMSWIZD, OMSWIZC ; OMWWIZD, or OMWWIZD
already exists where the last letter is the drive letter that SQL server is
installed on  

2)  The user does not have sufficient permissions on the source server to
create the share.  This is the most likely scenario and the below explain
it
in detail.

On the source server add to the administrator's group the user (who is
logged into NT or Windows 2000 on the Destination server) to be a member of
the local administrator's group.  NOTE:  Both computers should be on the
same domain to do the COPY/Move from another computer otherwise you must
establish a trust relationship between the domains before you start.  You
also must be a local ADMIN on both machines.

For the first possibility, go to command prompt and run "net share".  This
showed that OMWWIZC share was created and pointing to c:\.  Used "net share
OMWWIZC /delete" to remove this share, then copy database wizard started
successfully.

Hope this helps!

--- Simon Liao

Please reply only to the newsgroups. When posting, inclusion of SQL (CREATE
TABLE ..., INSERT ..., etc.) which can be cut and pasted into Query
Analyzer is appreciated.

This posting is provided "AS IS" with no warranties, and confers no rights.



Sun, 23 May 2004 09:29:29 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. migrating sql databases from sql 7.0 to sql 2000

2. Migrating an SQL Server 7.0 database to an SQL Server 2000

3. Migrate to Win 2000/Sql 2000 from Win Nt/Sql 7.0

4. Help - migrating from SQL 2000 desktop to SQL Server 7.0

5. Downgrade / Migrate - SQL SERVER 2000 - SQL SERVER 7.0

6. Migrating a DB from SQL 7.0 to an SQL 2000 server

7. migrating from WinNT/SQL 7.0 to Win2000/SQL 2000

8. Migrating from SQL Server 7.0 to SQL Server 2000

9. Migrating Existing SQL 7 Databases to SQL 2000 Databases on New Box

10. Problem with SP created with Query Analyzer v.2000 on a SQL 7.0 database

11. Porting a SQL 2000 Database (7.0 Compliant) to SQL 7.0

12. Migrate an SP to sql server 2000


 
Powered by phpBB® Forum Software