I need to load refreshed data daily to my client database located at a remote site. I prefer to bundle an update file and transfer it through FTP to the remote site so that DBAs there can run it and update their database. Can SQL Server create and load this type of update file instead of doing direct replication?
...