After you read up and test it out, if you have any problems, feel free to post the issue.

You can set up snapshot replication if you want to...

It is an FTP Merge..Right? What is the latency between the publisher and the subscriber? Do you have enough bandwidth? Looks more like Internet problems than anything else

That would be toughie.... Does the same APP connect to different DBs to do different things? Couldnt the app be modified to read the connection from a config file?

What ever rights you gave to the SQL Login, you can provide for the Windows login that you created in the DB.

CREATE LOGIN [<domainName>\<loginName>] FROM WINDOWS;

GO

Windows Authentication does not mean that the users credentials have to be taken. You will create one Windows Login, the app connects with it to do all the database work....

.NET can use Windows Authentication.

I dont mind having a select * being done from SSMS but not from application. Getting unwanted data that you are not going to use in your app by doing...

Drop the foreign key constraints and then add it back with the option WITH NOCHECK. That would mean that it will not check for any existing data. That could probably...

I have never used application role, so I wont comment on that.

But for SQL Login, I would rather keep away from it and use Windows Authentication. What we do is...

Do you have foreign key constraints on the subscriber? That could be one reason why it cannot apply the script.

On your subscriber, do you have foreign key constraints enabled? If you do, drop the foreign key and then try again.

That is one area I do not even look at. As soon as I see SSIS, I skip the thread...:-) That is like a black hole for me..:-)

I...

I would also say Yes provided you have a way of identifying what application changed what data and if there is a need to have reports based on all the...