File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: To Populate Bulk Records in SQL Server thru Java
 
Similar Threads
How to do Bulk Emailing when u have Millions of records????
sql question
Inserts using java or plsql
assigning a gauranteed incrementing number with no misses to a column
passing variable to jsp