I would like to have some advice or hint to choose the right type of replication using SQL 2008 Ent. and Windows 2008 Server Enterprise.
I made, a couple years ago, a good application using internet replication with Microsoft Access 2000 + Replication Manager 4.0. Since then, the database got bigger and bigger and before everything crash, I'm thinking about using SQL Server 2008 Replication.
I also having new client.
My application is a hockey league manager (around 25 tables). The users don't always have access to internet connection (Using laptop). The server hosting the database is also used as a web server wich display the stats and all other stuff from the
league on a website (Website is connected to the master database). User can change, delete or add data and conflicts should be rare but they can occur.
I'm planning to use the SQL Express 2008 on the client side and Windows 7 or XP.
So, with this scenario, what type of replication should I used ? It is possible to used that scenario with internet replication ?
Richard Martin Web Developer / BI Developer
View Complete Post