crystalized
Programmer
Well I don't know if anyone can help me with this problem, but I sure hope so.
We started out with an evaluation version of SQL 7. I completed a bunch of development including a database (tables, diagrams, and stored procedures).
Then the trial version of 7 ran out and we purchased SQL 2000 standard edition. Following the instructions on the microsoft(for conversion from 7 evaluation edition to 7 standard) I copied all the files from the data folder to another location. I then unistalled the evaluation version and installed 2000 setting the data location the same as it was with the evaluation version of 7. However the data location is not the same even though I set it to be the same in the installation 2000 adds a directory level in between the two.
So where I had MSSQL7--Data
I now have MSSQL7--MSSQL--Data
And even after I copy my database files into the Data file the database is not visible in the Enterprise Manager tool. I am about to try running a script that is supposed to make database diagrams from earlier tools accessible to the 2000 tools. I don't hold out a lot of hope for that since it is not just the diagrams that don't show, the whole database is not visible.
If anyone has any suggestions I might take to resolve this issue I would really appreciate it.
Crystal
crystals@genesis.sk.ca
--------------------------------------------------
Experience is one thing you can't get for nothing.
-Oscar Wilde
We started out with an evaluation version of SQL 7. I completed a bunch of development including a database (tables, diagrams, and stored procedures).
Then the trial version of 7 ran out and we purchased SQL 2000 standard edition. Following the instructions on the microsoft(for conversion from 7 evaluation edition to 7 standard) I copied all the files from the data folder to another location. I then unistalled the evaluation version and installed 2000 setting the data location the same as it was with the evaluation version of 7. However the data location is not the same even though I set it to be the same in the installation 2000 adds a directory level in between the two.
So where I had MSSQL7--Data
I now have MSSQL7--MSSQL--Data
And even after I copy my database files into the Data file the database is not visible in the Enterprise Manager tool. I am about to try running a script that is supposed to make database diagrams from earlier tools accessible to the 2000 tools. I don't hold out a lot of hope for that since it is not just the diagrams that don't show, the whole database is not visible.
If anyone has any suggestions I might take to resolve this issue I would really appreciate it.
Crystal
crystals@genesis.sk.ca
--------------------------------------------------
Experience is one thing you can't get for nothing.
-Oscar Wilde