|
|
|
|
|
DBSourceTools - Home
参考：http://dbsourcetools.codeplex.com/
DBSourceTools 是一个 GUI 实用工具，以帮助开发人员在源代码管理下使 SQL Server 数据库。功能强大的数据库脚本、 代码编辑器、 sql 生成器和数据库版本控制工具。比较架构、 创建比较脚本、 轻松地编辑 T-SQL。比管理工作室更好。
DBSourceTools is a GUI utility to help developers bring SQL Server databases under source control. A powerful database scripter, code editor, sql generator, and database versioning tool. Compare Schemas, create diff scripts, edit T-SQL with ease. Better than Management Studio.
Current Release : 1.3.0.0
Release 1.3.0.0
- Changed TextEditor from FireEdit to ICSharpCode.TextEditor
- Highlight both field and table names in scripts ( in blue ) - see screenshot below
- Re-built Intellisense engine
- Intellisense now pops up while writing sql scripts
- DBExplorer Updates
- Added field dropdown on all tables and views in DBExplorer.
- Added data option for viewing data in Views.
- Fixed reported bugs
- Include Synonyms in scripting engine (nickt_ch)
- Fixed comment / uncomment (tareq)
To view release history, go here Release History
Help needed testing and updating Intellisense.While every effort has been made to correctly suggest Intellisense options, I feel that there are a lot more cases that I should be checking for.
If you find that Intellisense is not working for you correclty, please could you send me a sample sql script that I can plug in to the Intellisense engine.
Better yet, send me a patch.
Have a look at the tests in TestICSharpCode.MSSQLExtensions for some Intellisense samples.
Where in the world are you ?Find out where DBSourceTools is used, or show us where you are :
http://www.ohloh.net/p/dbsourcetools
Wiki Pages:Quick Start Guide
Using Source Code Control
Using Intellisense
Project BackgroundDon't use a DEV database server
Too often, developers use a central "dev" database during development.
This leads to any number of frustrating problems:
- Developers break each others code.
- Developers get frustrated when someone else breaks their code.
- Development time is slow.
- There is no version control over database objects and scripts.
Use a Local database copy
Here's how to alleviate these problems:
- Give each developer their own local version of the database.
- Script all database objects to disk, and place them under version control.
- Easily get the latest version, and re-create your local database.
And lastly...
- Microsoft SQL Server Management Studio (2005) has a very limited script editor:
- No automatic begin / end section highlighting
- No collapsible regions
- No search facility
- You have to right-click and select "Script Object as " | "Create to" | "New query editor window" every time you want to edit an object.
- You have to remember to use ALTER or CREATE in your script when making changes.
Enter DBSourceToolsInspired by all of the above, as well as Microsoft's Visual Studio for Database Professionals, DBSourceTools was born:
Feature List
- Tested on SQL 2000, 2005, 2005 Express, 2008 Express, 2008 Dev Edition. (no support for SQL CE).
- One-click action to script a database to disk.
- Easily deploy a database through "Deployment Targets".
- Script from one version of SQL to another
- From 2000 to 2005 to 2008, or
- From 2008 to 2005.
- Verify database integrity during deployment.
- Automatically takes care of object dependencies.
- Automatically excludes computed columns on data load.
- Use the enhanced script-editor to edit tables / stored procedures / etc.
- Search database scripts.
- Double-click to edit stored procedures and tables.
- Double-click to view table data.
- Dock / float windows
Next >> Quick Start Guide
|
|
|
|
程序开发