Hi All,
I am trying to import database from SQL7 to SQL2000 using the tool.
it looks normal but no SPs and Views and transfered and those not even in
the list when I run the transfer tool.
and idea?
TIA
Jerry QuJerry,
You have to make sure you check those objects or they won't be transferred.
If you want the whole database try restoring a full backup. It's easier and
cleaner.
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"Jerry Qu" <jqu@.capdex.com> wrote in message
news:OhQD9KpdEHA.3632@.TK2MSFTNGP09.phx.gbl...
> Hi All,
> I am trying to import database from SQL7 to SQL2000 using the tool.
> it looks normal but no SPs and Views and transfered and those not even in
> the list when I run the transfer tool.
> and idea?
>
> TIA
> Jerry Qu
>
No comments:
Post a Comment