How to extract data from one database to another

**vijaii** · Sep 18 '07, 01:23 PM

Originally posted by reany

i want to get know about "How to extract data from one database to another".?

pls reply me as soon as possible.
thanks !

SELECT * FROM DatabaseName..T ableName

**amitpatel66** · Sep 18 '07, 01:49 PM

Originally posted by reany

i want to get know about "How to extract data from one database to another".?

pls reply me as soon as possible.
thanks !

You can create Database Link in case if you want to query the data from the table of another database.

**ck9663** · Sep 18 '07, 07:50 PM

Originally posted by reany

i want to get know about "How to extract data from one database to another".?

pls reply me as soon as possible.
thanks !

or do a DTS (import/export) in Enterprise Manager

Comment