Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Agile 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..
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic