Re: populate 1 million data atleast from 3 or 4 tables
Not sure if you're still looking for an answer to this... Google "test data generator" and you'll get a bunch of hits!! [img]/images/graemlins/cool.gif[/img]
One that I've heard good things about is Quest's Data Factory tool: http://www.quest.com/datafactory/. If you have the ability to run a load test, that can also be an effective way of populating a database.
SoCalGal - Defender of end user response times!