Click here to Skip to main content
15,900,461 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Is there any possibility of sharing single SQL for two systems without a network connecction

What I have tried:

i have no idea of what to do as it is network related
Posted
Updated 3-Aug-17 4:04am

Let's take a step back and analyze the problem you are having. You have two systems and both need to share "SQL" as you put it. I'm going to assume that you mean you have two systems that both need to access the same database. If this is the case, what you are really need to do is setup a central location for the SQL database and have both systems or application simply access them.

Now the next part of your problem was "without network connection". Based on the comments in the previous solution, I'm going to assume that the applications or systems in question are located at different physical locations with no direct access via a local area network (LAN) connection. You mentioned using the internet and a static IP address, so this tells me that they are accessible via a world area network (WAN), also know as the internet. With that said, you have a few options here and I'll start with the worse and move to the ideal.

First option, manually move the data around. As Mehdi Gholam stated, this is flat out a bad idea and so we won't entertain it any more then stating it as an option.

Second option is to publicly expose the databases to the internet and use some sort of data replication. This opens you up to so many security concerns and risks, we'll simply just stop talking about it.

Third option is to create a web service (XML or RESTFUL) that is publicly accessible at each location. It's sole purpose is to replicate data between the two sites. This is certainly doable but it involves a great deal of work and careful planning to ensure security and data integrity. There are many frameworks out there that can assist with this, but you will need to do a lot of Googling, reading and careful planning.

The fourth option is to go with a hosted database solution such as Azure SQL Database or Amazon RDS. This is obviously going to cost money, but this honestly would be the ideal and safest solution for you. There is a lot of materiel on the web that can help you achieve this, just have to be prepared to do a lot of Googling and reading.

On a side note, I strongly recommend you work on your networking skills. You don't need to be an expert at networks, but a basic understanding of them will go a long way in helping you out with this problem.
 
Share this answer
 
You can't share without a connection, and even disconnected syncing data will require manual copying and determining what changed.

All of this is not advised, and is very difficult manually.
 
Share this answer
 
Comments
fakeer muhammed 31-Jul-17 6:24am    
can we share through internet
Mehdi Gholam 31-Jul-17 6:26am    
Internet **is** a network connection, so yes.
fakeer muhammed 31-Jul-17 6:39am    
can u tell e how to do it
Mehdi Gholam 31-Jul-17 6:42am    
You require the SQL Server machine be visible to the clients, like in a normal network, however making the server visible over the internet without security measures is not advised.
fakeer muhammed 31-Jul-17 7:00am    
i have a scenario that client have a laptop and a desktop.Desktop will be in the office.He need a software so that he need to work in software with his laptop also.How to do this

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900