Many times the most efficient way to do something is to avoid having to do it at all. In your case, trying to avoid dumping the entire table and...

I am a little confused. On the oracle server you attempted to insert values(1, 'Test it')

If you tried that on MSSQL, you'd get an error because 1...

Can you shed some light on the process you are using?

It sounds like you imported the data into MSSQL and either pushed it directly to an...