|
|
Posted by Erwin Moller on 07/20/07 12:30
Erland Sommarskog schreef:
> Erwin Moller (since_humans_read_this_I_am_spammed_too_much@spamyourself.com)
> writes:
>> 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?
>
> You would have to build the database on SQL 7 from scripts, and move the
> data with bulk load. I don't know you did the import in the other direction,
> but going to a higher version it's possible by backup/restore or simply
> attaching the database to the higher version. Going to a lower version
> this is not possibe.
>
>> Or should I download Microsoft SQL Server Express and use that instead
>> of my MSSQL7? Is it better?
>
> Well, SQL 7 came out in 1998, SQL Express in 2005, so there are some
> more features. But there are also some things that don't really work
> as in SQL 7. For instance the old-style join *= is available only
> in compatibility level 80 and lower.
>
> Nevertheless, I would recommend going to SQL 2005 if possible.
Hi Erland,
Thanks for your answers.
I think I'll switch to SQL Express 2005.
One last question: If I switch to SQL Express 2005, do you expect that I
can copy the database from MSSQL2000 to SQL Express 2005 without scripts
and bulk data load?
Regards,
Erwin Moller
Navigation:
[Reply to this message]
|