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

link|improve this question

58% accept rate
feedback

1 Answer

Use SQL Management Studio Generate SQL scripts function (with Script data=TRUE - optional) on your database to generate SQL script, then run sqlcmd utility with correspondent options to execute sql commands from specified script from local system on remote sql server(s).

To automate database script generation you can download and install Database Publishing Wizard - it can generate scripts for database schema and/or data

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.