generatedata.com is one such tool. Generatedata lets you specify the database schema details and generates the dummy sql data for you, with table creation and complete inserts. The data can further be exported to html, excel, xml or csv formats. The tool is available online and there is also a downloadable version of the tool if you like to modify the code or need to install it on your server or development machine.
http://www.generatedata.com/#generator