hi

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

pls reply me as soon as possible.
thanks !

Quote:

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..TableName|||

Quote:

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.|||

Quote:

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