DNN 3.2.2 and SQL 2005 - General Discussion

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

Home All Forums

1
2
3
4
5

Home

Our Community

General Discuss...

DNN 3.2.2 and SQL 2005

11/13/2006 11:56 AM

Mark Channon

Joined: 1/22/2004

Posts: 21

DNN 3.2.2 and SQL 2005

Hi

I have a site which is running DNN3.2.2 (with many 3rd party modules, so don't want to take the chance on upgrading as the site has been live for sometime) and SQL server 2000.

I've recently moved servers (I'm in the UK) and for all the rest of my sites I'm running DNN4 and SQL 2005. The DNN3.2.2 site is now using a shared SQL 2000 server but the time is US and not UK which I need, so I need to move it again to a UK server.

Is it possible to run DNN3.2.2, detach the 2000 database and re-attach it to MS SQL 2005?

Any help much appreciated!

Cheers

Mark

11/14/2006 9:38 AM

Roselle

www.crunchysnow.com
Joined: 8/15/2005

Posts: 35

Re: DNN 3.2.2 and SQL 2005

Is it possible to run DNN3.2.2, detach the 2000 database and re-attach it to MS SQL 2005?

Yes, take a look at this msdn article:http://msdn2.microsoft.com/en-us/library/ms189625.aspx

Although I didn't migrate from SQL 2000, I'm running a site with DNN 3.2.2 and SQL 2005 and it's great!

cheers,
Rose

11/14/2006 10:04 AM

Jan Olsmar

www.olsmar.com/
Joined: 9/19/2005

Posts: 1354

Re: DNN 3.2.2 and SQL 2005 Modified By Jan Olsmar on 11/14/2006 10:06:34 AM

Yes its possible to do so.

You will probably get an other problem though. As you change db language you maybee get a problem in one of the srored procedures for shedued jobs that asumes that the db are the same as default for the server.

You can change the stored procedure so it works. I dont remember what procedure for the moment and I dont know if it is changed in the releases after. If you need it I can look for the information.

Jan

11/14/2006 6:03 PM

Mark Channon

Joined: 1/22/2004

Posts: 21

Re: DNN 3.2.2 and SQL 2005

Thanks for the replies I'm going to give this a go. Can I ask did you just change the following line in the web config to connect to the 2005 database:

<add key="SiteSqlServer" value="Server=(local);uid=user;pwd=pass;database=database" />

I'm going to try this. I'll let you know what happens.

Thanks

Mark

11/15/2006 1:44 PM

Roselle

www.crunchysnow.com
Joined: 8/15/2005

Posts: 35

Re: DNN 3.2.2 and SQL 2005

Yes, you'll have to modify that line if any of those variables change.

Good luck with the migration!

-Rose

Page 1 of 2

1

DNN 3.2.2 and SQL 2005

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:

No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
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.
Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
No Flaming or Trolling.
No Profanity, Racism, or Prejudice.
Site Moderators have the final word on approving / removing a thread or post or comment.
English language posting only, please.

Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

DNN Corp. (DotNetNuke)