Monday, February 27, 2012

Help with moving database from SQL 7 to SQL 2000

Hello. I'm having problems moving a database from SQL 7 to SQL 2000. The way
I did it was copy the .mdf and .ldf files over to SQL 2000. Both SQL servers
are using different computer names. But I'm missing some views, stored
procedures, jobs, and user accounts. I'm assuming this must be the wrong way
to do it.
Could you someone recommend what is the proper way to move the database over
from SQL 7 to SQL 2000 while maintaining all the data?
Thanks in advance!
Please check this article:
http://support.microsoft.com/default...en-us;314546#2
It contain detail information on how to move DBs, logins, etc.
Regards.
"SQL Newbie" wrote:

> Hello. I'm having problems moving a database from SQL 7 to SQL 2000. The way
> I did it was copy the .mdf and .ldf files over to SQL 2000. Both SQL servers
> are using different computer names. But I'm missing some views, stored
> procedures, jobs, and user accounts. I'm assuming this must be the wrong way
> to do it.
> Could you someone recommend what is the proper way to move the database over
> from SQL 7 to SQL 2000 while maintaining all the data?
> Thanks in advance!

No comments:

Post a Comment