Copying Data from One Database to Another
First setup a link server to the other database.
.NETADO.NETAgileAngularArchitectureASP.NETAuthenticationAzureAzure FunctionBIBig DataBlazorBusinessC#Cloud ServiceCosmosDBCSSDebuggingDesignEncryptionEntity FrameworkFYIGoogleHardwareInternetInterviewsJavascriptjQueryLeadershipLINQManagementMicrosoftMobileMS OfficeMS SQLNetworkingNoSQLOOPProject ManagementSoftware DevelopmentSource ControlSSISSSRSSyncfusionTeamTestingTSQLUncategorizedVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress
What is best tool to compare two SQL Server databases (schema and data)?
Microsoft Visual Studio Community Edition (Free) has a tool called Data Compare and Schema Compare. Visual Studio -> Tools -> SQL Server Red-Gate http://www.red-gate.com/products/sql-development/sql-compare/ http://www.red-gate.com/products/sql-development/sql-data-compare/
RedGate Error: We don’t have DMV queries available for SqlServer2014
Error: We don’t have DMV queries available for SqlServer2014 Fix: Upgrade to RedGate version 12+. SQL Server 2016 is only supported by SQL Compare 12. Sources: https://forum.red-gate.com/discussion/81091/does-red-gate-compare-engine-11-1-0-2-work-with-microsoft-sql-server-2016-13-0-4202-2-x64
SSIS Logging: Write to File
Execute as “Script Task”.
SSIS Connection Manager Not Saving Changes
Problem: The Connection manager has been configured to be updated in Package Configuration. Solution: Go to “Control Flow” tab -> right click -> Package Configurations Set to point to new configuration file. Source: https://social.msdn.microsoft.com/Forums/security/en-US/8fb47c45-f1d9-4eaa-a2a1-f126ccbc1ef2/connection-manager-changes-are-not-saved-after-edit-the-package-still-retains-the-old-server-name?forum=sqlintegrationservices https://social.technet.microsoft.com/Forums/officeocs/en-US/7a9f1ea3-7dbf-4389-9856-9ad745c9e9fe/ssis-connection-manager-not-saving-changes?forum=sqlintegrationservices
Working with Quotes In String
Replace quotes in string. Generating quotes in string. Ex: label.setObjectText(“Barcode1”, “1008800400002”); Display quotes string in razor.
Outer / Cross Apply
SQL Server 2005 introduced the APPLY operator. SQL Server APPLY operator has two variants; CROSS APPLY and OUTER APPLY The CROSS APPLY operator returns only those rows from the left table expression (in its final output) if it matches with the right table expression. In other words, the right table expression returns rows for the... » read more
Data Flow Task
The Data Flow task encapsulates the data flow engine that moves data between sources and destinations, and lets the user transform, clean, and modify data as it is moved. Addition of a Data Flow task to a package control flow makes it possible for the package to extract, transform, and load data. A data flow... » read more
Execute Process Task
The Execute Process task runs an application or batch file as part of a SQL Server Integration Services package workflow. Although you can use the Execute Process task to open any standard application, such as Microsoft Excel or Microsoft Word, you typically use it to run business applications or batch files that work against a... » read more
Foreach Loop Container
The Foreach Loop container defines a repeating control flow in a package. The loop implementation is similar to Foreach looping structure in programming languages. In a package, looping is enabled by using a Foreach enumerator. The Foreach Loop container repeats the control flow for each member of a specified enumerator. SQL Server Integration Services provides the following... » read more