|
|
Posted by time management on 11/21/07 04:17
On Nov 20, 5:31 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> time management (tatata9...@gmail.com) writes:
> > Thanks for the follow-up, Erland. I tried to attach it with sql
> > server 2005 as well, the restored db seemed weired with "D:\aName
> > \blakdsm\blad..", empty, not workable. Now, suppose I can get a
> > clean/good copy for server 2005, what are the chances of success of
> > using DUMB database then BACKUP or LOAD back into server 2000? These
> > two boxes are not connected and they can't.
>
> If you need to move a database from SQL 2005 to SQL 2000 you need to
> create from scripts and copy data to file with bulk copy. If the database
> uses features that do not exist in SQL 2000, you will have to make some
> compromises.
>
> You cannot restore a backup from SQL 2005 on SQL 2000. For quite obvious
> reasons: there are features in SQl 2005 for which SQL 2000 is not prepared.
>
> --
> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Thanks, Erland, bcp is clumsy or because I'm not an expert of it :)
Viable options for the task all seem to consume quite a bit of time
but hey got to do the job. Once again I appreciate it.
Don
Navigation:
[Reply to this message]
|