Is it possible to perform Sql 7 Enterprise upgrade to Sql 200o Standard Editions

Hi all,

I was curious if there any issues that I need to be aware off in attempting to upgrade an existing client database (Sql Server 7 Enterprise Edition) to Sql 2000 Standard edition. During upgrades are we forced to stay with the same editions or can the upgrade to lower level editions.

Thanks
ZeidNot possible, you need to uninstall and re-install SE.
EE is far superior than SE by any means.

Is it necessary...

Is it necessary to upgrade SQL Server version 7 to 2000?
Real question is that 'What's new in version 2000 from
version 7?'
Q. Is it necessary to upgrade SQL Server version 7 to 2000?
A. No, you can install a separate "named instance" on the same server as you
have SQL Server 7.0 installed.
Q. Real question is that 'What's new in version 2000 from version 7?'
A. If you're interested in just what is new in SQL Server 2000 Full-text
Search (as this is the topic of this newsgroup), then the answer is "Change
Tracking" with "Update Index in Background" as well as the ability to FT
Index and FT Search MS Office file type (doc, xls, etc. plus html) stored in
Image datatype columns. If you have SQL Server 2000 installed, you should
review the BOL under Contents and "What's New" as there are many
improvements in SQL Server 2000 over SQL Server 2000.
Regards,
John
"Jerry" <anonymous@.discussions.microsoft.com> wrote in message
news:1a1ac01c41d87$a2193d10$a401280a@.phx.gbl...
> Is it necessary to upgrade SQL Server version 7 to 2000?
> Real question is that 'What's new in version 2000 from
> version 7?'

Is it easy to upgrade from MSDE to Full blown SQL v2000

Hi,

Noob here....

Got server running app approaching 2gig limit using MSDE version of SQL. I've purchased the full version and just checking if there is anymore to it than inserting the CD and letting it find the MSDE version and upgrade it.

Also, don't remember getting a keycode with the CD - is this right?

Thanks for help :)

Kenny

(bump)

anyone?

|||

I have gone from 2000 msde to 2000 developers edition and never had a problem.

Do a backup of your databases and give it a try.

|||

I wish I had the same easy experience. So far my upgrade from MSDE 2k to full SQL never gives me the "Upgrade" option. I have to install a new instance.

This is in the course of migrating a SharePoint Services installation from the default MSDE database to SQL.

As this test server had SharePoint portal uninstalled and SQL 2k developer uninstalled, then SharePoint Services by themselves re installed, I wonder if the install wizard just somehow does not see the MSDE instance.

My co workers think I am making this up.. Any ideas as to why no upgrade?

Is it easy to upgrade from MSDE to Full blown SQL v2000

Hi,

Noob here....

Got server running app approaching 2gig limit using MSDE version of SQL. I've purchased the full version and just checking if there is anymore to it than inserting the CD and letting it find the MSDE version and upgrade it.

Also, don't remember getting a keycode with the CD - is this right?

Thanks for help :)

Kenny

(bump)

anyone?

|||

I have gone from 2000 msde to 2000 developers edition and never had a problem.

Do a backup of your databases and give it a try.

|||

I wish I had the same easy experience. So far my upgrade from MSDE 2k to full SQL never gives me the "Upgrade" option. I have to install a new instance.

This is in the course of migrating a SharePoint Services installation from the default MSDE database to SQL.

As this test server had SharePoint portal uninstalled and SQL 2k developer uninstalled, then SharePoint Services by themselves re installed, I wonder if the install wizard just somehow does not see the MSDE instance.

My co workers think I am making this up.. Any ideas as to why no upgrade?

Is it easy to upgrade from MSDE to Full blown SQL v2000

Hi,

Noob here....

Got server running app approaching 2gig limit using MSDE version of SQL. I've purchased the full version and just checking if there is anymore to it than inserting the CD and letting it find the MSDE version and upgrade it.

Also, don't remember getting a keycode with the CD - is this right?

Thanks for help :)

Kenny

(bump)

anyone?

|||

I have gone from 2000 msde to 2000 developers edition and never had a problem.

Do a backup of your databases and give it a try.

|||

I wish I had the same easy experience. So far my upgrade from MSDE 2k to full SQL never gives me the "Upgrade" option. I have to install a new instance.

This is in the course of migrating a SharePoint Services installation from the default MSDE database to SQL.

As this test server had SharePoint portal uninstalled and SQL 2k developer uninstalled, then SharePoint Services by themselves re installed, I wonder if the install wizard just somehow does not see the MSDE instance.

My co workers think I am making this up.. Any ideas as to why no upgrade?