在SQL SERVER 2000中使用SQL SERVER 2005的数据库

今天项目测试,服务器的数据库是sql server 2000的,但是项目一直用的sql server 2005的数据库，所以就在网上找了找sql server 2000使用sql server 2005的数据库的方法。能用的方法很多,但是比较乱. 我在这里整理下,希望对大家有帮助。

首先. 将要使用于sql server 2000的数据库在sql server 2005中先分离,分离的目的是做个备份吧,免得搞乱了.. 把分离好的数据库复制一份放在其他地方保存好.

二, 将数据库保存好后,再将数据库附加到sql server 2005中, 然后右键选择数据库 > 属性 > 选项 > 兼容级别 选择"SQL Server 2000 (80)" 确定.

三, 右键数据库> 任务 > 生成脚本 (打开向导后,下一步,然后提示"选择数据库",选择指定的数据库后,下面有个复选框 "为所选数据库中的所有对象编写脚本"一定要选中! 再下一步,然后这里的"选择脚本选项" 下面有个 "为服务器版本编写脚本" 选择为"SQL Server 2000", 下一步..后面的默认,直到完成.)

四,将生成好的脚本放到sql server 2000中运行.当然,在运行之前需要创建数据库,这语句只是建表的.呵呵..

五,在sql server 2000 中,右键选择该数据库,任务 > 导入数据 > 下一步 > 选择数据源这里不要动,只用选下面的 数据库, 默认是 "<默认值>" 改成该数据库就行了. 然后再下一步(后面的选项都是默认的)...全选表.. 下一步 ..直到完成 这样五步就完成了sql server 2000 使用 sql server 2005的数据库.

Universal laptop AC/DC adapter 100W Auto Car home AC DC power adapter charger laptop 761-100W.DGLBlue 8Gb USB 2.0 Flash MemoryUSB3.0A/F DIP 90° RoHS compliant connector OEM adapter connectorUSB B/F SMT connector plug OEM adapter RoHS compliant connectorPremium HDMI Male to Male Cable 1.3 Gold For PS3 1080p HDTV NewBluetooth WIFI 54M wireless lan card 150MB built-in antenna WLANHDMI 19P/F SMT type C HDMI high definition data plug HDMI connectorDVI24+5 Male solder 180°plugboard plug connector pin OEM adapter connectorHDMI Female to Female angle bend adapter connector with long life time OEMDC to Mini 8p charging head adapter with long life time connector OEMMini 4P Female SMT USB connector cellphone connector mini usb adapterVGA to HDMI adapter connector with long life time OEM fast speed4Gb USB 2.0 Flash Memory Drive32Mb USB 2.0 Flash Drive with Multi ToolsFunny Yellow Fish Like 4 Ports USB Hub for LaptopHDMI Male to Female adapter connector with long life time OEMDVI24+5 Female right angle elevated type plug connector pin OEM adapter connectorYellow Gold 8Gb USB 2.0 Flash Storage DriveBattery Shaped 64Mb USB 2.0 Flash MemoryHDMI 19P/F SMT with screw hole H5.08mm HDMI high definition data plug HDMI connectorSmart cable 4-in-1 multifunction cable promotion gift available in Pink silver orange etc.DVI18+5 Female 90°plugboard heightening type finished connector pin OEM adapter connectorHDMI to 2*DVI adapter connector with long life time OEMSilver 512Mb USB 2.0 Flash Storage DriveMini 18P Male wire solder USB connector mini usb port type cellphone connector adapterCute Green Ball Shaped 4 PORTS USB Hub8*RCA F to 25 pin Male HD VGA Video Audio Monitor CableUniversal adapter 761 DC 12V to AC 220V charger 100*63*40 mmUnique Car Logos Shaped USB 2.0 Flash Storage Drive, Nissan, Benz, Volkswagen, HondaSee-through USB Bluetooth Wireless PC Adapter DongleMini 8P Female 90° DIP typeC USB connector cellphone connector mini usb port socket adapterSamsung 10P Female SMT USB connector cellphone connector mobile connectorDVI 18+1 Male heightening type finished DVI plug DVI connector3*RCA F to 15 pin Male HD VGA Video Audio Monitor CableNAS SAMBA Network Storage SATA/IDE FTP Lan Server USB2DVI18+5 Male 180°plugboard heightening type finished connector pin OEM adapter connectorHDMI Female to Female adapter connector with long life time OEMSamsung 12P Female SMT USB connector cellphone connector mobile connector2.5 DC Male to 3.5 adapter connector stable performance long lifespanLG 18P straight handle1 connector cellphone connector LG mobile phone connectorBMW Logo Shaped 4Gb USB 2.0 Flash Storage Drive1Gb USB 2.0 Flash MemoryLeather Button 2Gb USB 2.0 Flash Storage DriveMini USB Bluetooth Wireless PC Adapter Dongle T LikeUSB 2.O TO Mini 18 p Data Charger Retractable Cable for LG PhoneUSB 2.0 + Firewire 1394 2.5" IDE Hard Drive EnclosureUSB A/F short body DIP 90° dual port (bend angle with bulge L=17.5mm) connector socket adapter868 IDE to SATA adapter plug and play high-speed 2A transformer transmission cardUSB A/F to PS/2 6P Male adapter connector with long life time OEMHDMI-08E.HDMI 19P/M wire solder HDMI connector HDMI high definition data plug Replica lv Hangbags Replica Hangbags Hangbags replica handbags replica handbags replica handbags replica handbags usb cable usb cable usb cable usb cable usb flash drives