Should this be possible


TYIA

Wind is your friend
Matt

__________________
Wind is your friend
Matt

I don't think so. There are many backwards incompatibilities between 7 and 2000.

However, you could restore the database to a 2000 server, and then use DTS to transfer (selected) data from 2000 to 7.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Good day Imar

My 'issue' in a bit more detail - your opinion would be great.

Localy we run 2000. We have built a system that is to be used in a network where Enterprize Manager is not allowed (A new defence security issue - not even on servers). I have been asked to create a step by step doc including scripts that allows them to create, restore (from my 2000 .bak file), create login, user, issue read, write etc using query analyzer. They are telling me my scripts dont work. We were not told they were running version 7.0 until after i wrote and sent the doc.

Are you aware if the following scripts will run in version 7.0's Query Analyzer?

2..CREATE DATABASE NavSysCom;

3..RESTORE DATABASE navSysCom
   FROM DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL\backUp\navSysCom.bak' WITH
   move 'navSysCom_Data' TO 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\navSysCom_Data.mdf',
   move 'navSysCom_log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\navSysCom_log.ldf';

4..EXEC sp_addlogin 'NavSysComUser', 'password', 'NavSysCom', 'english';

5..EXEC sp_adduser 'NavSysComUser';
   sp_addRoleMember 'db_datareader','NavSysComUser';
   sp_addRoleMember 'db_datawriter','NavSysComUser';

Appreciate your time

Wind is your friend
Matt

I think the scripts will run fine. Stuff like CREATE DATABASE NavSysCom works on Sql 7 as well.

However, restoring a 2000 database to Sql 7 won't work.

Are you just interested in the meta data (structure) or also in the actual data in the database?

If all you need is the structure, you can script the entire database and then run that script on the server.

If you need the database as well, I guess you'll need to install Sql 7 on your machine, transfer data using DTS from 2000 to 7 and them create a backup of the Sql 7 installation.....

Cheers,

Imar

Sorry for the delayed response, we are a world appart here in Australia. I wasnt so keen to instal 7.0 on my machine, would this be trouble free running both versions?

I have another machine for the day and plan to instal 7.0 - hopefully I can do this between machines. Spent most of yesturday just finding the 7.0 disk.

;;;Are you just interested in the meta data (structure) or also in the actual data in the database?
The lot - Tables, data and if possible the diagrams - whats my chances of getting the diagrams? The code police within defence get upset when relationships are not enforced and diagrams present.

Thanking you Imar

Wind is your friend
Matt

I *think* you can install 2000 after 7 because 2000 works with instances, so you could install it as (local)\InstanceName

However, I don't think you can install 7 after 2000, so you might need to uninstall 7 first, or use a clean machine and then transfer the data.

You can transfer diagrams with DTS. However, diagrams are nothing more than a view on your database. Relations between tables *are* transferred with DTS, so after the transfer you can create a new diagram, select a tables and then you'll end up with 1 diagram of your complete database with all the relations....


Cheers,

Imar

I ended up installing 7.0 on a clean machine and DTS'ed the data. An interesting problem aroze. I would have thought you could DTS from the 2000 Enterprize Manager (export) to the 7.0 instance - no joy. It worked the other way round however none of my primary keys came through, datatypes yes - Thank you for your time.

Wind is your friend
Matt

Matt, did you try the standard Import / Export? That's supposed to work between 7 and 2000.....

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

No I didnt - I figured DTS was the way to go - I replaced all the primary keys and made it work - Cheers for your input.

Wind is your friend
Matt

You're welcome. Sorry if I put you on the wrong track with DTS.....

Imar