Changing a forms data source and retaining logic

[DarrylGould]

Hi

I have created an InfoPath form that submits data to a SQL database,
and stores a number of fields locally in XML.

I want to remove the existing SQL database and replace it with a new
one, i.e. I want to send the data to a new database.

Also the form contains a lot of logic around the XML fields, so I do
not want to copy and paste the original form into another one, as I
have tried this and it loses all of the logic. Does anyone know a way
around this?

Many thanks
Darryl

 

[Clay Fox]

Hi Darryl.

As long as the data structure is the same, same fields, and you are just
changing location or DB name then the easiest way is to export to source
files and then edit the manifest.xsn in notepad. There you can change the
data connection and update the server and db name in the connection string.

If you ar emaking wholesale changes to the database structure than I think
you are in trouble. The standard SQL form is completely built around the
query and data groups and breaking that breaks the whole form.
I recommend using Web Services to connect to your SQL data. Check out the
Database Accelerator package from http://www.qdabra.com. It allows you to
map your data to SQL at a whole different level. It could actually allow you
to salvage your form if you need to make schema changes. Keep the current
default structure but change the submit to web service instead of SQL
directly. So that would be one option if you need it.
--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com