無法從 SQL Server 2008 R2 Standard Data restore to SQL Server 2008 Standard

所有回覆

• 

  

  0

  登入以投票

  That's correct, you can't restore higher version's db to lower version server.

  2010年9月24日 上午 03:17

  回覆

  |

  引述
• 

  

  0

  登入以投票

  Bro, try to extract all data to text or some other format, then

  using older version can import it back to the DB

  It is some faster and prevent data file inconsistent way~~~

  :D

   

  ---

  MCPD .Net, CCNP Love programming, but not an IT Guy Haha! :D

  2010年9月24日 上午 04:27

  回覆

  |

  引述
• 

  

  0

  登入以投票

  Hi Jackson, thanks for your reply. I can extract all data to text format then import those back to the SQL2008 DB, however, I have encountered the Table and Chinese character problem. Some of Tables show error, any comments about this ?

  Thanks.

   

  2010年9月24日 上午 06:54

  回覆

  |

  引述
• 

  

  0

  登入以投票

  Do you use unicode data type for involved columns? Should add N in front of string like N'xxxx'.

  2010年9月24日 下午 01:46

  回覆

  |

  引述
• 

  

  0

  登入以投票

  You can use either one of the following handy tools under your Microsoft SQL Server 2008 (/R2) program folders, that can help to import/export data.
  
  - Import and Export Data
  
  - SQL Server Business Intelligence Development Studio (BIDS)
     >> New Project
        >> Business Intelligence Projects
           >> Integration Services Project

  ---

  -- Martin POON -- Software Architect -- SQL Server MVP, MCTS, MCITP ~~ http://msMVPs.com/blogs/MartinPOON

  2010年11月3日 下午 03:05

  回覆

  |

  引述
• 

  

  0

  登入以投票

  你好

  如果你還有SQL2008 R2 和 SQL2008 的話

  可以嘗試使用 SSIS 的 Transfer SQL Server Object Task 來把DataBase Object copy from SQL2008 R2 ro SQL2008

  詳情可以參考以下URL

  http://blog.sharechiwai.com/2010/05/sql2008-copy-sql-object-from-one-database-to-the-other-sql2008-%E8%A4%87%E8%A3%BDsql-object-%E7%94%B1%E4%B8%80%E5%80%8Bserver-%E5%88%B0%E5%8F%A6%E4%B8%80%E5%80%8B-server/

  Please correct me if my concept is wrong

  ---

  Chi

  2010年11月3日 下午 05:24

  回覆

  |

  引述