If your database is relatively small you can generate create scripts from management studio to execute on the target SQL server. These can get quite large when you are scripting data, but it does work.
Right click on the database and select Tasks and Generate scripts...
Select your database and click the box toward the bottom labeled 'Script all objects in the selected database'
This is the most important part, read through the options carefully, Make sure you include data (false by default), triggers etc. If you have a complicated database, you may find the script will error when executed. For most common database schemas, this isn't the case.
I use this method often with web hosts which don't open SQL ports to the outside world. It only text, and easy to deal with