Copy Database Wizard遇到的问题

towdney 2008-05-13 09:19:50

正在把数据库从SQL Server 2000 升级到 SQL Server 2005,遇到了问题，要升级的数据库，状态显示OK;replicated，不让升级，我检查过目标数据库2005里确实没有重复的数据库，之前有重名的都删除了。

...全文

94 3 打赏收藏转发到动态举报

写回复

3 条回复

切换为时间正序

请发表友善的回复…

发表回复

towdney 2008-05-27

打赏
举报

回复

看来很少人有这方面的经验哦？都半个月了还没有人回复。

towdney 2008-05-21

打赏
举报

回复

有高手有这方面经验么？

tektite 2008-05-20

打赏
举报

回复

没试过直接升级，占个位学习下。

sqlserver2000升级到2005.doc

SQL数据库备份、还原、转移详解,SQL数据库备份、还原、转移详解

SQLite Expert is a powerful visual tool that enables you to easily administer your SQLite3 databases and gain significantly better visibility into how your databases are operating. SQLite Expert integrates database management and maintenance into a single, seamless environment, with a clear and intuitive graphical user interface. Homepage: www.sqliteexpert.com Features include: 1. Modify table structure visually without losing data already existing in the database. SQLite Expert will automatically create a new table with the new structure and copy the data from the old table. All the operations are wrapped in a transaction which is rolled back if any error occurs during the process. 2. Build SQL scripts visually using the integrated Query Builder. 3. Create SQLite3 databases, view and change database parameters, check database integrity and vacuum (compact) database. 4. The Data Transfer Wizard allows import/export from/to SQL script, another SQLite database or an ADO data source. 5. Display and edit data in the grid, including BLOB and image fields. Currently supports BMP, JPG and PNG image formats. 6. BLOB fields can be edited with the integrated hex editor. 7. Execute SQL queries. Supports multiple SQL statements in the same query. 8. In-grid editing of live queries. 9. Save/Load SQL scripts to/from file. 10. Transaction support. SQLite supports one level of transactions. 11. Data mapping. SQLite Expert supports custom data types, and 40 predefined data types. 12. Extend and enhance SQLite Expert using Lua or Pascal scripts. System Requirements Operating System: Windows 2000/XP/2003/Vista SQLite - sqlite.dll version 3.x. (included)

SQLite3 数据据管理工具图形界面 SQLite Expert is a powerful visual tool that enables you to easily administer your SQLite3 databases and gain significantly better visibility into how your databases are operating. SQLite Expert integrates database management and maintenance into a single, seamless environment, with a clear and intuitive graphical user interface. Homepage: www.sqliteexpert.com Features include: 1. Modify table structure visually without losing data already existing in the database. SQLite Expert will automatically create a new table with the new structure and copy the data from the old table. All the operations are wrapped in a transaction which is rolled back if any error occurs during the process. 2. Build SQL scripts visually using the integrated Query Builder. 3. Create SQLite3 databases, view and change database parameters, check database integrity and vacuum (compact) database. 4. The Data Transfer Wizard allows import/export from/to SQL script, another SQLite database or an ADO data source. 5. Display and edit data in the grid, including BLOB and image fields. Currently supports BMP, JPG and PNG image formats. 6. BLOB fields can be edited with the integrated hex editor. 7. Execute SQL queries. Supports multiple SQL statements in the same query. 8. In-grid editing of live queries. 9. Save/Load SQL scripts to/from file. 10. Transaction support. SQLite supports one level of transactions. 11. Data mapping. SQLite Expert supports custom data types, and 40 predefined data types. 12. Extend and enhance SQLite Expert using Lua or Pascal scripts. System Requirements Operating System: Windows 2000/XP/2003/Vista SQLite - sqlite.dll version 3.x. (included)

34,838

社区成员

254,632

社区内容

发帖

与我相关

我的任务

社区管理员

加入社区

近7日
近30日
至今

加载中

查看更多榜单

社区公告

暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章