34,874
社区成员
发帖
与我相关
我的任务
分享对一个数据库Generate SQL script后，不能还原
我对一个数据库Generate SQL script后，生成db.sql。
在Analyzer里运行db.sql，有错误：
有N行这样的
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'dbo.dt_displayoaerror_u'. The stored procedure will still be created.
还有：
Server: Msg 450, Level 16, State 1, Procedure sp_updDet, Line 38
Code page translations are not supported for the text data type. From: 936 To: 1252.
是不是在Generate SQL script的时候有某些选项没选好？还是什么原因？
谢谢
在Analyzer里运行db.sql，有错误：
有N行这样的
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'dbo.dt_displayoaerror_u'. The stored procedure will still be created.
还有：
Server: Msg 450, Level 16, State 1, Procedure sp_updDet, Line 38
Code page translations are not supported for the text data type. From: 936 To: 1252.
是不是在Generate SQL script的时候有某些选项没选好？还是什么原因？
谢谢
...全文
请发表友善的回复…
发表回复
NinGoo 2004-12-16
- 打赏
- 举报
建议楼主迁移数据库可以采用下面的做法：
1.备份该DB
2.copy备份文件到目的SQL Server上
3.恢复该备份到新的SQL Server
1.备份该DB
2.copy备份文件到目的SQL Server上
3.恢复该备份到新的SQL Server
NinGoo 2004-12-16
- 打赏
- 举报
有N行这样的
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'dbo.dt_displayoaerror_u'. The stored procedure will still be created.
=>Generate SQL Scripts时选中Generate scripts for all dependent object
Server: Msg 450, Level 16, State 1, Procedure sp_updDet, Line 38
Code page translations are not supported for the text data type. From: 936 To: 1252.
=>原DB的collation和你运行db.sql的server的collation不一致，所以会做转换，但是text类型的数据不支持从简体中文(936)转换到拉丁 1 字符 (ANSI) (1052)
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'dbo.dt_displayoaerror_u'. The stored procedure will still be created.
=>Generate SQL Scripts时选中Generate scripts for all dependent object
Server: Msg 450, Level 16, State 1, Procedure sp_updDet, Line 38
Code page translations are not supported for the text data type. From: 936 To: 1252.
=>原DB的collation和你运行db.sql的server的collation不一致，所以会做转换，但是text类型的数据不支持从简体中文(936)转换到拉丁 1 字符 (ANSI) (1052)
