Geeks With Blogs

News Ashraful Alam Joy

Create Your Badge

Ashraful Alam is a Software Architect, who has 8 years of professional experience in Software Development industry. This Bangladeshi national is involved with project management and development of several US based software projects from his country. Already he has managed and developed several software projects, which are being used by several users of different countries, such as USA, Canada, Australia, and Bangladesh. While developing and managing a team, he contains and maintains a set of well defined engineering practices developed by him and other online developer communities.

Due to his willingness to give effort to improve and share better software development practices, Ashraf has been awarded as “Most Valuable Professional” (MVP) in ASP.NET category by Microsoft since year 2007 multiple times, which is a rare honor and prestigious reorganization among the developers around the world.

Check his portfolio to know more about him and his works.


.NETTER Characters... Every part of your life is best, if you can know yourself and thus create your life like an artist!

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.

Posted on Saturday, July 8, 2006 10:07 AM Implementation , Database , .NET , Software Development | Back to top


Comments on this post: SQL Scripting in SQL Server 2005 Express

No comments posted yet.
Your comment:
 (will show your gravatar)


Copyright © Ashraf Alam | Powered by: GeeksWithBlogs.net