I see that  when DNN installs it start off with running these scripts:

00:00:00.046 - Installing Version: 3.1.0
00:00:00.046 - Installing Script: DotNetNuke.SetUp.SqlDataProvider Success
00:00:00.187 - Installing Script: DotNetNuke.Schema.SqlDataProvider Success
00:00:11.797 - Installing Script: DotNetNuke.Data.SqlDataProvider Success
00:00:21.172 - Installing MemberRole Provider:
00:00:21.172 - Executing InstallCommon.sql
00:00:22.532 - Executing InstallMembership.sql
00:00:25.157 - Executing InstallProfile.sql
00:00:25.688 - Executing InstallRoles.sql
 Success

if exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}FindDatabaseVersion]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)

When this runs, what should it look like? Something like this?:

if exists (select * from dbo.sysobjects where id = object_id(N'myOwnerName.don't_know_what_to_put_here.FindDatabaseVersion]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)

Could you give me an exact syntax example?

I ask because I created a development version of DNN and the database and now would like to move both off my machine to a test server.

However, I am having tremendous difficulties with either copying or export/import the DNN database in SQL Server 2005, because of missing items or too many errors and stuff I dodn't know too much about. I would love to be able to just copy the db because it seems that data pertaining to what modules are on what pages and their respective content but have had no luck.

Thanks in advance for any help at all