Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Problem of Importing Database

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-12-17 : 06:42:39
hardik_1315 writes "Hello,
I m using SQL server.
I have a database on a Server & I can access that database
using FTP.. I have usename, pwd & IP addr. to access that
database.
Now I want to Import that database to the SQL server which I m using locally..

Could u plz help me out..

I must be able to see the complete database on my "SQL Enterprise
Manager" which is on local computer with all the tables & the
data that is present on that Server.

Thankyou,

Waiting for your reply"

igorblackbelt
Constraint Violating Yak Guru

407 Posts

Posted - 2004-12-17 : 12:41:17
More details, you have a Database in which format?
How big?
What OS and SQL server?
Why don't you copy this DB locally and work from there?

I Love Challenges! That's why I love coding!
Go to Top of Page

Hyukevain
Yak Posting Veteran

66 Posts

Posted - 2004-12-24 : 11:31:40
In Enterprise manager, choose new server registration, enter the ip address, userid and password... and now you can see the remote server content in your enterprise manager.
Go to Top of Page
   

- Advertisement -