如何转换为SQL Server 2008r2数据库到SQL Server 2005

谁借莪１个温暖的怀抱￠ 2022-08-24 14:23 77阅读 0赞

### 1)  ###

![Change Hyper-V Default Folders Step 1][]

### 2)  ###

![Change Hyper-V Default Folders Step 1][Change Hyper-V Default Folders Step 1 1]

### 3)  ###

![Change Hyper-V Default Folders Step 2][]

### 4) ###

'Script for Server Version' = 'SQL Server 2005'
    'Script Data' = 'True'
    'Scirpt Database Create' = 'True'

![Change Hyper-V Default Folders Step 2][Change Hyper-V Default Folders Step 2 1]

### 5)  ###

![Change Hyper-V Default Folders Step 1][Change Hyper-V Default Folders Step 1 2]

### 6) ###

![Change Hyper-V Default Folders Step 1][Change Hyper-V Default Folders Step 1 3]

### 7)  ###

![Change Hyper-V Default Folders Step 1][Change Hyper-V Default Folders Step 1 4]

### 8) 修改脚本 ###

打开 SQL Server Management Studio 2005. 修改路径

CREATE DATABASE [StockTraderDB] ON  PRIMARY 
    ( NAME = N'StockTraderDB', 
    FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\StockTraderDB.mdf ,
     SIZE = 4352KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
     LOG ON 
    ( NAME = N'StockTraderDB_log', 
    FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\StockTraderDB_log.LDF',
     SIZE = 6272KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)

### 9) 执行脚本 ###

[Change Hyper-V Default Folders Step 1]: http://www.sqlservermart.com/HowTo/Images/ConvertSQL2008_To_2005_1.gif
[Change Hyper-V Default Folders Step 1 1]: http://www.sqlservermart.com/HowTo/Images/ConvertSQL2008_To_2005_2.gif
[Change Hyper-V Default Folders Step 2]: http://www.sqlservermart.com/HowTo/Images/ConvertSQL2008_To_2005_3.gif
[Change Hyper-V Default Folders Step 2 1]: http://www.sqlservermart.com/HowTo/Images/ConvertSQL2008_To_2005_3_1.gif
[Change Hyper-V Default Folders Step 1 2]: http://www.sqlservermart.com/HowTo/Images/ConvertSQL2008_To_2005_4.gif
[Change Hyper-V Default Folders Step 1 3]: http://www.sqlservermart.com/HowTo/Images/ConvertSQL2008_To_2005_5.gif
[Change Hyper-V Default Folders Step 1 4]: http://www.sqlservermart.com/HowTo/Images/ConvertSQL2008_To_2005_6.gif