Extracting data from a form into SQL server - best process

Hi,

I need to extract all the data from a form to SQL server. What would be the easiest way of doing this?
There are some clob field data types, will they be a problem?

thanks
LVL 4
CraigLazarAsked:
Who is Participating?
 
Dominik_LConnect With a Mentor Commented:
If You mean from HTML form than You should make a dynamic script (e.g. ASP.NET, PHP) which gets data from Your form (You can add a button to that form to send it's data to the new script) and puts it to SQL Server with SQL code like that:
INSERT INTO [table_name]([column1], [column2], [column...]) VALUES([value1], [value2], [value...])

value1, 2 and another You pass from the source form.
If there is CLOB datatype use SQL "BINARY" data type.
0
 
Sjef BosmanGroupware ConsultantCommented:
Where does Notes come into this story?? Is it a Notes form??
0
 
CraigLazarAuthor Commented:
ok i have a notes database. And i am busy with data migration from notes into SQL server. I have been battling to get the data out of the nsf file. I am using the Notes ODBC connection and just battling to get all the data into sql and it looks like its the clob fileds that are giving me hassels. I have also tried linking to the table thru access and then using SELECT INTO statements but get errors.
there are about 144 fields in the notes database.

hope this helps
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
Dominik_LConnect With a Mentor Commented:
If You have ODBC connection already, start SQL Server Management Studio and there is Import option. Try it out.
If that won't help You may also try to use DTS package.
0
 
Sjef BosmanGroupware ConsultantCommented:
Ah, yes, thanks.

If I remember correctly, the ODBC-connection doesn't handle everything. You might try a different way: there's NotesSQL, if you want to access Notes the SQL-way.
0
 
SysExpertConnect With a Mentor Commented:
I agree with :sjef that you will probably need a specialized tool to do this automatically, or write your own custom code to do it via a conversion DB of some type.



I hope this helps !
0
 
CraigLazarAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.