I have two database. First database name "DB1" and second one's name is "DB2". These database have same tables, Beside that ,All of the properties is same.I want to take some of information from one table or more tables in DB1, than ,I want to put these information into the "DB2"

INSERT INTO DB2.dbo.Company(DB2.dbo.Company.Name, DB2.dbo.Company.Number,...) SELECT DB1.dbo.Company.Name, DB1.dbo.Company.Number,... FROM DB1.dbo.Company,.. Where ...

how can i do same work by using llblgen ?

thank you...

Create entitity and read from first database, then pass that to an adapter that is connected to the second database and save it. I'm in the middle of doing this right now with two databases on different machines, passing the entity using .NET remoting.

thank you jim