Hi,
I feel extracting data from oracle and FTPing it to SQL Server is long
process. Instead of this you can go with DATABASE LINK.
Create a database link ,access the remote DB and compare the two tables by
using this DB link.
Hope it will be useful.
Thanks,
ViSolve DB Team
----- Original Message -----
From: "NewsGroup " <mssqldba-ezmlmshield-x76313714.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Sunday, December 24, 2006 12:18 AM
Subject: Exporting data from Oracle and Sybase to Text file and loading it
into MS SQL 2005
> Hi DBA Gurus
>
>
>
> I need to create a utility to compare two tables SQL Server 2005 and maybe
> .net, seems the easiest and best approach to achieve this is:
>
>
>
> Extract Data from Oracle or Sybase
>
> FTP to SQL Server 2005
>
> Use the SSIS to load and run the logic etc?
>
>
>
> Please can you advise me if this is the best method and also which
> commands
> I need to use to extract the data in the first place?
>
>
>
> Is there a BCP utility (similar) in oracle and Sybase and where would I
> get
> more information about using them?
>
>
>
> Thank you
>
>
>
> j
>
>
>
>
>
>
>
>
>
> On Behalf of prisoft.co.uk
>
>
>
> Notice of Confidentiality
>
> This e-mail (and its attachment(s) if any) is intended for the named
> addressee(s) only. It contains information which may be confidential and
> which may also be privileged. Unless you are the named addressee (or
> authorised to receive it for the addressee) you may not read, copy or use
> it, or disclose it to anyone else. Unauthorised use, copying or
> disclosure
> is strictly prohibited and may be unlawful.
>
>
>
> If you have received this transmission in error please contact the sender
> immediately
>
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.409 / Virus Database: 268.15.27/602 - Release Date:
> 12/25/2006
>
>
MS Sql Server LazyDBA home page