SQL Comparison SDK - 10.0
Licensing for ASP.NET applications - SQL Comparison SDK
If you are using the SQL Comparison SDK in an ASP.NET application, web service, or website, you may encounter errors when licensing the application.
When you first compile an application using the SQL Comparison SDK, a dialog box is displayed prompting you to enter a serial number. The license information you enter is embedded in an assembly. Subsequent builds will succeed silently, and users will not be prompted for licensing information.
ASP.NET 2.0 compiles dynamically, so you cannot follow this standard licensing procedure for web applications.
To use the SQL Comparison SDK in ASP.NET applications, you are recommended to create a separate library (DLL) containing the SQL Comparison SDK functions you want to use. This DLL can be licensed normally when it is compiled, and then referenced in the ASP.NET project.
It may be necessary to license your application using the .NET Framework SDK, for example if the application is compiled by an automated build server. Instructions for this are provided below.
Note that it is not currently possible to license an ASP.NET application if you are using the 14 day free trial version of the SQL Comparison SDK. To license a web application, you must have a valid serial number, or contact support.
Licensing using the .NET Framework SDK
To license an ASP.NET application that uses the SQL Compare API:
- Create a text file called License.txt, listing the licensed components. In this example, type:
RedGate.SQLCompare.Engine.Database, RedGate.SQLCompare.Engineand save the file to the folder containing the source code for the project.
- From the Visual Studio command prompt, use the License Compiler to create the .licenses file:
lc /target:ApplicationName.Licenses.Resources.dll /complist:licence.txt/i:"C:\Program Files\Red Gate\SQL Comparison SDK 8\Assemblies\SQL Compare\RedGate.SQLCompare.Engine.dll"Note that /i:<module> specifies the location of the components referenced by /complist. In this example, there is only one: RedGate.SQLCompare.Engine.dll
To specify additional components, use a separate /i switch for each one.
- Enter the serial number when prompted.
- From the Visual Studio command prompt, use the Assembly Linker to embed the .licenses file in a library:
al /t:lib /embed:ApplicationName.Licenses.Resources.dll.licenses/culture:neutral /out:ApplicationName.Licenses.Resources.dll - Copy the library ApplicationName.Licenses.Resources.dll into the Bin folder of the web application.
Licensing is now set up.
For more information on using the .NET framework SDK, refer to your .NET Framework documentation.
See also |
Was this article helpful?
SQL Comparison SDK
- Licenses.licx is not a valid Win32 application
- Application licensing invalidated by renaming assembly
- Excluding a table from a data comparison
- Manually licensing Red Gate assemblies
- RedGate.Licensing.Helper.dll is attempting managed execution inside OS Loader lock
- Troubleshooting SQL Comparison SDK licensing
- SQL Compare synchronization error 'Full-Text Search is not installed'
- Using SQL Data Compare mappings in projects using the API
- Licensing automated builds with NAnt
- Licensing ASP .NET applications
- Running SQL code inside SQL Comparison SDK applications
- Creating an HTML report of schema differences in C#
- Creating a synchronization script without batch markers
- Creating an HTML report of schema differences in Visual Basic .NET
- SQL Toolkit has become SQL Comparison SDK
- SQL Comparison SDK column mapping
- Executing your own SQL queries together with SDK synchronization
- Error 1603 occurring during installation
- Licensing SDK applications in Visual Studio 2010
all SQL products
- Compatibility of Red Gate tools in 64-bit environments
- Application has encountered an error and needs to close
- Error message after installing SQL Toolbelt - The description for Event ID ( 1 ) in Source ( nview_info ) cannot be found.
- Changing the temporary directory used by the installer
- Toolbelt Installer "hanging" while "scanning volumes"
- Login failing with "trusted SQL Server connection" error when using RunAs
all products
- Some Red Gate products identified as containing a trojan by Anti-Virus software
- Activation may fail with Unknown Error -1
- Product uses web help although a CHM file is available locally
- Argument exception resulting from missing environment variable
- Check for updates may fail when used through proxies
- 'Unidentified Publisher' error when repairing or uninstalling
- Licensing activates product as standard edition
- Moving Red Gate software products to another machine
- Red Gate tools log locations
- The application UI opening slowly when there is no internet access
SQL Comparison SDK
all SQL products
all products
- Red Gate product acknowledgements
- Activating your products
- Activating your products
- Red Gate bundle history
- Check for updates
- Troubleshooting Check for Updates errors
- Current versions
- Deactivating your products
- Installing Red Gate products from the .msi file
- Requesting additional activations
- Serial numbers for bundles
- Reactivating using a different serial number
- Extending your trial
- Finding your serial numbers
- Moving a serial number from one computer to another
- No response received for manual activation
- Licensing and activation resources
- Licensing and activation resources
- Troubleshooting licensing and activation errors
- Licensing and activation FAQs
- Red Gate tools log file locations
- Download old versions of products
- Download product prerequisites & utilities
- Support & upgrades
- Upgrading your software
- Upgrading FAQs

Licensing and distribution