Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Move SQL 2005 from local to hosting Provider?Move SQL 2005 from local to hosting Provider?
Previous
 
Next
New Post
4/23/2006 6:10 AM
 
Mark Broomfield


Joined: 4/11/2003
Posts: 29

This has been driving me made for days now...please help.

I have a working DNN 4, SQL 2005 Express install working fine on my local PC.

When I try to export my database to my host using SQL Server Management Studio's Export and Generate Scripts wizards (SQL 2005 SP1)  I can move the database but all the IDENTITY coloumns in my tables are being lost (I tick the relevant box when exporting so that should keep the identity columns intact but it resets them).

Any help would be appreciate. How the hell does anyone move their database from local development to their host?

Thanks Mark
 
New Post
4/23/2006 12:25 PM
 
Jim Bonnie

www.walkspoiled.com
Joined: 12/21/2004
Posts: 122

I am trying to move a database from a production server on discountasp.net to a local machine and having a hard time as well. It was easier in SQL 2000 on discountasp.net, you could simply use the export script. But with the improvements made in SQL 2005, there are problems with security settings that prevent the new backup features to work.

I had to use the script wizard to create the objects on the Production host, run the script on the target DB, and then run the export wizard to copy the table data.

BUT, after doing this, the site comes up with the pages created, but none of the module content.
Looks like some linkages between the pages and the modules is being lost.

Has anyone gotten a script with the right settings for moving between hosts for DNN 4.02 and SQL Server 2005 ?

Thanks, Jim
Jim www.walkspoiled.com
 
New Post
4/23/2006 12:47 PM
 
Chris Smith


www.nddllc.com
Joined: 1/25/2003
Posts: 681
Detach the database from the development server and transfer the DB files to the appropriate directories (mdf, ldf) on the production box. In SMS, use the attach command to attach the transfered DB files.
 
New Post
4/23/2006 4:04 PM
 
Jim Bonnie

www.walkspoiled.com
Joined: 12/21/2004
Posts: 122
I do not believe that my host discountasp.net, allows users to attach and copy db files around.
The trick is finding the way to move DB's between the host and development with the provlidges provided by that host.
Easier said then done!
Jim www.walkspoiled.com
 
New Post
4/23/2006 4:43 PM
 
Chris Smith


www.nddllc.com
Joined: 1/25/2003
Posts: 681
Honestly, a backup (full mode) and restore should surffice.
 
 Page 1 of 2
12Next 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Move SQL 2005 from local to hosting Provider?Move SQL 2005 from local to hosting Provider?


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out