Anyone who uses SQL Server is familiar with the scripting capabilities
that the Enterprise Manager or the SSMS offer. Being able to script an
object or an entire database is great, however, often we are faced
with situations where we don't just need the script for creating a
table to the destination database but we also need to transfer the
data. To do that we often go the DTS route, either directly from one
server to the other or dumping the data first into a text file and
uploading them to the other server.

Now there is a better way - both xSQL Object for comparing SQL Server
database schemas and xSQL Data Compare for comparing the content of
two SQL Server databases by xSQL Software provide extended scripting
capabilities that allow you to script both schema and data together
for a single table or for a whole database. A single script creates
the object (the table) and populates it too.

What's even better is that both of those products are free for SQL
Server Express Edition and also the company offers a free Lite Edition
of xSQL Bundle (includes both xSQL Object and xSQL Data Compare) for
other editions of SQL Server. Both products support SQL Server 2000
and SQL Server 2005.

Those products are available for download from the companies website
at: http://www.xsqlsoftware.com