BCP from SQL server 2k to Solaris operating System

Question

Post reply

BCP from SQL server 2k to Solaris operating System

Mast

Valued Member

Points: 58
More actions
September 1, 2010 at 11:22 am

#74309

Friends, I need to ur help. I need to export tables from SQL server to Solaris server for UDB move. Can I do that using bcp utility. How can I pass the credential for Solaris operating system to connect & place file there. I am using trusted connection in SQL server.
Thanks for your help in advance.
Regards
-Mast

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

alen teplitsky SSC-Dedicated Points: 30014 More actions · Answer 1

alen teplitsky

SSC-Dedicated

Points: 30014

September 2, 2010 at 10:12 am

#1215731

which database on solaris?

steve block SSCertifiable Points: 7698 More actions · Answer 2

We used to us dbschema to unload data from an Informix database on Solaris, ftp to move it to the Windows Server, and bcp to load it into Sql Server (had to set certain flags for bcp to load it correctly). I would guess you would need to do the opposite: unload the data with bcp, ftp it to the Solaris machine, and use what ever utility your database uses to load it in.

You would need to put the commands into a script (powershell, vb console app, etc.) to perform the work.

If your destination database works with it, you could check into replication (it uses bcp behind the curtain). I've read that is works with Oracle.

Steve

Lowell SSC Guru Points: 323518 More actions · Answer 3

another option is that SSIS can migrate data both to-and-from SQL to another data source....all you need is an ODBC connection.

you could set up a package with the import/export wizard and save it if it is a regular thing.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Steve Jones - SSC Editor SSC Guru Points: 736494 More actions · Answer 4

In addition to the other notes, if you have file system access from the Windows server, you can bcp out (or SSIS export) the data to a file that you move to the Solaris machine.

steve block SSCertifiable Points: 7698 More actions · Answer 5

Now that my memory has been jogged, we did use DTS (for runner to SSIS) with an ODBC driver to move data from Informix to Sql Server before we migrated and from Sql Server to Informix after we migrated.

The bcp that we used first was run from Perl scripts that were sceduled. We had a Schedule on the Solaris side and a seperate one on the Windows side. We just had to make sure that the schedule on one machine was done before the other one was run. You could probably make sure (within the script) that a certain file exists before processing continues.

Steve