Database Publishing Wizard
is very flexible and works with modes like schema only, data only or both. It generates a single SQL script file which can be used to recreate the contents of a database by manually executing the script on a target server.
You may find at following location in your machine:
C:\Program Files\Microsoft SQL Server\90\Tools\Publishing
Download Database Publishing Wizard
Please do let me know, if you have any doubt.
Please provide "Vote
":thumbsup: if this would be helpful, and make "Accept Answer
" if this would be correct answer.:rose: