aspose file tools*
The moose likes JDBC and the fly likes To Populate Bulk Records in SQL Server thru Java Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "To Populate Bulk Records in SQL Server thru Java" Watch "To Populate Bulk Records in SQL Server thru Java" New topic
Author

To Populate Bulk Records in SQL Server thru Java

Micheal John
Ranch Hand

Joined: Nov 01, 2006
Posts: 344
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..


Micheal John
SCJP 1.4 (86%), SCWCD 1.4 (86%), SCBCD 1.3 (85%), SCDJWS (Just Started...) - Satisfaction Lies in Our EFFORT, Not in the ATTAINMENT
 
jQuery in Action, 2nd edition
 
subject: To Populate Bulk Records in SQL Server thru Java