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




MS Sql Server LazyDBA home page