Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

To Populate Bulk Records in SQL Server thru Java

 
Micheal John
Ranch Hand
Posts: 344
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,

Greetings,

I have to populate bulk data into Microsoft SQL Server(around 20,000 records in a table). For each fields in the table, I have to increment/randomly generate to populate it in the SQL Server. Basically, I am from Java background, I thought of writing it in java to populate. Since I don't much aware of syntax of PL/SQL, I have decided to do it in Java.
My Question is: Is the PL/SQL will be easier than Java for this job? orSome other easy way is there provided by SQL Server itself..
Please give me some suggestion on it..
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic