Import data from diferent vendors

Hello,

I have this kind of situation: I have Oracle database from an old application and i have to maje an job to copy it every day into an SQL Server 2005 database. The data should stay in both databases. Is this posible to do it with an job or i have to develop an service? If it is possibe i would like to know how. Is the same possible but from DB2 database to SQL Server 2005 database?

Thanks

Yes its possible. there are many method

(a) Create a linkedserver to Oracledatabase and copy the data : Read Linkedserver In BOL(Books online)

(b) Create a SSIS (Integration Service) package to migrate the data.

(c) Openddatasource

alll these can be scheduled though a job

Madhu

|||

can same be done with DB2 database instead of oracle?

|||

yes it can be done. only the provider changes..

Madhu

Import Cobol files

Hi all,
I have a customer that needs to transform his old Cobol app into a VB or ASP
app.
I'm stuck here with his product listings that are all in .cob (cobol) files,
how can I import those into SQL or Excell ?
Thanks for your help
ManuYou cannot.
You will need a tool that translates the COBOL commands into VB or ASP.
There are a few companies out there that have that kind of a tool set you
might look at www.californiasoftware.com
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"Emmanuel Baeyens" <emmanuel.baeyens@.microplanet.be> wrote in message
news:ud3ZonlcEHA.4092@.TK2MSFTNGP10.phx.gbl...
> Hi all,
> I have a customer that needs to transform his old Cobol app into a VB or
ASP
> app.
> I'm stuck here with his product listings that are all in .cob (cobol)
files,
> how can I import those into SQL or Excell ?
> Thanks for your help
> Manu
>

Import Cobol files

Hi all,
I have a customer that needs to transform his old Cobol app into a VB or ASP
app.
I'm stuck here with his product listings that are all in .cob (cobol) files,
how can I import those into SQL or Excell ?
Thanks for your help
Manu
You cannot.
You will need a tool that translates the COBOL commands into VB or ASP.
There are a few companies out there that have that kind of a tool set you
might look at www.californiasoftware.com
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"Emmanuel Baeyens" <emmanuel.baeyens@.microplanet.be> wrote in message
news:ud3ZonlcEHA.4092@.TK2MSFTNGP10.phx.gbl...
> Hi all,
> I have a customer that needs to transform his old Cobol app into a VB or
ASP
> app.
> I'm stuck here with his product listings that are all in .cob (cobol)
files,
> how can I import those into SQL or Excell ?
> Thanks for your help
> Manu
>