Comments by Prasanth S (Top 1 by date)

Use SQL Server Management Studio, go to tasks, choose script database, then choose option include data and schema, now you can generate the query containing data and schema. Run that query for remote database. The other option is to create all the tables and choose import option to import local data to remote database