Okay - I'm going through the Module Development whitepaper and have gotten to the "Configuring Your Database" section on page 15.

It describes using a script to build the database structure - however, I cannot find the Database Provider Script it speaks of. Can someone help me out here?

Thanks.
~A~

Look in this folder

Providers\DataProviders\SqlDataProvider

you will see a series of scripts that create the db and populate it.

Cheers

Okay found the folder and all of the scripts.

Is there a master script or something that I should run that will invoke all of the other scripts? What is the process for setting this stuff up? I don't spend much time managing our SQL servers (we have dedicated folks for that) and I'm just running SQL 2000 on my local box for testing.

What do I do with these scripts? Thanks in advance.
~A~

For clarification,

I am looking in:

C:\DotNetNuke\DesktopModules\Survey\Providers\DataProviders\SqlDataProvider

Is this the correct folder? It only has a single script that I can see...now what?

OR - is this the right folder?

C:\DotNetNuke\Providers\DataProviders\SqlDataProvider

It has a ton of scripts in it and I still don't know what to do...

Please advise.

I used the C:\DotNetNuke\DesktopModules\Survey\Providers\DataProviders\SqlDataProvider script (since there was only one).

Following the documentation I did a Find/Replace on "{databaseOwner}{objectQualifier}" and replaced them with "", however the script would still not run. I discovered that there are also "PK_{objectQualifier}" references that were breaking the script. So, do another find/replace of "{objectQualifier}" with "".

Everything runs fine after making the additional modification.

I wanted to post this here so other n00bs like myself won't be lost on the same thing. Perhaps it would be helpful to include the PK_{objectQualifier} removal step on the tutorial as well.

Thanks.