Importing data into SQL using BCP

Hello,
I have a question regarding importing data into ms sql using BCP. Can
I use BCP to load data into my sql tables, if the database I am pulling
from is at a remote location? How would I do that?
Does the database at the remote location have to be SQL, or can it be
MySQL too?
Thanks for your input.
G-> I have a question regarding importing data into ms sql using BCP. Can
> I use BCP to load data into my sql tables, if the database I am pulling
> from is at a remote location? How would I do that?
BCP can load data from a file into a SQL Server table or copy data from a
SQL Server table to a file. The table/file can be local or remote but only
Microsoft SQL Server tables are supported. You'll need to use DTS/SSIS for
other types of databases.
Hope this helps.
Dan Guzman
SQL Server MVP
"InterActionCRMGuru" <leadtank@.gmail.com> wrote in message
news:1169084293.977520.191810@.11g2000cwr.googlegroups.com...
> Hello,
> I have a question regarding importing data into ms sql using BCP. Can
> I use BCP to load data into my sql tables, if the database I am pulling
> from is at a remote location? How would I do that?
> Does the database at the remote location have to be SQL, or can it be
> mysql too?
> Thanks for your input.
> G-
>|||Dan Guzman wrote:
> BCP can load data from a file into a SQL Server table or copy data from a
> SQL Server table to a file. The table/file can be local or remote but onl
y
> Microsoft SQL Server tables are supported. You'll need to use DTS/SSIS fo
r
> other types of databases.
>
Thanks, Dan. One last question, Can I use BCP to copy data from a
remote SQL server table, directly to my SQL server table?|||> Thanks, Dan. One last question, Can I use BCP to copy data from a
> remote SQL server table, directly to my SQL server table?
BCP (and BULK INSERT) requires file in/out. DTS/SSIS can copy directly from
table to table, including non-SQL Server tables.
Hope this helps.
Dan Guzman
SQL Server MVP
"InterActionCRMGuru" <leadtank@.gmail.com> wrote in message
news:1169087975.361441.131140@.38g2000cwa.googlegroups.com...
> Dan Guzman wrote:
> Thanks, Dan. One last question, Can I use BCP to copy data from a
> remote SQL server table, directly to my SQL server table?
>