I have a remote MSSQL server meant to centralize SQL for development projects. I hand out DB's and access to developers as they need it. I do not want to give them access to filesystem in any way (would require RDP access or opening several firewalls).
My question is how can the developers easily copy their local DB to the remote DB as they transit from local databases to remote shared database?
For reference this is how you would do it in MySQL:
mysql -h host -uuser -p db < db.txt