January 14, 2008 at 10:43 am
I have a db recently migrated to SQL Server which I must test. Each table has many triggers. I am looking for a tool that can generate insert, update and delete statements. If the tools needs to generate test data to do this that's fine with me. Years ago I put together a tool, (now lost to me) which generated statements based on sysobjects, sycolumns and sysforeignkey entries. That tool never made to the "prime-time" level that I currently need, but I did learn that the possibilities are there for such a tool.
I can pay, but it would be great if this tool did not cost a lot of money. I'm not looking for a fancy interface or reporting capabilities.
Any ideas?
Joel
Takauma
January 14, 2008 at 11:17 am
There are a number of third party tools that can do this, for example Embarcadero's RapidSQL. You can also simply right click on the tables and get it for yourself. There's probably a way using SMO, but I'm not aware of one. I did see this over on the Code Project. It looks pretty good.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 15, 2008 at 6:47 am
you* could write one in half a day or an even better one in a full day
* from your post you sound experienced so the T-SQL should be a breeze
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply