I have done so for SQL Server, now I was trying to do it SQL Server Compact.
I am unable to make a connection string in SQL Server Compact which has the provision for providing ip/server.
Try Replicating Data to a remote server. http://msdn.microsoft.com/en-us/library/ms152568(v=sql.105).aspx