Developing a network application with C# And SQL SERVER 2005

Hello every bdy dre.........

I have developed the desktop (windows form) application using C# , with MS SQL 2005 database. That is separate application run in four different centers with their own separate database, but now i want to make it centralized database. For all four center has only one data base.
they enter data in one data base and access the data from one place as with central data base.

My problem is that I am stukked now as i dont have any idea to wht to do
either to develop a new application for this purpose that can have centralize data base (asp,web pages,on network)
have I written any application that will run on a network.
to make some changes in existing application so that it work on centralized database(some little changes in app.confif)
to make a new database
to modify the existing database

Please I need your help on how to achieve this. Any contribution would be highly appreciated.

Huma Satti

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Abhimanyu K Vatsa16y ago
hi.....

to be very frank, i have also not worked on such project yet. but as i know, this is concept of distributed database.

for distributed database you should have IP address configured computers or if you are working on internet then you should have domain mapped. and have to use the query language like

SELECT * FROM tablename@domain_name_or_IP_address;

OR

CREATE SHARED PUBLIC DATABASE LINK sales.us.india_auto.com
CONNECT TO mydb IDENTIFIED BY some_name_and_password;

(only on domain_systems)

Good Luck for such kind for projects. take care of you.
0