Converting MSDE 7 to SQL2000?

Hi All,
I am trying to upgrade a program that used MSDE 7 but now
migrating to SQL2000. I performed a tables & Views import
from one server to another however the program returns
errors when trying to intall its upgrade:
SQL Error Message from
CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE:
42S01 Native error: 2714 Message: There is already an
object named 'vMDSMap' in the database.
It looks like it has changed the format of the db during
the import. Has anyone successfully migrated from MSDE 7
to SQL2000?
Thanks
The simplest way I'd use is:
1. On the MSDE1.0 (SQL Server7, not MSDE 7) computer, detach the said
database.
2. Copy the *.mdf and *.ldf files to the SQL Server2000 computer.
3. Attach the files to SQL 2000.
"Andreas" <a_kaestel@.connexus.net.au> wrote in message
news:035901c4fa2a$7b9b9220$a501280a@.phx.gbl...
> Hi All,
> I am trying to upgrade a program that used MSDE 7 but now
> migrating to SQL2000. I performed a tables & Views import
> from one server to another however the program returns
> errors when trying to intall its upgrade:
> SQL Error Message from
> CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE:
> 42S01 Native error: 2714 Message: There is already an
> object named 'vMDSMap' in the database.
> It looks like it has changed the format of the db during
> the import. Has anyone successfully migrated from MSDE 7
> to SQL2000?
> Thanks