My professor has instructed me to make a simple project that requires the use of a database server on one computer, so that another can connect to it.
If my program makes a change in the database, the other program is updated automatically. As in, it is updated as soon as something is added in the database.
Example, if I use a program in computer A to update a certain number from one to two, the data in the database changes, and this will be shown in the program in computer B. I'm thinking perhaps I can keep a connection alive until a change is made, at which point it closes, although this might have some serious performance problems. Does anyone have a better idea?
My classmate has suggested using MySQL, however the latest version of MySQL requires .NET 4.0, and I cannot update the computers at school, so he also suggested SQL Server. Are there any speed differences between the two? And would an older version of MySQL work?
Thanks for the answers.
Edited by zack_falcon: n/a