Hello everyone, I want to transfer the data from one database to another database. But the structure of the databases is different. The data one table in the source database, has to be transfered to 3 to 4 tables in destination database. There are total 25 tables in source database & I have to transfer the data from all of them to destination database. I have written stored procedure to do this thing, but I want to know how to run them with two databses. The stored procedures are working fine if both the databases are same. For example the data in Company table in source DB , goes to CompanyMaster, CompanyAddress, CompanyInfo... in destination DB Source DB Company (Code,Name,Address1,Address2,City,State,Decription,noOfEmployees,domain) Destination DB CompanyMaster (Id, Name, domain) CompanyAddress (companyId,address1, address2, city, state) CompanyInfo (companyId, Decription, NoOfEmployees) The Stored procedure TransfterCompany transfers the data from Company to related tables. The stored procedure workds fine when the source and destination db is same. Now i have to make these two db saperate. How can I do that?