Hi guys i want to copy all data only not objects from one sql server 2005 database to another
sql server database 2005 but two databases are located in different locations meaning not in same network.all objects in two databases are same but different only in data. which best solution to take data only from one branch to main branch

Hello Ahmed,
I understand you cannot create a linked server between two SQL Server database instances.
Did you try creating SQL Insert statements for data that is stored in source database table?
Creating a insert script can be a solution of course data is not too big.

An other dummy solution can be creating a new database, copying source table into new database.
Then you can attach database in the target SQL Server instance and compare these two database objects using T-SQL or third party tools like xSQL Data Compare