Export data

hi friends,
i have a table experts in the the database abc and the same table in the
database xyz. in the table database xyz its the parent table and it is
referenced by some other tables, but in the database abc there are no
constraints. now i want to export data of the table experts from the the
database abc to xyz.
how to achieve this without disturbing the structure.
thanks
vanithaVanitha
Use xyz
INSERT INTO Experts (column lists) SELECT <column lists> FROM
abs.dbo.Experts WHERE ................
"Vanitha" <Vanitha@.discussions.microsoft.com> wrote in message
news:BB502DD4-2A6A-4CC5-B2FC-9454D7F4514C@.microsoft.com...
> hi friends,
> i have a table experts in the the database abc and the same table in the
> database xyz. in the table database xyz its the parent table and it is
> referenced by some other tables, but in the database abc there are no
> constraints. now i want to export data of the table experts from the the
> database abc to xyz.
> how to achieve this without disturbing the structure.
> thanks
> vanitha|||Try www.sqlscriper.com to export your data.
Its free
"Vanitha" wrote:

> hi friends,
> i have a table experts in the the database abc and the same table in the
> database xyz. in the table database xyz its the parent table and it is
> referenced by some other tables, but in the database abc there are no
> constraints. now i want to export data of the table experts from the the
> database abc to xyz.
> how to achieve this without disturbing the structure.
> thanks
> vanitha