1. Web Hosting community for Webmasters
  2. Web Hosting Main Forums
  3. Web Hosting
  4. Migratet database from SQL server EXP 2005 to SQL server 2008 EXP r2

Divi WordPress Theme
« previous next »
Pages: [1]   Go Down

Topic: Migratet database from SQL server EXP 2005 to SQL server 2008 EXP r2  (Read 706 times)

Offline utsav

  • New Member
  • *
  • Posts: 42
  • iTrader: +0/-0
    • View Profile
Migratet database from SQL server EXP 2005 to SQL server 2008 EXP r2
« on: May 15, 2015, 11:29:10 PM »
Hello,

How can I migrate database from SQL EXP server 2005 to SQL server EXP 2008 r2?

Any suggestion will be appropriated

VPS Hosting - AccuWebHosting

Offline Kailash

  • Web Hosting Master
  • *****
  • Administrator
  • Posts: 604
  • iTrader: +153/-0
    • View Profile
Re: Migratet database from SQL server EXP 2005 to SQL server 2008 EXP r2
« Reply #1 on: May 16, 2015, 02:55:07 PM »
You can generate backup of your database from SQL 2005 server and then you can restore it in SQL 2008 R2 server. You should be able to restore without any issue.

- Kailash

Offline utsav

  • New Member
  • *
  • Posts: 42
  • iTrader: +0/-0
    • View Profile
Re: Migratet database from SQL server EXP 2005 to SQL server 2008 EXP r2
« Reply #2 on: May 16, 2015, 10:31:58 PM »
Hello,

Thanks for your reply...

Do you mean .bak file?

IS it possible to backup and restore from old WSP to new one?

Offline Kailash

  • Web Hosting Master
  • *****
  • Administrator
  • Posts: 604
  • iTrader: +153/-0
    • View Profile
Re: Migratet database from SQL server EXP 2005 to SQL server 2008 EXP r2
« Reply #3 on: May 18, 2015, 03:21:31 PM »
Yes, I was referring .bak file. You can try to restore it directly from WebsitePanel.
Divi WordPress Theme
Pages: [1]   Go Up
« previous next »
Tags:
  1. Web Hosting community for Webmasters
  2. Web Hosting Main Forums
  3. Web Hosting
  4. Migratet database from SQL server EXP 2005 to SQL server 2008 EXP r2