Posted by Erwin Moller on 07/19/07 12:24

Hi Group,

I developed a intranet site using MSSQL7/win2000 some time ago.
The target environment used MSSQL2000/8.
We were (almost painlessly) able to import the db-scheme and data from 7
to 8. (Bravo MSSQL)

Now I need to do some upgrading on the application and I would like to
have a copy of the database from MSSQL2000/8 to MSSQL7.
Is that also possible?

Or should I download Microsoft SQL Server Express and use that instead
of my MSSQL7? Is it better?

I hope I can get the relationsheet too (that one with Foreign Keys
mapped in a nice graphical way).

Any advise highly appreciated.
I am good with Postgresql, but my MSSQL skills leave a lot to be
desired. :-/
For an outsider like me the many versions and OS's are quite confusing.

Do I need special commands on MSSQL2000/8 to create a MSSQL7 compatible
export?

Thanks in advance!

Regards,
Erwin Moller

• Next in forum: DSN-less connection
• Prev in forum: default value being a concatenation of other columns
• Thread view: Import from MSSQL2000 (8) to 7?

[Reply to this message]