|
Home > Archive > MS SQL Server > May 2005 > Help with moving database from SQL 7 to SQL 2000
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Help with moving database from SQL 7 to SQL 2000
|
|
| SQL Newbie 2005-05-31, 8:23 pm |
| 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!
| |
| SkyWalker 2005-05-31, 8:23 pm |
| 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 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!
|
|
|
|
|