473,327 Members | 1,976 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

SQL 7 to SQL 2000 Database Migration

Could someone help us with a problem we're having with regard to
moving several databases from SQL 7 to SQL 2000 on different servers
in different domains. Our current SQL 7 server resides in one domain,
and holds several databases. We now want to move these to a SQL 2000
server in another domain.

We're trying to use the Copy Database wizard on the SQL 2000 server
(logged in as the local admin account), selecting the SQL 7 server as
the source, using 'sa' account on that server. The target is the SQL
2000 server, again using 'sa' account. We're leaving everything else
with regards to logins, jobs etc as default (i.e. taking everything
that can be found), but when the steps execute, the last step that
brings the database across fails with an error code -2147467259 -
Failed to create the share OMWWIZI.

Can anyone help us out with this error, or provide any suggestions as
to what we can do?

Any help would be greatly appreciated. Thanks.
Jul 20 '05 #1
2 4959

"LizP" <li**********@scottishfriendly.co.uk> wrote in message
news:81*************************@posting.google.co m...
Could someone help us with a problem we're having with regard to
moving several databases from SQL 7 to SQL 2000 on different servers
in different domains. Our current SQL 7 server resides in one domain,
and holds several databases. We now want to move these to a SQL 2000
server in another domain.

We're trying to use the Copy Database wizard on the SQL 2000 server
(logged in as the local admin account), selecting the SQL 7 server as
the source, using 'sa' account on that server. The target is the SQL
2000 server, again using 'sa' account. We're leaving everything else
with regards to logins, jobs etc as default (i.e. taking everything
that can be found), but when the steps execute, the last step that
brings the database across fails with an error code -2147467259 -
Failed to create the share OMWWIZI.

Can anyone help us out with this error, or provide any suggestions as
to what we can do?

Any help would be greatly appreciated. Thanks.


According to the Books Online section "Using the Copy Database Wizard", if
you are using Windows NT/2000, your user account must have administrator
privileges on both servers, ie. Windows admin privileges, not MSSQL sysadmin
privileges.

I would guess that either your Windows account doesn't have these
privileges, or it isn't trusted in one of the domains. One possible solution
is to backup the source database, copy the backup file, and restore it on
the destination server (this is possible from SQL7 to SQL2000). You could
also detach, copy and then attach the source database files, which I believe
is what the Copy Database wizard does anyway.

Simon
Jul 20 '05 #2
Hi

Not sure about this, but at a guess you need to make the domains trust each
other as well.

You may want to check out
http://support.microsoft.com/default...en-us%3b224071
http://support.microsoft.com/default.aspx?kbid=246133

John

"LizP" <li**********@scottishfriendly.co.uk> wrote in message
news:81*************************@posting.google.co m...
Could someone help us with a problem we're having with regard to
moving several databases from SQL 7 to SQL 2000 on different servers
in different domains. Our current SQL 7 server resides in one domain,
and holds several databases. We now want to move these to a SQL 2000
server in another domain.

We're trying to use the Copy Database wizard on the SQL 2000 server
(logged in as the local admin account), selecting the SQL 7 server as
the source, using 'sa' account on that server. The target is the SQL
2000 server, again using 'sa' account. We're leaving everything else
with regards to logins, jobs etc as default (i.e. taking everything
that can be found), but when the steps execute, the last step that
brings the database across fails with an error code -2147467259 -
Failed to create the share OMWWIZI.

Can anyone help us out with this error, or provide any suggestions as
to what we can do?

Any help would be greatly appreciated. Thanks.

Jul 20 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Andreas Lauffer | last post by:
I changed from Access97 to AccessXP and I have immense performance problems. Details: - Access XP MDB with Jet 4.0 ( no ADP-Project ) - Linked Tables to SQL-Server 2000 over ODBC I used...
1
by: ss_dash | last post by:
Hi all, I am using the Oracle Workbench for migrating my DB currently on Sql Server 2000 to Oracle 9i. During the migration the following happens SELECT @tBaseTable = tBaseTable,...
2
by: Serdar Yegulalp | last post by:
I'm in the process of migrating a lot of data (millions of rows, 4GB+ of data) from an older SQL Server 7.0 database to a new SQL Server 2000 machine. Time is not of the essence; my main concern...
4
by: serge | last post by:
I am doing a test on migrating an Oracle 8i database to SQL 2000. I've never done this before and I would like to find out if there are any complications or side effects if I try doing the...
11
by: Jep | last post by:
Any help or advice appreciated. We have just installed and configured a new DB2 v.8.1 with latest FixPack. Just a few days later it dies and now we have a DB that is totally unusable. - - - -...
4
by: Collin Peters | last post by:
I have searched the Internet... but haven't found much relating to this. I am wondering on what the best practices are for migrating a developmemnt database to a release database. Here is the...
8
by: Mark Rowland | last post by:
Please bear with me, as I am a newbie in the world of databases and DB2. We are trying to migrate an application that binds to a DB2 database (Workgroup Edition, V6.1) from a server running Windows...
1
by: Ben | last post by:
I would like to attend a conference/seminar/educational presentation on SQL Server. I don't know what types of qualifications to use in evaluating these types of events, nor do I really even know...
2
by: =?Utf-8?B?SmVmZnJleQ==?= | last post by:
I have some old ASP programs w/ SQLserver 2000 databases. Now I am developing ASP.NET projects using VB 2005 and SQLserver 2005. What are the best procedures to develop and test the ASP.NET...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.