Re: Loading 2000 Standard DB into 2005 Workgroups?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

It generally works just fine but as with any upgrade, run the upgrade
advisor to ensure you don't have any objects in your 2000 database that will
have problems in 2005 (eg. customer sprocs, xprocs, etc...).

Btw, you can just do an upgrade in place if you like. No need for multi-step
effort. See
http://www.microsoft.com/technet/prodtechnol/sql/2005/library/gettingstarted.mspx
for lots of good info on getting started with SS2K5.


joe.

"Wes" <Wes@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:20B44036-384E-422E-B3AB-ADAF343C8BAB@xxxxxxxxxxxxxxxx
Hi there,

We are currently using SQL Server 2000 Standard and would like to change
to
SQL Server 2005 Workgroup. Now I assume I backup the database, uninstall
2000, install 2005 Workgroup and then import the backup.

However, what I don't know is how well importing a database that was
created
in 2000 Standard will work. Anyone have any experience with this or
thoughts
on the subject?

Thanks,

Wes


.

Relevant Pages

  • Re: [opensuse] From 11.0 to 11.1
    ... Upgrade or reinstall? ... New install. ... Backup the Backup (i.e. do at least one backup by a different means ... Database info ideally should be dumped with the relevant database ...
    (SuSE)
  • Visual C++ 6.0 - Article!!!!!!!
    ... as the Enterprise Edition installer ... Studio 97 process. ... Don't let source safe 6.0 upgrade a shared database until everyone ...
    (microsoft.public.vc.mfc)
  • Re: Workgroup MS Access 2003 Windows XP
    ... > Our company computers were recently upgraded to Windows XP with Microsoft ... > on our network) which all require the user to be part of a "Workgroup". ... > corresponding to the database. ... I am surprised you didn't have to do this before the upgrade. ...
    (microsoft.public.access.security)
  • Re: add field to back-end existing table
    ... The ideal scenario is that all users have shortcuts to a Front-End Database ... of the program and its purpose: "Ticket Control Database version 5 Upgrade" ... Dim dbname as string 'Ticket Control Pathfilename ... Sub OpenAndLockDatabase() ...
    (microsoft.public.access.tablesdbdesign)
  • Re: SQL CE 3 and CF 1.0 support
    ... > We have designed our application so that all data access logic is ... > using our automated upgrade mechanism and at the same time upgrade the ... > from the engine download and the database upgrade delay). ... > I also know of applications that have been using SQL CE databases in RAM ...
    (microsoft.public.sqlserver.ce)