Re: How to export SQL tables using Internet connection
From: Hari (hari_prasad_k_at_hotmail.com)
Date: 04/21/04
- Next message: t: "t"
- Previous message: r: "rr"
- In reply to: Rajaa: "How to export SQL tables using Internet connection"
- Next in thread: Rajaa: "Re: How to export SQL tables using Internet connection"
- Reply: Rajaa: "Re: How to export SQL tables using Internet connection"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 21 Apr 2004 18:00:47 +0530
Hi,
In your client machine you can create a alias to the server using Client
network utilty specfying the protocol as TCP/IP. Along with this you have to
mention the IP address and Port in whcih sql server is installed.
For default instance port will be 1433.
Export:
Using this alis name you can use BCP OUT and BCP IN or use DTS to export and
Import the data between SQL Tables
Thanks
Hari
MCDBA
"Rajaa" <anonymous@discussions.microsoft.com> wrote in message
news:215a01c42798$c399df10$a101280a@phx.gbl...
> Hi
>
> Would you plz show me how can I export table from SQL to
> SQL thorugh TCP/IP
>
> Thanks
- Next message: t: "t"
- Previous message: r: "rr"
- In reply to: Rajaa: "How to export SQL tables using Internet connection"
- Next in thread: Rajaa: "Re: How to export SQL tables using Internet connection"
- Reply: Rajaa: "Re: How to export SQL tables using Internet connection"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
