[Cutt3r]

You'll have to attach Database X with Database Y using the Attach command, then run the appropriate Insert Into commands for the tables you want to transfer.

Quote:

INSERT INTO X.TABLE(Id, Value) SELECT * FROM Y.TABLE;

source