connection of mssql 2008 to cloud in windows form application
-
Hey.. I am developing an windows form application using ms sql server 2008. and i want to connect my sql server to cloud at internet to use it as backup. if there is any changes made bu application in local server then it should be reflected on cloud also. and if there is any loss of data at local server then it should get backup automatically from cloud. Can someone help me in this please.. ??
-
Hey.. I am developing an windows form application using ms sql server 2008. and i want to connect my sql server to cloud at internet to use it as backup. if there is any changes made bu application in local server then it should be reflected on cloud also. and if there is any loss of data at local server then it should get backup automatically from cloud. Can someone help me in this please.. ??
KUNWAR999 wrote:
Can someone help me in this please.. ??
The cloud provider I bet. You need to have rights on their server, I don't know if the give you access for your server to connect to their, but if they do, they can tell you more about.
------------------------------ Author of Primary ROleplaying SysTem How do I take my coffee? Black as midnight on a moonless night. War doesn't determine who's right. War determines who's left.
-
KUNWAR999 wrote:
Can someone help me in this please.. ??
The cloud provider I bet. You need to have rights on their server, I don't know if the give you access for your server to connect to their, but if they do, they can tell you more about.
------------------------------ Author of Primary ROleplaying SysTem How do I take my coffee? Black as midnight on a moonless night. War doesn't determine who's right. War determines who's left.
-
I have a database on cloud.. as for backup.. i just want to connect my sql server to that database though c # coding.. :( help here pls..
Have you direct access to the database? Have you an user with admin rights and a password? Do you know the type of Database? When yes, no problem. You can use SqlConnection for that. Take at look at following: http://msdn.microsoft.com/de-de/library/system.data.sqlclient.sqlconnection%28v=vs.80%29.aspx[^] Beginners guide to accessing SQL Server through C#[^]
------------------------------ Author of Primary ROleplaying SysTem How do I take my coffee? Black as midnight on a moonless night. War doesn't determine who's right. War determines who's left.
-
I have a database on cloud.. as for backup.. i just want to connect my sql server to that database though c # coding.. :( help here pls..
Looks like you need to investigate the Microsoft Sync Framework. Details here[^].
*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington
"Mind bleach! Send me mind bleach!" - Nagy Vilmos
CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier
-
Have you direct access to the database? Have you an user with admin rights and a password? Do you know the type of Database? When yes, no problem. You can use SqlConnection for that. Take at look at following: http://msdn.microsoft.com/de-de/library/system.data.sqlclient.sqlconnection%28v=vs.80%29.aspx[^] Beginners guide to accessing SQL Server through C#[^]
------------------------------ Author of Primary ROleplaying SysTem How do I take my coffee? Black as midnight on a moonless night. War doesn't determine who's right. War determines who's left.
hey sorry.. i think you get me wrong.. i want to connect mssql server 2008 to cloud ,.. not my application to mssql2008.. i have already done that.. now i want to connect local server which is mssql 2008 to cloud database. thanx for your try.. but hope you understand my question now..
-
hey sorry.. i think you get me wrong.. i want to connect mssql server 2008 to cloud ,.. not my application to mssql2008.. i have already done that.. now i want to connect local server which is mssql 2008 to cloud database. thanx for your try.. but hope you understand my question now..
Then it's the wrong board. In this board we are discussing C# programming and not SQL-Server to Cloud connection. You should go to the database board.
------------------------------ Author of Primary ROleplaying SysTem How do I take my coffee? Black as midnight on a moonless night. War doesn't determine who's right. War determines who's left.
-
Looks like you need to investigate the Microsoft Sync Framework. Details here[^].
*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington
"Mind bleach! Send me mind bleach!" - Nagy Vilmos
CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier