generation of sql queries on tables

I have a few tables in my local SQL Server database with some data in those tables. I want to to transf开发者_C百科er that data to my database server. On that server I can run SQL queries.

How can I generate the SQL to do this, or is this possible using SQL Server Management Studio?

First, generate scripts for table structure and run the scripts on your target server, then use the bcp tool (see http://msdn.microsoft.com/en-us/library/ms162802.aspx) to migrate the data.

Take a backup of the database and copy that .bak file to your server, then use restore database option of SQL Management studio to restore the database from that .bak file.

Thanks