In this Microsoft SQL Server and JDBC tutorial, you'll learn how to connect to a Microsoft SQL Server in Java using JDBC. The steps are relatively straightforward: Each database is different, so ...

I have worked with SQL Server for many years now, back to Sybase SQL Server days and there has always been confusion over Logins and Users.

SQL Server can do on-the-fly transaction replication, but it's intensive. You'd need to compare the cost of TS compared to another SQL server box and the amount of work to get it working.