It is possible with a few glitches. First, if you have objects (tables, stored procedures, functions, views) in one database which have the same names as the objects in the other databases, you would have to rename them inorder for you to be able to merge them. Second, you will have to change your application code in order for them to work properly as they now will be connecting to a different database instead of the original one.