Hello,

I have a couple questions about the 'DotNetNuke.Data.SqlDataProvider' file that resides down Providers\DataProviders\SqlDataProvider.

1) What is it's purpose?  I understand the purpose of the other *.SqlDataProvider files because they relate to upgrade SQL scripts for a given DNN version.

The reason I ask the above question is that I had an upgrade from a 4.8.4 version to 5.01.02 that I thought I was running against a test copy database but ended up accidentally using a web.config that pointed to my live DB.  Ouch!  Then found out the backups for the live DB were bad.  Double OUCH!

Anyways, the 4.8.4 -> 5.01.02 didn't go well and I now cannot get to the "Module Definitions", "Skins" etc.  

I noticed after looking over the DB for a clean install of the latest version of DNN that a handful of DesktopModule, ModuleDef, TabModules, Modules table entries don't exist that would have to do with the items I see that are missing.  I see that in the "DotNetNuke.Data.SqlDataProvider" file there are 'insert into' scripts that load these specific tables with the information I need.  The problem is that I see the 'DotNetNuke.Data.SqlDataProvider" has hard coded identity ids that when I look at my corresponding tables are already taken.  For instance the DesktopModules 'insert into' part of script has this:

INSERT INTO {databaseOwner}[{objectQualifier}DesktopModules] ([DesktopModuleID], [FriendlyName], [Description], [Version], [IsPremium], [IsAdmin], [BusinessControllerClass], [FolderName], [ModuleName], [SupportedFeatures], [CompatibleVersions], [Dependencies], [Permissions], [PackageID]) VALUES (52, N'Extensions', N'Extensions.', N'01.00.00', 0, 1, NULL, N'Admin/Extensions', N'Extensions', 0, NULL, NULL, NULL, 52) 

The DesktopModuleID of 52 is already taken by another entry in my DB.  Can I tailor the sections of the DotNetNuke.Data.SqlDataProvider script that I want and change the identities to values other than those specified without causing some issue down the road where upgrades would be concerned with identity values that need to be the same as those specified in 'DotNetNuke.Data.SqlDataProvider'?  I know I'd have to also touch up the related table rows that are related to the rows I'd like to insert if I was able to go this route.

Thank you for your time on reading this and I look forward to your input!

Bill