Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

$4.95 Windows Hosting at Webhost4life.com
  Ads  
Engage Software - Training Partner for DotNetNuke
 


  Sponsors  

Meet Our Sponsors

Webhost4life, specialists in DNN hosting
Mad Development is a full service interactive agency focusing on the merge of design, technology, e-commerce, and affiliate marketing by providing total website solutions.
AspDotNetStoreFront - E-Commerce by Design - The Leading ASP.NET shopping cart platform for developers!
SteadyRain
DataSprings - Great Ideas. Always Flowing.
R2integrated - formerly bi4ce
 


DotNetNuke Forums
 
  Forum  General DotNetN...  Configure It! (...  Switching Database from 2005 Express to SQL 2000
Previous Previous
 
Next Next
New Post 2/22/2008 11:16 AM
User is offline henrys_web
5 posts
10th Ranked


Switching Database from 2005 Express to SQL 2000 
I'm about to switch from my local testing server to a networked server and unfortunately have to switch database from my 2005 express db to what the server has which is SQL 2000. I've read some articles on it from what I've searched on the net and some people say that it's not possible, some some say it's an easy "generate script" but I keep heading into errors. is it really supposed to be this complicated to transfer tables from 2005 express to sql2000? I've never had so much problems with other databases as I've had with this Microsoft workflow!
 
New Post 2/22/2008 1:07 PM
User is offline Jan Olsmar
458 posts
www.olsmar.com/
8th Ranked




Re: Switching Database from 2005 Express to SQL 2000 

If you need to go back to the old 2000 Sql try to do the following:

In Express manager choose task - generate script for all ojects.

Make sure the target is sql2000 and script to file.

Then in enterprise manager, make a new database Tools/SQL Query Analyzer open the file and run.

Jan

 
 
 Page 1 of 1
Previous Previous
 
Next Next
  Forum  General DotNetN...  Configure It! (...  Switching Database from 2005 Express to SQL 2000
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, 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 DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.
 


UK - DotNetNuke providers
UK providers of DNN module development and skin package design. Oxford Information Labs provides cost-effective solutions for businesses and organisations specialising in Skin design and bespoke module development.
www.oxil.co.uk 		TronixSoft
Hosting for local businesses that want more from their websites.
www.TronixSoft.com 		The Forerunner Network
The Forerunner Network consists of a group of Dynamic Website & Interactive Membership Portal hosting services that are managed by Forerunner Communications. Our services span a wide range of markets and enable individuals, organizations and businesses to build and manage dynamic, interactive portals and websites.
The Forerunner Network

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP