Here is the data structure for DNNDownload (had enterprise manager generate a script):

CREATE TABLE [dbo].[HPS_DNNDownloads] (
 [ItemID] [int] IDENTITY (1, 1) NOT NULL ,
 [ModuleID] [int] NULL ,
 [CreatedByUser] [nvarchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
 [CreatedDate] [datetime] NULL ,
 [UpdatedByUser] [nvarchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
 [UpdatedDate] [datetime] NULL ,
 [Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
 [Description] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
 [Author] [nvarchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
 [AuthorEmail] [nvarchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
 [FileSize] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
 [Downloads] [int] NULL ,
 [PreviewImage] [nvarchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
 [Image] [nvarchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
 [FileName] [nvarchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
 [Clicks] [int] NULL ,
 [RatingVotes] [bigint] NULL ,
 [RatingTotal] [bigint] NULL ,
 [RatingAverage] [float] NULL ,
 [Approved] [int] NULL ,
 [ShowEMail] [int] NULL ,
 [DownloadRoles] [nvarchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[HPS_DNNDownloadsComments] (
 [CommentID] [int] IDENTITY (1, 1) NOT NULL ,
 [ItemID] [int] NOT NULL ,
 [CreatedByUser] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
 [CreatedDate] [datetime] NULL ,
 [Comment] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

After going through it for awhile, I think I'm getting the hang of how I could transfer it all over.  It looks like I have over 600 files in there, so it's not a small process.

One thing I am confused about is the physical location and naming of the files.  I don't see an entry in the database giving a path, but they appear to be sorted (in DNNDownload) into folders named after the uploading user.  Do I have to move those folders to the Respository folder or can I move them to a different folder?

I'll be looking into it a bit more this weekend, hope to have a test module setup soon so I can try out my theories on how it is supposed to work.

 

Dan, here's where I'm at. I changed the 03.00.00 SqlDataProvider script (which includes the code Steve posted earlier) and everything gets copied over like it should. I then wrote a small script that changes the ModuleDefID in the Modules table to point to the Repository instead of DNNDownloads. Now, unless I've missed something, that should be it but nothing is showing up on the page I had DNNDownloads on. The module shows up and I can upload a new file which gets installed into the repository and all looks good but when viewing there's nothing there. I'm going to keep working on it to see if I can figure out the problem.

Dan, I just want to verify that you got my latest email with the updated upgrade script.