When we had worked in SQL Server 2000, including deployment into the remote server, for deployment in testing servers as well as slice the whole database in several parts requires sripts to be generated for both database schema and data.
By this time for schema script generation I used “Enterprise Manager” and for generate SQL INSERT script for data I used an third party tool, found in codeproject, which can be found at http://www.codeproject.com/dotnet/ScriptDatabase.asp. Beside to populate mock data I also used another third party tool, which was also very useful for me (it has some bugs tho), can be found at http://www.daansystems.com/datagen/.
In SQL Server 2005, Microsoft came with a nice tool named "Microsoft SQL Server Management Studio", which has new exiting features including data syschronization etc support. However when I switched to SQL Server Express based development, I found a bit tricky to generate SQL INSERT scripts for the data in "Microsoft SQL Server Management Studio", although as before we can generate sql statement s for db schema with this. For the insert sql script generation statement, we get only a template with one row, Where I would expected to have insert statements for all rows.
Microsoft was not much interested to provide any tool to generate SQL INSERT scripts for all data rows. With third party tool found in codeproject as i said at the beginning, it sometimes works with SQL Express and SQL Server 2005 database, but not always. Well my assistant Fazley Rabbi found an interesting tool that is free for me so far. Here is the link: http://docs.aquafold.com/docs-register-express.html.