|
How do i connect to a remote database and get information.. -- Shadaan --
Hi Guys,.. I am developing a windows application which needs to get connected to a remote database place some where in some part of the world so how do i do that. and once i get the connection and the required fields i want to campare it with the local database server and make the appropriate changes to the remote main database that are found on the local database... so how do i take a start and how do i proceed step wise.. Plzzz help i m in a dilemma Your help will be appreciated. Thanks N Regards. Shadaan |
|
-- BradleyPeter --
Connecting is not your problem. You just do that with an appropriate connection string in ADO.NET. However, a home-grown application is probably not the right answer. Your problem is that you are trying to implement a distributed database. This is cutting edge stuff. Most large scale RDBMSs provide facilities for managing databases in a distributed environment. It is very complex and can cost the earth, depending on your requirements. If your requirements are fairly straightforward, your RDBMSs replication facilities may be adequate for your needs. This white paper from Microsoft will give you some idea of what you are up against in a MS SQL Server environment: http://databases.about.com/od/sqlserver /Other databases provide similar or better facilities. Oracle, for example, has - I believe - some very sophisticated facilities. HTH Peter -----Original Message----- From: DotNetDevelopment How do i connect to a remote database and get information.. Hi Guys,.. I am developing a windows application which needs to get connected to a remote database place some where in some part of the world so how do i do that. and once i get the connection and the required fields i want to campare it with the local database server and make the appropriate changes to the remote main database that are found on the local database... so how do i take a start and how do i proceed step wise.. Plzzz help i m in a dilemma Your help will be appreciated. Thanks N Regards. Shadaan |