SQL Clone 2

SQL Clone 2 release notes

October 4, 2018 - SQL Clone 2.8.0

This release of SQL Clone includes the following enhancements and bug fixes:

Features

  • Clones can now be reset to their initial state from the dashboard
  • Improved the preview dashboard's recent activity widget
  • Added optional parameters -KeepCdc, -BufferCount and -MaxTransferSize to the New-SqlCloneImage cmdlet for creating image from backup

Fixes

  • Improved error message when trying to create an image from a backup file containing multiple backups
  • Image creation from backup is now correctly canceled when syntax errors exist

September 24, 2018 - SQL Clone 2.7.9

This release of SQL Clone includes the following enhancements and bug fixes:

Features

  • Clones can now be reset to their initial state from the dashboard
  • Toast notification on activity started, finished and succeeded

Fixes

  • Fixed an issue where an error was incorrectly shown when deleting an image or clone that failed to create
  • Prevent race conditions between monitoring clones and deleting clones

September 12, 2018 - SQL Clone 2.7.8

This release of SQL Clone includes the following enhancements and bug fixes:

Features

  • Preview of a new Activity page, showing a history of what's been created and deleted

Fixes

  • Fixed an issue where temporary instance logins weren't dropped under some error conditions
  • Improved behaviour around cancelling operations

September 7, 2018 - SQL Clone 2.7.7

This release of SQL Clone includes the following enhancements and bug fixes:

Features

Fixes

  • Fixed a very rare issue where a clone database could be incorrectly deleted during loss of access to its image

August 29, 2018 - SQL Clone 2.7.6

This release of SQL Clone includes the following enhancements and bug fixes:

Features

  • Images can now be renamed from the dashboard
  • Added button on About page to retrieve all SQL Clone logs

Fixes

  • Fixed an issue preventing users from closing error messages on low-resolution displays
  • Modification scripts now support creating & altering procedures, functions, views, triggers, and schemas
  • Fixed an issue where cancelling clone creation could lock up the working agent

August 20, 2018 - SQL Clone 2.7.5

This release of SQL Clone includes the following enhancements and bug fixes:

Features

Fixes

  • Rename-SqlCloneImage now gives a descriptive error message upon failing
  • The SQL Clone Server config database can now be hosted on Azure SQL DB

August 3, 2018 - SQL Clone 2.7.4

This release of SQL Clone includes the following enhancements and bug fixes:

Features

  • Images and clones can now be searched for by name from dashboard

Fixes

August 2, 2018 - SQL Clone 2.7.3

This release of SQL Clone includes the following enhancements and bug fixes:

Features

  • Added the ability to reset a clone to its initial state using the Reset-SqlClone cmdlet

Fixes

  • Increased timeout for creating clone
  • Fix for the 'Need to mask your data?' box moving out of place in small browser windows

July 26, 2018 - SQL Clone 2.7.2

This release of SQL Clone includes the following enhancements and bug fixes:

Features

  • Get-SqlCloneSqlServerInstance allows to accept fully qualified domain names for machine name parameter
  • Added images by location view to preview dashboard

Fixes

  • Increased timeout for reading backup headers to reduce risk of timeouts
  • Improved defensiveness of the UI against unusual navigation
  • Connect-SqlClone now shows a more useful error if given a URL that is not a SQL Clone Server

July 17, 2018 - SQL Clone 2.7.1

This release of SQL Clone includes the following enhancements and bug fixes:

Features

Fixes

  • Fixed an issue when deleting an image that has templates defined for it
  • Fixed create image from backup if the size is more than 2TB
  • Creating an image from a live database will now use copy-only mode to avoid affecting backup chains

July 11, 2018 - SQL Clone 2.7.0

This release of SQL Clone includes the following enhancements and bug fixes:

Features

  • We're working on a new dashboard to allow you to manage your images and clones more easily. You can now preview an early version of this dashboard and provide us with feedback as we continue development - we'd love to hear what you think!

Fixes

  • Fixed internal server error when trying to delete a clone that does not exist

July 5, 2018 - SQL Clone 2.6.5

This release of SQL Clone includes the following enhancements and bug fixes:

Features

Fixes

  • Log text for image/clone operations will now include the image/clone's name

June 25, 2018 - SQL Clone 2.6.4

This release of SQL Clone includes the following enhancements and bug fixes:

Features

  • Sidebar can now expand / collapse, header now displays number of images and clones
  • PowerShell cmdlets will output a warning when a newer version is installed than is currently running

Fixes

  • PowerShell cmdlets earlier than version 2.5.5 will display a message saying they need updating rather than simply failing

June 11, 2018 - SQL Clone 2.6.3

This release of SQL Clone includes the following enhancements and bug fixes:

Features

  • Added Rename-SqlCloneImage cmdlet

Fixes

  • Detect SQL Servers when a SQL Clone Agent is reinstalled with a new certificate
  • Improved detection of errors when creating an image from a SQL Backup backup
  • Began defaulting to the Microsoft VSS provider where available for stability

June 1, 2018 - SQL Clone 2.6.2

This release of SQL Clone includes the following enhancements and bug fixes:

Features

  • An OriginDatabaseName SQL variable has been implemented for script runner

Fixes

  • SQL Clone can now delete images where the backing files have already been deleted

May 24, 2018 - SQL Clone 2.6.1

This release of SQL Clone includes the following enhancements and bug fixes:

Features

  • You can now apply clone modifications from the web UI - see our documentation for more details
  • Added SQLClone_UserName, SQLClone_MachineName, and SQLClone_CloneName SQL variables to clone modification scripts
  • SQL Clone can now be updated from the web UI

Fixes

  • Creating images from SQL Backup backups no longer requires the backup file to have the default .sqb extension
  • Increased visibility of images that couldn't be deleted
  • Telemetry has been updated in accordance with the privacy policy available at https://www.red-gate.com/website/legal

May 1, 2018 - SQL Clone 2.6.0

This release of SQL Clone includes the following enhancements and bug fixes:

Features

  • Added PowerShell support for running T-SQL scripts on clone creation - see our documentation for more details
  • Added New-SqlCloneTemplate, Get-SqlCloneTemplate, and Remove-SqlCloneTemplate cmdlets
  • Added -Template parameter to New-SqlClone for use with Get-SqlCloneTemplate

Fixes

  • Improvements to clone cleanup

April 18, 2018 - SQL Clone 2.5.5

This release of SQL Clone includes the following enhancements and bug fixes:

Features

  • Support to remove clones where the agent is offline

Fixes

  • Agent no longer attempts to monitor the health of clones for which creation failed

April 10, 2018 - SQL Clone 2.5.4

This release of SQL Clone includes the following enhancements and bug fixes:

Features

Fixes

  • Increased progress logging around image modification
  • Increased robustness of detaching databases

March 23, 2018 - SQL Clone 2.5.3

This release of SQL Clone includes the following enhancements and bug fixes:

Features

Fixes

  • Prevent Web UI controls being changed while waiting for response from server
  • Fixes an issue in the uninstaller which could unintentionally delete directories
  • Resolved an issue preventing image deletion ('resourceName' issue)

March 15, 2018 - SQL Clone 2.5.2

This release of SQL Clone includes the following enhancements and bug fixes:

Features

  • PowerShell cmdlet (Get-SqlCloneMachine) can now display Data Masker installed status
  • Scripts run during image creation now have VIEW ANY DEFINITION and VIEW SERVER STATE permissions, so long as the SQL Clone Agent has CONTROL SERVER permission

Fixes

  • The Modifications parameter on the New-SqlCloneImage cmdlet no longer accepts null values

March 2, 2018 - SQL Clone 2.5.1

This release of SQL Clone includes the following enhancements and bug fixes:

Features

Fixes

  • Resolves agents not being able to connect after upgrading to 2.5.0. If agents remain offline after installing server version 2.5.1, the agents may need to be restarted via services.msc
  • Resolves leftover occurrences of SQL Clone 2.4.7 appearing in Add/Remove Programs after upgrading to 2.5.0

February 27, 2018 - SQL Clone 2.5.0

This release of SQL Clone includes the following enhancements and bug fixes:

Features

  • SQL Clone can now invoke Data Masker for SQL Server v6 to mask your database images while they're being created
  • Image modifications UI has been extended to support data masking via upload of a .DMSMaskSet file

Fixes

  • Dashboard now uses binary units instead of decimal size units, to match Windows and most Windows software
  • Bulk uninstaller improvements

February 20, 2018 - SQL Clone 2.4.7

This release of SQL Clone includes the following enhancements and bug fixes:

Features

  • Integration with SQL Toolbelt bulk uninstaller
  • Clone name is updated when the clone database is renamed in SQL Server

Fixes

  • SQL Clone can now create images from differential backups which add new database files.

January 31, 2018 - SQL Clone 2.4.6

This release of SQL Clone includes the following enhancements and bug fixes:

Features

  • Current process information is displayed on Web UI while creating image
  • Displaying number of online and unavailable clones of an image on dashboard
  • Output of SQL scripts used to modify an image are stored on the SQL Clone Server in "%LOCALAPPDATA%\Red Gate\Logs\SQL Clone\Images"
  • Updated to the latest Visual C++ 2017 redistributable (14.12)

Fixes

January 23, 2018 - SQL Clone 2.4.5

This release of SQL Clone includes the following enhancements and bug fixes:

Features

  • Added origin server and origin database name to the Get-SqlCloneImage cmdlet

Fixes

January 15, 2018 - SQL Clone 2.4.3

This release of SQL Clone includes the following enhancements and bug fixes:

Features

  • The "Send feedback" button can be disabled in Settings.
  • The -SqlScript parameter on New-SqlCloneImage has been deprecated in favour of the new -Modifications parameter, to be used with New-SqlCloneSqlScript.

Fixes

December 19, 2017 - SQL Clone 2.4.2

This release of SQL Clone includes the following enhancements and bug fixes:

Features

  • Modified label is displayed on SQL Clone Server Web UI for images which have been modified while being created
  • Information link added to permissions page
  • Improved fallback behaviour around renamed clones
  • Added an optional OverrideStorageLocation parameter to the New-SqlClone cmdlet, to specify where to store the specific clone.
  • Scripts containing GO statements (multiple batches) are now supported.

Fixes

  • Source Database field in image creation flow is highlighted when user tries to proceed without inputting this field
  • Clone Agent now correctly determines what permissions it has via its SQL Server login

December 7, 2017 - SQL Clone 2.4.1

This release of SQL Clone includes the following enhancements and bug fixes:

Features

Fixes

  • When you install a new agent during creating an image or clone, SQL Servers on that new machine now appear and are enabled in the SQL Server Instance dropdown without having to refresh the page.
  • Add and remove buttons work properly in Striped/Differential backups section in Source Locations while creating an image.

November 30, 2017 - SQL Clone 2.4.0

This release of SQL Clone includes the following enhancements and bug fixes:

Features

  • SQL Clone now supports running a custom T-SQL script during image creation, so you can make modifications to the image such as:
    • Masking data
    • Changing permissions
    • Changing configuration data

Fixes

  • The error message when you try to delete an image that has clones from PowerShell now includes the image name.
  • Error messages immediately appear against images and clones in the web UI rather than requiring a refresh.

November 20, 2017 - SQL Clone 2.3.6

This release of SQL Clone includes the following enhancements and bug fixes:

Features

Fixes

  • Fixed an issue deserialising an old agent's fully qualified domain name.
  • Fixed an issue where 'Could not create/delete image/clone' was being erroneously reported.

November 3, 2017 - SQL Clone 2.3.5

This release of SQL Clone includes the following enhancements and bug fixes:

Features

Fixes

  • Fixed a failure loading the UI when agents are assigned to environments.

November 1, 2017 - SQL Clone 2.3.4

This release of SQL Clone includes the following enhancements and bug fixes:

Features

Fixes

  • Fixed a concurrency issue with image monitoring.
  • Notification that an agent has failed to update now disappears once the agent has been updated.
  • Prevented a cause of agent crashes which could happen immediately after updating SQL Clone Server.

October 23, 2017 - SQL Clone 2.3.3

This release of SQL Clone includes the following enhancements and bug fixes:

Features

Fixes

  • Fixed an issue preventing clean-up of clones deleted from outside SQL Clone.

October 23, 2017 - SQL Clone 2.3.3

This release of SQL Clone includes the following enhancements and bug fixes:

Features

  • Machines that no longer exist, but still had clones, can now be removed from SQL Clone by passing the -Force parameter to the Remove-SqlCloneMachine cmdlet.
  • A warning is now given when choosing to create an image using a local path rather than a UNC path, as it will be unaccessible from other machines.

Fixes

  • Fixed a web UI inconsistency when creating images via Powershell ('agent is not compatible with this image').

October 11, 2017 - SQL Clone 2.3.2

This release of SQL Clone includes the following enhancements and bug fixes:

Features

  • Machines with agents can now be removed from SQL Clone using the Remove-SqlCloneMachine cmdlet, once all images and clones created by that machine have been deleted, and the agent is no longer connected to SQL Clone

Fixes

  • Fixed an issue where a FullyQualifiedDomainName field was not being correctly parsed.
  • Fixed an issue where a 'checking access to this instance' spinner failed to disappear.

October 2, 2017 - SQL Clone 2.3.1

This release of SQL Clone includes the following enhancements and bug fixes:

Features

  • Uses new Redgate installer

Fixes

  • Fixed error which could occur when creating many clones in parallel
  • If you delete a clone or image when the SQL Clone Agent is offline, the operation fails instead of being stuck in progress
  • You can now successfully delete a clone when the image is unavailable
  • Web UI will no longer fail to load if information about when an image or clone was created is missing

September 28, 2017 - SQL Clone 2.3.0

This release of SQL Clone includes the following enhancements and bug fixes:

Features

  • Added a new PowerShell cmdlet (Get-SqlCloneMachine) to get all machine details from a SQL Clone Server.
  • Get-SqlCloneImageLocation cmdlet creates new image location if it does not exist.
  • Added support for creating images and clones of databases using FILESTREAM or memory-optimized tables.

Fixes

  • Fixed issue with monitoring image files on non-Windows fileshares.

September 18, 2017 - SQL Clone 2.2.4

This release of SQL Clone includes the following enhancements and bug fixes:

Features

Fixes

  • Dropdown list items are listed in alphabetical order.
  • Fixes 'value cannot be null' error while creating an image.
  • Agent setup window scrolls if there is insufficient vertical space.

September 12, 2017 - SQL Clone 2.2.3

This release of SQL Clone includes the following enhancements and bug fixes:

Features

  • Progress increments during row data restoration from SQL Backup.
  • Supports multiple simultaneous backup restores on a single machine when creating images from backup

Fixes

  • Backup Location section removed from image create review page because it is no longer used
  • Temporary Server section added to image creation review page

September 5, 2017 - SQL Clone 2.2.2

This release of SQL Clone includes the following enhancements and bug fixes:

Features

  • Marked the Get-SqlCloneBackupLocation cmdlet as obsolete (New-SqlCloneImage should be passed full paths using the BackupFileName parameter instead)

Fixes

  • Fixed an environment-specific situation in which MissingMethodException could be thrown by the PowerShell cmdlets.

August 30, 2017 - SQL Clone 2.2.1

This release of SQL Clone includes the following enhancements and bug fixes:

Features

  • Increase logging around automatic clone detachment.
  • File sizes are now displayed rounded to 3 significant figures.

Fixes

  • The retry link on the unauthorized page now functions properly when permissions are updated.
  • Fix for error message being shown when selecting SQL Server authentication during image creation.
  • Large compressed SQL Backup files should no longer time out.
  • Fix for monitoring image files stored on certain operating systems.

August 7, 2017 - SQL Clone 2.2.0

This release of SQL Clone includes the following enhancements and bug fixes:

Features

  • You can now manage who has access to SQL Clone by assigning Active Directory users and groups to roles. Roles available allow administrator access, image and clone access, and clone-only access.
  • Added command line option to override the server URL when installing an agent: SERVERURL=https://machine.name:14146
  • When creating an image from a backup in the web UI, you can now specify the SQL Server to use when temporarily restoring the database.
  • Simplified web UI for creatings images from striped and/or differential backups.

Fixes

  • Added more logging during low level operations to help diagnose problems.

July 26, 2017 - SQL Clone 2.1.2

This release of SQL Clone includes the following enhancements and bug fixes:

Features

  • When creating an image from a backup using PowerShell, you can now specify the SQL Server to use when temporarily restoring the database.
  • Web UI now supports creating images from .sqb and .bak backup files protected with passwords.

Fixes

July 20, 2017 - SQL Clone 2.1.1

This release of SQL Clone includes the following enhancements and bug fixes:

Features

Fixes

  • Corrected an issue affecting Powershell cmdlets ('Error while copying content to a stream').

July 17, 2017 - SQL Clone 2.1.0

This release of SQL Clone includes the following enhancements and bug fixes:

Features

Fixes

  • Image paths now display correctly when clones become disconnected
  • Progress of long-running operations will be loaded immediately in the UI rather than showing 0% for a while

July 11, 2017 - SQL Clone 2.0.5

This release of SQL Clone includes the following enhancements and bug fixes:

Features

  • Clones are now sorted by creation time
  • Machines page under Settings now shows more information about agents that are auto-updating
  • Notifications about agent updates are now only shown when auto-update failed and manual update is required
  • Started logging version number in log files

Fixes

July 3, 2017 - SQL Clone 2.0.4

This release of SQL Clone includes the following enhancements and bug fixes:

Features

Fixes

  • Image destination validation now handles write-only directories correctly.
  • Improve detection of inaccessible images.

June 27, 2017 - SQL Clone 2.0.3

This release of SQL Clone includes the following enhancements and bug fixes:

Features

  • More information is provided when clones become disconnected from the associated image
  • You can now see the status of all your SQL Clone agents on the Machines page under Settings.

Fixes

June 21, 2017 - SQL Clone 2.0.2

This release of SQL Clone includes the following enhancements and bug fixes:

Features

Fixes

  • Fixed installer bug where, after cancelling, other installers couldn't proceed until after a reboot.
  • Fixed occasional installer crash.

June 20, 2017 - SQL Clone 2.0.1

This release of SQL Clone includes the following enhancements and bug fixes:

Features

  • SQL Clone now requires .NET Framework 4.6.1 or later (was previously 4.6.2 or later)

Fixes

June 19, 2017 - SQL Clone 2.0.0

This release of SQL Clone includes the following enhancements and bug fixes:

Features

  • SQL Clone can now work with databases up to 64 TB. This means you can create images and clones just like before but with larger databases.
  • Support for creating images from differential backups (note: this requires both the full and differential backup files to be entered)
  • SQL Clone now requires .NET Framework 4.6.2 or later (was previously 4.5.2 or later)
  • Updated PowerShell cmdlets with support for databases upto 64 TB. Any older v1 cmdlets will need to be updated using the latest installer from the PowerShell page under settings.

Fixes

  • Improved handling of large numbers of simultaneous operations and detection of interrupted operations

Didn't find what you were looking for?