SQL 7 to SQL 2005 migration issue.  
Author Message
EverlastBagger





PostPosted: Mon Mar 26 04:06:01 CDT 2007 Top

SQL Server >> SQL 7 to SQL 2005 migration issue.

I tried to move a SQL Server 6.5 db to SQL 2005. The approach that I
followed was:

1. Moved my database to SQL 7.0

2. Detached the now 7.0 database, moved the physical mdf file to the
location of new server

3. Attached the db to 2005 server.

The problem now is, I am unable to browse the db objects in the
studio. It doesnt show a "+" next to the newly migrated database.
While i can see that for all other pre installed Databases.

Thanks

Jay

SQL Server179  
 
 
M





PostPosted: Mon Mar 26 04:06:01 CDT 2007 Top

SQL Server >> SQL 7 to SQL 2005 migration issue.
> I tried to move a SQL Server 6.5 db to SQL 2005. The approach that I
> followed was:
>
> 1. Moved my database to SQL 7.0
>
> 2. Detached the now 7.0 database, moved the physical mdf file to the
> location of new server
>
> 3. Attached the db to 2005 server.
>
> The problem now is, I am unable to browse the db objects in the
> studio. It doesnt show a "+" next to the newly migrated database.
> While i can see that for all other pre installed Databases.
>
> Thanks
>
> Jay

Are you sure attach went without any issue ? Try to refresh and
check .
Also check select * from sys.databases if your database is there ?


 
 
jbellnewsposts





PostPosted: Tue Mar 27 20:05:32 CDT 2007 Top

SQL Server >> SQL 7 to SQL 2005 migration issue. Hi



> I tried to move a SQL Server 6.5 db to SQL 2005. The approach that I
> followed was:
>
> 1. Moved my database to SQL 7.0
>
> 2. Detached the now 7.0 database, moved the physical mdf file to the
> location of new server
>
> 3. Attached the db to 2005 server.
>
> The problem now is, I am unable to browse the db objects in the
> studio. It doesnt show a "+" next to the newly migrated database.
> While i can see that for all other pre installed Databases.
>
> Thanks
>
> Jay

Did you run the migration advisor against the SQL 7.0 database
http://www.microsoft.com/downloads/details.aspx?FamilyID=1470E86B-7E05-4322-A677-95AB44F12D75&displaylang=en

John