1

I want to create a windows application in C# and SQL Server, these have two databases one is in local another one in remote. I have 2 doubts:

  1. Is possible to connect remote SQL Server in windows application?
  2. Some time Internet may be not available (may be chance). This time I cannot fetch and store data in remote server, my application not running that time,how can avoid this situation? Full data available remote server, partial database only in local SQL Server please share ideas to me.
Improve this question

1 Answer 1

Reset to default
1

is possible to connect remote sql server in windows application?

Yes. Provided if remote connection in SQL Server is enabled. See How to enable remote connections in SQL

Some time Internet may be not available (may be chance).This time I cannot fetch and store data in remote server , my application not running that time,how can avoid this situation?

Check for connection to your server or catch exception to see if server is unavailable. Write the data on your local server or local XML file and then implement sync logic when ever your server becomes available

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

please give ideas about sync logic , using xml

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.