SQL7 To SQL2000 Migration

Jul 20, 2005

Hi, guys - looking for a bit of help/advice on moving a database from
SQL 7 to SQL 2000.

We've a third party application which currently uses a SQL7 database.
This database has a number of views which are owned by user
INFORMATION_SCHEMA and are set as system tables. This user doesn't
actually have a login on the SQL server.

We've tried the following to recreate the database on SQL2000, but
whatever we try, the views owned by INFORMATION_SCHEMA won't copy over
from SQL7:

(1) We tried the "Copy Database" wizard in SQL2000, but were getting
errors when trying to actually copy the database (other steps worked
fine).
(2) We tried a restore to SQL2000 from our Legato Networker backup of
the SQL7 database, but the views didn't come across.
(3) We tried a backup from SQL7 and restore to SQL2000, but got the
message that the backup file contained a database other than the one
we wanted (it didn't - we checked the backup file several times by
restoring it to another SQL7 server).
(4) We tried to import/export data from SQL7 to SQL2000, but the views
owned by INFORMATION_SCHEMA weren't showing to add to the list of
objects to take across.
(5) We created the INFORMATION_SCHEMA login on SQL2000, and tried all
restores again, but still the views wouldn't go across.
(6) We generated the SQL for all views in SQL7 and ran these on
SQL2000, setting the owner to INFORMATION_SCHEMA, but wasn't sure
where to set the type to "system" (as opposed to "user).

We're having problems running the third party application with a
connection to SQL2000, and want to rule out the lack of views, or view
ownership, as the problem. Our third party vendor isn't coming up
with any solution in a hurry. Can anyone think of any reason why the
views are coming across when the database is restored to SQL2000?

Thanks for your help.

View 1 Replies


ADVERTISEMENT

Sql7 And Sql2000

Aug 26, 2002

Does a script that run with sql7 automatically run with sql2000?
I would like to know if my script will run if I change version.

View 1 Replies View Related

Sql7 And Sql2000 On Same Box

Sep 13, 2001

Does anyone know of any reasons(or implications) why sql7 and sql2000 databases SHOULD NOT be on the same box???

Please advise.

Thanks-

View 1 Replies View Related

Getting SQL2000 Data Into SQL7

Jun 18, 2002

Can anyone point me to a white paper/discussion on the issues of gaining access to SQL2000 data from a SQL7 installation? I'm about to upgrade servers from 7 to 2000, but a few of the servers exchange data bi-directionally and the upgrade to both servers at the same time would be problematic; thus the need at some point to get at the SQL2000 data from the SQL7 server.

Thanks,

AL

View 1 Replies View Related

Restoring A SQL7 DB On SQL2000

May 21, 2001

Somebody knows how to restore a database backup from SQL 7 in a Server with SQL 2000 Installed?

If somebody knows how to do it will save me a lot of work?

Thanks a lot.

View 2 Replies View Related

Moving To SQL2000 From SQL7

Nov 2, 2001

Hi folks,

I'm currently on a project that'll move all my SQL7 databases into SQL2000. This is from a SQL7 production box to a new Windows2k SQL2000 box. I'm confused as to the proper way of moving all the objects over. What should i do? Any information. Thank You!

View 1 Replies View Related

SQL7 & SQL2000 Administration

Dec 1, 2000

Is it possible to administer both SQL7 & SQL2000 databases from the same console ?? It's fine administering SQL 6.5 & SQL7, as 6.5 had no MMC, but it seems that SQL7 & SQL2000 have the same MMC.

Thanks,
Jazz.

View 1 Replies View Related

Restore Sql2000 Db Onto Sql7 ???

Jun 19, 2002

Hi there,
I need to create a copy of a SQL 2000 database in another server which has SQL 7.0 installed. When I do a backup and restore, it gives me the following error :

Server: Msg 3154, Level 16, State 2, Line 1
The backup set holds a backup of a database other than the existing 'inventmast' database.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

It seems to be like a downward compatability issue. Is there any other way to restore a sql2000 db onto sql 7 ??
Thanks
Paul

View 2 Replies View Related

Upgrading From SQL7 To SQL2000

Jun 28, 2002

I'm upgrading a set of databases from SQL7 on one server (A) to SQL2000 on another server (B). I'd like input on the best method for moving the databases over (BCP, restore from BAK, etc), and in particular on moving the list of valid users (with default databases, permissions to databases, etc) and the DTS packages and Agent jobs.

When moving the databases, which are currently in code page 850, I might want to have them convert to the standard Latin-1 of SQL2000, though this isn't critical.

TIA,

Al

View 1 Replies View Related

SQL7 / SQL2000 Compatibility

Jan 8, 1999

I have table with about 2 million rows. Everyday about 18000 rows are inserted. The table contain events for site security system so archiving is neccessary. I would appreicate any help or ideas. Thanks in advance.

View 2 Replies View Related

Migrating SQL2000 Db To SQL7.0

Jul 26, 2001

I have a SQL Server 2000 box running two databases which was upgraded in error from SQL7.0 Basically we are no longer being given support as SQL2000 is not supported by the suppliers.

I therefore need to downgrade the box to SQL7.0 and was wondering if anyone had any opinions on the best method for doing this. Note that I do have a spare server to host the databases while I rebuild this server ( I am having to do a complete rebuild from scratch for other reasons ).

My thought is to transfer the databases to the spare server, rebuild the first box to SQL 7.0 and then perform a snapshot replication to transfer the data back.

Any thoughts on this would be gratefully received.

View 1 Replies View Related

Moving A SQL7 DB To SQL2000

Feb 25, 2004

I have a backup of a SQL7 DB that i need to restore into SQL 2000. I only have the backup of the DB , i don't have access to the SQL7 server. When ever I try to restore the DB into SQL2000 nothing works, the tables and properties all restore properly and the data is there but i can't retrieve info from it. I'm trying to move a website DB from SQL7 to SQL 2000 for use with Cold Fusion. I know they're is issues with going from 7 to 2000 but i don't know what they are. If anyone could help me with this i would greatly appreciate it. I know I need to do some special steps or changes before it will work in 2000, does anyone know what these are?

Thanks in advance,
B

View 2 Replies View Related

SQL2000 PE Cannot Connect To SQL7 Server

Nov 13, 2000

I have setup SQL2000 Personal edition on my notebook.

I cannot connect to an existing SQL7 server on the network anymore. I
used to run SQL7 Desktop edition which ran just fine.
I also noticed that when I start my machine it take about 2 minutes
until the SQL service is started.

Any ideas why this is not working anymore?


Thomas Schoch
Elephant Software AG
Switzerland

View 1 Replies View Related

Moving A SQL7 Database To SQL2000

Dec 27, 2002

Can anyone tell me of an EASY way to migrate a a database from a SQL 7 server to a SQL 2000 server (two different machines)?

Everything that I have found is only for upgrading SQL 7 to SQL 2000 and this isn't what I need.

Two groups in our company merged into one. The first group has a SQL 7 server that the lease is about to expire on and the second group (mine) has a newer SQL 2000 server that we need to move all of the databases to.

I have tried DTS. It failed. I tried backing up the 7 server and restoring to the new server. It failed.

Are there any other suggestions?

Thanks,
Steve

View 4 Replies View Related

SQL7 To SQL2000 Upgrade Whitepaper

Jun 17, 2002

Does anyone know of a good whitepaper detailing SQL7 to SQL2000 migration?

Thanks, I really appreciate your help.

--Alex

View 1 Replies View Related

Restoring SQL7 Database To SQL2000

Feb 17, 2004

Hi all

just a quick question for you. has anyone had any problems restoring a SQL7 database to a SQL server 2000?

is there anything special you have to do to get it working?



thanks for your time.



Andrew.

View 1 Replies View Related

Restore A SQL2000 Db To A SQL7.0 Server

Jul 20, 2005

How to restore a database dump file (.BAK) that backed up from SQL2000 server to a SQL 7.0 server?Please help.Saiyou

View 1 Replies View Related

SQL7/SQL2000 Replication. Auth Error

Aug 12, 2002

I'm attemting to replicate from a SQL7 box to SQL2000.

The snapshot works fine, but it fails when it tries to push the subscription to the SQL2000 box with a trust error (I don't recall the exact message). I noticed that it fails when Enterprise Mgr is configured as: "Tools/Replication/Configure Publishing, Subscribers and Distribution", Subscriber Tab, "Impersonating SQL Service Agent". It works if I change to "SA".

This is only the case when we replicate from SQL7 to SQL2K. SQL7 to SQL7 works fine with "Impersonating". Has anybody seen this behavior? Any workarounds, other than using SA?

View 2 Replies View Related

Any Affect With Database If I Upgrade MS SQL7 To SQL2000 ?

Mar 17, 2001

Im using MS SQL7 as database software ,but now I plan to upgrate SQL7 to SQL2000 . I would like to know that are there any affect on the old database that already use with sql7 after I upgrade to MSSQL2000 ?

Thanks

View 1 Replies View Related

SQL7/SQL2000 Replication. Auth Error

Aug 12, 2002

I'm attemting to replicate from a SQL7 box to SQL2000.

The snapshot works fine, but it fails when it tries to push the subscription to the SQL2000 box with a trust error (I don't recall the exact message). I noticed that it fails when Enterprise Mgr is configured as: "Tools/Replication/Configure Publishing, Subscribers and Distribution", Subscriber Tab, "Impersonating SQL Service Agent". It works if I change to "SA".

This is only the case when we replicate from SQL7 to SQL2K. SQL7 to SQL7 works fine with "Impersonating". Has anybody seen this behavior? Any workarounds, other than using SA?

View 1 Replies View Related

Loading A SQL2000 Database To A SQL7 Server

May 30, 2001

Is there a way I can load a SQL2000 DB backup onto a SQL 7 server? Thanks.

View 1 Replies View Related

Migration From SQL 6.5 To SQL2000

Feb 8, 2001

We are beginning our research to migrate from our current SQL 6.5 and are wondering if we should migrate to SQL2000 rather than to SQL 7. First of all, is this possible or will we need to migrate to SQL 7 before migrating to SQL2000? Also where can I find good resources to learn more about the changes in SQL 7 as well as those in SQL 2000?

Any help would be appreciated.

Thanks!

View 1 Replies View Related

Query Runs On Sql7.0 But Keeps Running On Sql2000 Without Output

Aug 15, 2001

The following query runs fine on sql 7.0 but it kind of hangs/keeps running without any output on sql server 2000
---------------------
Set @cmd = 'Update ABCD Set
'+@day+'_LB = IsNull(LB,0),
'+@day+'_UT = IsNull(UNIT,0)
From tempData as T
Where T.STORE_NUM = ABCD.STORE_NUM And T.ITM_ID = ABCD.UPC'
execute (@cmd)
------------------------------------
But if we hard code the @day parameter and run the query like this it runs very fast on sql 2000....

Update ABCD Set THIRD_LB = IsNull(LB,0),
THIRD_UT = IsNull(UNIT,0)
From tempData as T
Where T.STORE_NUM = ABCD.STORE_NUM And T.ITM_ID = ABCD.UPC
------------------------------

View 2 Replies View Related

Old Excel Files After SQL2000 &&> SQL2005 Migration

Mar 27, 2006

Hello there!

We are having some problems over here after our SQL2005 upgrade.

If we try to use an excel file that previously accessed the SQL2000 database (same DSN name and credentials), and then try to refresh the data after the 2005 upgrade, we get the errormessage "[Microsoft][SQL Native Client][SQL Server]User 'DOMAINusername' does not have permission to run DBCC TRACEON."

We have tried to delete and recreate the DSN file.. Tried to use SA user instead (with offcourse full access)..

An even bigger problem is that we can not even get into msquery to copy the SQL query to make a new file, the same problem appears.

Please note that if we try to make a new external database query it works fine!

Any suggestions?

View 26 Replies View Related

Copy SQL7 To SQL7

Dec 5, 1998

How can I copy a SQL 7 database from one server to another? Please tell me all the ways because I've tried the obvious and it doesn't work. (backup and restore - won't go from one server to another, DTS transfer object Wizard - does a whole pile of errors and doesn't do stored proceedures and trigures). Thanks for help in advance. Also, what is the email address to post to the listserv and where is the FAQ for SQL7? Most of my listserv's tell you where to post right at the bottom of the digest I get - any chance you guys would do that with this list? Thanks again.

View 6 Replies View Related

Sql2000 && Sql2005, Want Localhost To Use Sql2000

Sep 17, 2006

 i have sql2000 & sql2005 on the same machine. I am unable to register my localhost in sql2000, get an access denied error. How can I make my localhost use sql2000 database?

View 1 Replies View Related

Migrate SQL2000 To SQL2000

May 13, 2008



i am in the process of Migrating SQL 2000 to my new SQL2000 server i want to know the what would the best way for me to migrate one SQL server to another SQL server on the same network and rename the new server to the old server and bring it up for use in our ecommerce website.

View 10 Replies View Related

SQL7 Ans SP2

Jul 16, 2000

Hi there,

After installing SP2 we encounter a problem with MMC. When selecting a DB we recieve a RunTime error? And the DB items/properties are not shown.
Is there anyone with the same problem and knows how to fix this? I search the MS site for more information but there is nothing on it.

Danny

View 1 Replies View Related

MS SQL7 & BO SQL7

Apr 17, 2000

Is MS SQL 7.0 have any difference/incompatibility problem with the BackOffice's SQL 7.0?

anybody can clarify this to me please... tq!

View 2 Replies View Related

SQL7.0 Installation On NT4.0

Feb 11, 2002

I am going to install SQL7.0 on the current NT4.0 with SQL6.5 on it by uninstalling SQL6.5 first and then installing (not upgrading through Wizard) SQL7.0.

Here are the questions I need help with:
1. Should I convert the database after the installation of SQL7.0 or directly restore the SQL6.5 databases backup?
2. If I need to convert the databases, How and in what way?
3. Which way is better upgrade or installation?

Thank you ahead of time

John

View 2 Replies View Related

SQL7 E-mail

Apr 2, 2001

I am looking for documentation/information on how to configure SQL7 so that I
can use SMTP for delivering e-mail.

I have other applications which use SMTP for delivering our e-mail.

I don't have Exchange. Internally we use GroupWise for our mail system.

Thanks in advance!!!

View 1 Replies View Related

SQL7.0 Running 100%

Jul 11, 2001

Current system 2 x 500mhz pIII 512MB ram, System mirrored and data raid 5 30GB made from 3 disks. All server is running in CA TNG. an Asset management DB and Software Delivery database. But the poor server runns most of the time at 100% 65% being used by SqlServer process. Does/Can anyone recommend any tweaks upgrades that may let the server take a breath in and out ie will more memory speed thing up faster processors or more disk.

Thanks

Nigel

View 4 Replies View Related

DTS AS/400 --> SQL7. How To Get Job Working

Sep 27, 2001

Hi,

i'm brand new in the sql server world so maby this is an easy problem.

I have to get data from AS/400 to SQL7. I've created a package with a client acces odbc driver and an sql driver which transfers the data of an entire table. When i execute this it works fine.

Now i want to shedule this (shedule package). When i start this job it doesn't work.


This is the error i get:

DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147008507 (80074005) Error string: Unspecified error Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 1100 Error Detail Records: Error: -2147008507 (80074005); Provider Error: 0 (0) Error string: Unspecified error Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 1100 Error: -2147467259 (80004005); Provider Error: 5 (5) Error string: [IBM][Client Access ODBC Driver (32-bit)][DB2/400 SQL]Communication link failure. COMM RC=0x5 Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 DTSRun OnFinish: DTSStep_DTSDataPumpTask_1 DTSRun: Package execution complete. Process Exit Code 1. The step failed.


on the server i've installed client access as well and created the same odbc driver (with the same name). But it still doesn't work.

Can anybody help me please??

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved