redgate toolbelt

see the historical version record of a database object, you need to search for it in SVN, and the display is not intuitive. Another problem is that the development DBA in the team is very reluctant to use SVN. Store version records to the database I have seen this method on the Internet. It records database change operations through triggers in the database. As a developer, this method is not very popular. Besides, finding version modification records in the History Table is time-consuming and

We can see that everyone is very concerned about the continuous integration of databases in CI! In order to provide a little complete information earlier and let everyone have actual operations, I adopted another method to increase the speed: The methods described in this article are as follows:. NET DeliveryThe implementation in this book is not exactly the same in my implementation, and the materials have not yet been sorted out. The key tool I mentioned in the previous article on CI is the d

The interface is designed to be manual and cannot be used to modify thousands of servers in batches. Because this script is executed in batches. Environment: redgate + mssql 2008 r2 The following code is used when you modify your business. Copy codeThe Code is as follows: -- allow system table updates Exec sp_configure 'Allow updates', 1 Reconfigure with override GO -- Unmark the ID column Update syscolumns set colstat = 0 where id = object_i

your ASP. NET Website needs to access a database, you should use the object framework of LINQ to Entities. Using LINQ, some magical queries written in C # are converted into SQL queries. If you are not careful when writing a LINQ query, you may accidentally build a website with poor performance. LinqPad (LinqPad's official site: http://www.linqpad.net/) is a free tool that lets you experiment with your LINQ queries. It even supports Microsoft SQL CE 4 and Azure. You can use LinqPad to execute a

Smartassembly provides a method to optimize and confuse your. netProgramTo protect your work and software, reduce the size of the distribution package, and improve program performance. Visual Studio 2003/2005/2008 integrates a dotfuscatorCommunityVersion of the tool, the function is very simple, easy to use, specific operations can be referred to the followingArticle: Use of dotfuscator in Visual Studio 2008 Here, demonstrate the use of smartassembly obfuscation tool, the tool features relativ

Through the interface design is able to manually operate, can not achieve my batch modification thousands of servers. Because of this a foot would have been executed in bulk. Environment: Redgate + MSSQL 2008 R2 The following code is used as a minor modification to your business. Copy Code code as follows: --Allows system tables to be updated EXEC sp_configure ' allow updates ', 1 Reconfigure with override Go --Suppress identity column t

Plsql is a very powerful tool, but you won't use it.1. Remember the password:First tools, preferences openLogin History definition under Oracle option with password store--tick2. Keyword highlighting-------------------the wrong keywords are always written incorrectlySyntax highlighting, location user interface, editor, and keyword capitalization select uppercase3. NULL to display highlighting. --often do not know whether a space or null is used.Window type->sql window, null value cell colorThe c