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
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Reply 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
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: To Populate Bulk Records in SQL Server thru Java
 
Similar Threads
assigning a gauranteed incrementing number with no misses to a column
Inserts using java or plsql
passing variable to jsp
sql question
How to do Bulk Emailing when u have Millions of records????