sql2000数据库导入到sql2005的兼容性问题
二月 15th, 2009
今天把sql2000中的northwind库使用附加的方式导入到sql2005中，发现其他都正常，就是diagram功能无法使用。提示
------------------------------
Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.
------------------------------
按提示做了一下，发现并不能解决问题。查阅了一下资料，原来是一个兼容性的问题。在２００５中，引入了一个Diagram Support Objects的概念，用来处理Diagram,使用附加或还原的方式时，如果数据库的onwer和原来实例的登录名不一致时就会发生这样的错误。
解决方法，不算复杂：
在 SQL Server Management Studio 中如下处理
1. database右键菜单选择properties
2. 选择Options选项页
3. 将"Compatibility Level" 设置为 "SQL Server 2005(90)"
4. 选择Files选项页
5. 将owner修改为"sa"
6. 搞定
＠benben 什么意思？
＠徐明 怎么新版的永久链接好像不能修改了啊.好郁闷....
@yinheli bulkload.
明兄,没有开发关闭评论的功能么?
还有请问,本地测试的,如何只上传数据库? 不用博客的导入功能
谢谢，马上修改
明兄，报告一个小BUG
在ubuntu环境下使用firefox登陆进后台，在写文章那个界面
标题的那个input会延伸至屏幕最右边，导致挡住右边的选择目录那一块，无法操作
解决办法：
修改static/admin/style.css
添加一行
#titlewrap input{width:100%}
望兄台在下个版本发布时修改一下
Skip to page content Skip to main navigation English ▼ | Site Directory
e.g. "templates" or "datastore"
Google App EngineHome Docs FAQ Articles Blog Group Terms Download Downloads System Status Issue Tracker IntroductionWhat Is Google App Engine? Getting Started: PythonIntroduction The Development Environment Hello, World! Using the webapp Framework Using the Users Service Handling Forms With webapp Using the Datastore Using Templates Using Static Files Uploading Your Application Quotas The Admin Console PythonRuntime ToolsConfiguration Development Server Uploading an App Uploading Data webapp FrameworkOverview Running the Application Request Handlers Request Data Building the Response Redirects, Headers and Status Codes ReferenceRequest Response RequestHandler WSGIApplication Utility Functions Service APIs DatastoreOverview Entities and Models Creating, Getting and Deleting Data Keys and Entity Groups Queries and Indexes Transactions ReferenceModel Expando PolyModel Property Query GqlQuery Key Functions Types and Property Classes GQL Reference Exceptions MemcacheOverview Using Memcache ReferenceClient Functions URL FetchOverview ReferenceThe fetch Function Response Objects Exceptions MailOverview Sending Mail Attachments ReferenceEmailMessage Message Fields Functions Exceptions ImagesOverview Installing PIL Using the Images API ReferenceImage Functions Exceptions Google AccountsOverview User Objects Login URLs Admin Users ReferenceUser Functions Exceptions Using Google Data Services ResourcesFAQ Articles Cookbook App Gallery SDK Code Sample Apps Code Discussion Groups Product Roadmap Release Notes Revision History More Google App Engine resource links Downloads
Download the Google App Engine SDK
Download the Google App Engine Documentation
Download the Google App Engine Buttons
Download the Google App Engine SDK
Before downloading, please read the Terms that govern your use of the App Engine SDK.
Please note: The App Engine SDK is under active development, please keep this in mind as you explore its capabilities. See the SDK Release Notes for the information on the most recent changes to the App Engine SDK. If you discover any issues, please feel free to notify us via our Issue Tracker.
Platform Version Package Size SHA1 Checksum
Windows 1.1.9 - 02/09/09 GoogleAppEngine_1.1.9.msi 2.7 MB c0a09f23950de606a4c4933687335582c18bd3cd
Mac OS X 1.1.9 - 02/09/09 GoogleAppEngineLauncher-1.1.9.dmg 3.8 MB d8ca6afa091fea1e48e2132454a71bf7ecbfd627
Linux/Other Platforms 1.1.9 - 02/09/09 google_appengine_1.1.9.zip 2.8 MB aa11e2e6940071cf61c3092b2365605a01d739e7
For more information on the SDK:
Getting Started Guide
Open Source
Mirrors of the open source App Engine SDK are available via the Google App Engine project page hosted on Google Code.
Download the Google App Engine Documentation
You can download an archive of the Google App Engine documentation to keep on your computer and read while not connected to the Internet.
Description Version Package Size
Google App Engine documentation January 15, 2009 google-appengine-docs-20090115.zip 2.0 MB
Download the Google App Engine Buttons
You can use these buttons on your site to indicate it is powered by Google App Engine.
Description Button Image Code Snippet
120x30 no border GIF <img src="http://code.google.com/appengine/images/appengine-noborder-120x30.gif"
alt="Powered by Google App Engine" />
120x30 silver button GIF <img src="http://code.google.com/appengine/images/appengine-silver-120x30.gif"
alt="Powered by Google App Engine" />
Except as otherwise noted, the content of this page is licensed under a Creative Commons license, and examples are licensed under an Apache license.
©2009 Google - Code Home - Terms of Service - Privacy Policy - Feedback - Site Directory
Google Code offered in: 中文 - English - Português - Pусский - Español - 日本語 中文 (简体)EnglishPortuguês (Brasil)PусскийEspañol日本語Suggestions