Sript out a remote sql server database
Posted on 2011-09-02
I have a webserver and a separate mssql server 2005. I am not running SQL Management Studio on the webserver, but here is what I need to accomplish. I need to know if there is a free tool that I can use on the web server to connect to the SQL server and script out a DB to a file. I will need the schema and data of the database. Then I can use the script to recreate on my other mssql server at a separate location. The 2 mssql servers can not talk to each other which is why I need to script it out.