Using SQLScriptGenerator you can connect to your local or remove SQL Server and generate T-SQL script of the whole database or just database structure or just data or specific database objects. In the result it generates one or several *.sql files with CREATE, INSERT T-SQL statements that recreate database objects you've selected. See features for supported database objects.