Server Hostname: Your db user name your db password.
Once connected, find your database in the list and right click, then select New Query.
Then find your scripted .sql file and open this using notepad. Select All the contents and Copy. Then paste this into the Query window In SQL management studio.
Then click Execute from the icons at the top of the screen.
This will then populate your remote database with the content of your local database.
Once complete, change your connection string to reflect the following:
Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;
