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/defaul...;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 w
ay
> I did it was copy the .mdf and .ldf files over to SQL 2000. Both SQL serve
rs
> 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 w
ay
> to do it.
> Could you someone recommend what is the proper way to move the database ov
er
> from SQL 7 to SQL 2000 while maintaining all the data?
> Thanks in advance!
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment