hi

how to populate one databse from another databsase..the schema of both databse is not same...

plz tell how to achieve this using procedures

You can do this several ways but I'd link the two servers and then use select statements  from the linked database to populate your tables.

You can use SSIS and use a data flow task to populate from one database to another if you do not have the option of Linked Servers.

Actually, while both previous responses are in part correct, you need to provide more in the way of what you want to populate across databases - what objects?

users and permissions?

tables and data?

triggers?

Databases contain a whole host of objects, some are easier than others to move across.

 

What exactly do you want to do?