| Username |
Post |
| cybergal |
Posted
on 12-Feb-02 11:43 AM
Hi,
I am trying to import database (MS SQL 2000) from a remote server. I have about 15 stored procedures along with some tables. The stored procedures don't get imported ....I am able to import only the tables??? Why??
Can anyone provide some info on it??
Thanks in advance.
cybergal ;)
|
| Reema. |
Posted
on 12-Feb-02 07:14 PM
Did you get any error messages?
|
| Jange |
Posted
on 12-Feb-02 07:24 PM
1. If you want to import whole database from one SQL server to another in LAN, try backing up the database of source server and restore it to the target server. You have to resolve users and role permissions after the restoration.
2. If you want to copy certain objects and data including sprocs from one server database to another server database, use DTS with options to copy all objects and data between SQL server databases (3rd option in DTS import/export wizard).
Hope this helps.
Jange
USA
|
| Maneet Dhungel |
Posted
on 12-Feb-02 09:41 PM
Another way to approach this, especially if your Db is large and you want to do a full import of the database plus objects, is to do use a backup of the source database and use the "Restore from File" option to recover the Database in the destination server. This is pretty useful if your LAN /WAN has bandwith issues and you have the ability to easily move the physical backup files.
|
| Kancho |
Posted
on 13-Feb-02 12:05 PM
Doesn't "detach" and "attach" works to move the SQL data plus the store proc?
I think it deos.
|
