1. Use your local MS SQL Management Studio and export the local SQL database in SQL file.
2. Create a new server based SQL database by using your Control Panel -> MSSQL section.
3. Connect with your local MS SQL Management Studio to the Remote Database that you have just created.
4. Open a new query on the database and copy and past the content of the exported SQL file in that new query.
5. If there is a line in the SQL query that refers to creating new database - just remove that line ( because your database is already created, it is just empty database ) and then execute the query against the remote database.
This will create your database tables and fill them with the existing data.
Last update: 2011-10-06 10:24