开发者社区> 杰克.陈> 正文
阿里云
为了无法计算的价值
打开APP
阿里云APP内打开

Red Gate系列之八 SQL Connect 1.1.1.19 Edition 数据库连接及操作工具 完全破解+使用教程

简介: 原文:Red Gate系列之八 SQL Connect 1.1.1.19 Edition 数据库连接及操作工具 完全破解+使用教程 Red Gate系列之八 SQL Connect 1.1.1.19 Edition 数据库连接及操作工具 完全破解+使用教程 Red Gate系列文章: Red Gate系列之一 SQL Compare 10.
+关注继续查看
原文:Red Gate系列之八 SQL Connect 1.1.1.19 Edition 数据库连接及操作工具 完全破解+使用教程

Red Gate系列之八 SQL Connect 1.1.1.19 Edition 数据库连接及操作工具 完全破解+使用教程

Red Gate系列文章:

Red Gate系列之一 SQL Compare 10.2.0.1337 Edition 数据库比较工具 完全破解+使用教程

Red Gate系列之二 SQL Source Control 3.0.13.4214 Edition 数据库版本控制器 完全破解+使用教程

Red Gate系列之三 SQL Server 开发利器 SQL Prompt 5.3.4.1 Edition T-SQL智能感知分析器 完全破解+使用教程

Red Gate系列之四 SQL Data Compare 10.2.0.885 Edition 数据比较同步工具 完全破解+使用教程

Red Gate系列之五 .NET Reflector 7.6.1.824 Edition .NET程序反编译神器(另附插件安装教程) 完全破解+使用教程

Red Gate系列之六 SQL Test 1.0.12.3 Edition SQL测试工具 完全破解+使用教程

Red Gate系列之七 SQL Search 1.1.6.1 Edition SQL查询分析工具使用教程

Red Gate系列之八 SQL Connect 1.1.1.19 Edition 数据库连接及操作工具 完全破解+使用教程

一、使用教程

Connected database development in your Solution Explorer
This document last updated: 9 July 2012
Introduction
With SQL Connect, you can modify and source control databases in Microsoft Visual Studio alongside your existing projects.
SQL Connect projects are compatible with SQL Source Control and SQL Compare, so you and your team can work on databases in Visual Studio or SQL Server
Management Studio and share your changes with your preferred source control tool.
Installing SQL Connect
SQL Connect is an add-in for Microsoft Visual Studio. Ensure Visual Studio is already installed before installing SQL Connect.
To install SQL Connect:
1. Download the SQL Connect installer.
2. Run the installer and follow the instructions.
Creating a SQL Connect project
To create a new SQL Connect project:
1. Open Visual Studio.
2. In the SQL Connect window, click Create New SQL Connect Project. (If the SQL Connect window is not displayed, select SQL Connect under View.) Alternatively,
under File, go to New, and click New Project.
The New Project dialog box is displayed:

3. Under Installed Templates, select SQL Connect.

4. In the lower pane, specify a name and location for your project, and click OK.

The Create New SQL Connect Project window is displayed:

5. Select the development database you want to use in your project, and click Create.
A database project is added to your Visual Studio solution:

Using an existing SQL Source Control database
SQL Connect can import databases linked to SQL Source Control 3.0.9 or higher, so teams can share databases whether they use Visual Studio or SQL Server
Management Studio.
To use an existing SQL Source Control database, you must first check out the database repository to a folder on your computer using your preferred source control
system. For more information, refer to your source control system's documentation.
Importing from SQL Source Control
To do this:
1. In the SQL Connect window, click Import From SQL Source Control. (If the SQL Connect window is not shown, select SQL Connect under View.)
The Import From SQL Source Control dialog box is displayed:

2. Click Browse, select your database folder (the folder your repository is checked out to), and click OK.
3. Click Import.
A database project is added to your Visual Studio solution:

4. Right-click the database project, and select Properties:

A new tab is displayed:

5. Select the development database you want to use in your project, and click Save in the Visual Studio toolbar.
The database is linked to your project.

synchronize the change

1.From the Solution Explorer window, you can right-click your project and then add it to source control:

 2.Select the Team Project and then specify a location:

 3.As an example, I’ll modify an existing table:

 4.Now, all that’s left is to synchronize the change:

SQL Connect overview
SQL Connect works by creating files in your project that represent the contents of your database. After you edit a database, the changes can be synchronized to the files
in your project. (Alternatively, you can edit the files and synchronize the changes backwards to the database.)

The files in your project can be checked in to source control using a third-party source control tool such as Subversion or Team Foundation Server. Members of your
team can then check out source-controlled files and synchronize them with their database, applying the changes you made.
Modifying a database
Modifying a database directly
To modify your database directly:
1. In the Solution Explorer, double-click an object you want to edit.
The object is displayed in a query window or graphical designer;

2. Make the changes you want, and click Execute Query (labelled Apply Changes to Database in some cases).
SQL Connect notifies you that the project and the database have become unsynchronized:

3. Click Synchronize to synchronize your database changes to the project.
Modifying a database by editing a SQL creation file
To modify your database by editing a project file:
1. In the Solution Explorer, right-click the object you want to edit.
2. Select Edit SQL File in Project:

The object is displayed in a document window:

3. Make the changes you want, and click Save Changes.
SQL Connect notifies you that the project and the database have become unsynchronized:

4. Click Synchronize to apply your changes to the database.

5.Click Edit SQL File in Project

6.Edit SQL

7.See and Edit for Table Designer

8.Edit Column

9.See View Data

10.Add and Edit Data

11.New Query

12.Use SQL Prompt Edit SQL

13.Select Table's Data

14.New Function,Stored Procedure,Table,View and More...

15.Edit Function,Stored Procedure,Table,View and More...

See Getting started guide(PDF)


 As a big fan of SQL Compare and after being impressed by SQL Source Control, I was excited when I got a message to try out a new Red Gate product, SQL Connect.

While SQL Source Control and SQL Connect offer the same underlying ability – adding a database to source control – the key difference is that SQL Source Control works in tandem with SQL Server Management Studio whereas SQL Connect allows the ability to work on your database directly from Visual Studio.

The ability to continue working on different aspects of an application without switching environments is a blessing – think of the amount of time that’s lost and the disruptions that you usually go through tabbing through open windows or using preview windows. Some key benefits are:

  • I’m mentioning it again because it really is critical: the ability to work on application-related and database-related projects in a single development environment.
  • Ability to create and execute queries and stored procedures from Visual Studio.
  • If some team members are already using SQL Source Control, SQL Connect can use the same repository.

The setup process is straightforward and simple so let’s go through a new installation.

1. If you don’t have a TFS hosting account, use the sign-up form and take advantage of the 30-day free trial that we offer.

2. Make sure that you have configured your client and I’d recommend creating a new Team Project using the instructions available in our knowledge base if you’re evaluating SQL Connect.

3. Before proceeding any further, take a look at the software requirements for SQL Connect.

4. If you have Visual Studio open, save any work and then close all instances that you have open.

5. Download the 28-day trial version of SQL Connect and then run the installer. Make sure that SQL Connect is selected and you can un-check SQL Prompt.


 二、破解教程

打开Visual Studio -- 视图 -- SQL Connect

单击Help -- Enter Serial Number

打开Keygen注册机复制序列号到Activate SQL Connect窗口的文本框中

单击Activate注册,稍等一会会出现未能解析此远程名称:'licensing.red-gate.com'(请先断网再注册)

单击Activate Manually(离线注册)

复制1到2,复制3到4,然后单击Finish完成离线注册

查看注册信息,破解成功!

See Help and Download:http://www.red-gate.com/products/sql-development/sql-connect/getting-started/

or:http://downloads.red-gate.com/SQLDeveloperBundle.exe

Adapted from:http://blog.discountasp.net/using-red-gate-sql-connect-with-discountasp-net-team-foundation-server/

Crack and Keygen:http://download.csdn.net/download/caizz520/4611606

未完,待续。

转载的朋友,请不要删除以下行,对此,表示感谢!!!

原文来自VAllen cnblogs链接:http://www.cnblogs.com/VAllen/archive/2012/10/01/SQLConnect.html

版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。

相关文章
【Sql Server】with as 递归查询的简单使用 以及在视图工具下的使用 注意小事项一
with as 递归查询的简单使用 以及在视图工具下的使用 注意小事项一
0 0
Python 数据库Insert语句脚本生成工具(SQL Server)
Python 数据库Insert语句脚本生成工具(SQL Server)
0 0
MySQL性能监控(sql命令语句 & MONyog工具)全掌握,这一篇足以!
MySQL性能监控(sql命令语句 & MONyog工具)全掌握,这一篇足以!
0 0
Python-sqlparse解析SQL工具库一文详解(二)
Python-sqlparse解析SQL工具库一文详解(二)
0 0
Python-sqlparse解析SQL工具库一文详解(一)
Python-sqlparse解析SQL工具库一文详解(一)
0 0
SQL调优的工具
SQL调优的工具
0 0
Java工具篇之Druid SQL语法解析树
本篇主要学习Druid 对Sql的语法解析。学习完之后,我们可以对任意sql进行解析,同时也可以基于AST语法树来生成sql语句。
0 0
10款优秀的SQL Server服务器监控工具
服务器是网络中最重要的资源之一,SQL Server的广泛普及使SQL Server监控工具成为长期网络维护的先决条件。使用服务器监控工具跟踪服务器的运行状况可以为你提供解决性能问题所需的信息。
0 0
几个必须掌握的SQL优化技巧(四):使用Trace工具分析优化器执行计划
在应用的开发过程中,由于开发初期的数据量一般都比较小,所以开发过程中一般都比较注重功能上的实现,但是当完成了一个应用或者系统之后,随着生产数据量的急剧增长,那么之前的很多sql语句的写法就会显现出一定的性能问题,对生产的影响也会越来越大,这些不恰当的sql语句就会成为整个系统性能的瓶颈,为了追求系统的极致性能,必须要对它们进行优化。
0 0
有了这 4 款工具,老板再也不怕我写烂SQL了 良许Linux 2020-04-13 07:33
对于正在运行的mysql 性能如何?参数设置的是否合理?账号设置的是否存在安全隐患? 是否了然于胸? 俗话说工欲善其事,必先利其器,定期对你的MYSQL数据库进行一个体检,是保证数据库安全运行的重要手段。
0 0
+关注
杰克.陈
一个安静的程序猿~
文章
问答
文章排行榜
最热
最新
相关电子书
更多
用SQL做数据分析
立即下载
阿里云流计算 Flink SQL 核心功能解密
立即下载
Comparison of Spark SQL with Hive
立即下载