Microsoft has denied US reports that users will find it difficult, time-consuming and expensive to upgrade to version 7.0 of its SQL Server database, which is due to ship in the second half of next year.
The database, codenamed Sphinx, is being completely rewritten to try to make it more suitable for enterprise use, but this has led to fears that users face an ?ugly? migration ahead of them.
But Karen Green, Microsoft?s database marketing manager, said: ?There will be a significant architecture change with version 7.0, but we?ve included all the necessary utilities such as automation wizards to take users easily through the upgrade process. The data has to come out of the database and be reloaded, but in the past, you would have had to do all that manually row-by-row. With this, it?s a matter of a mouse-click and it?ll only take you a couple of hours to migrate.?
The upgrade contains three major changes to make it faster and more scalable. Version 7.0 will now include row-level locking as well as page level locking depending on which is more suitable for a given application. The database will be able to adjust itself automatically to run in either mode, but users will also be able to set their preference manually.
The product will support up to 1Tbyte of data, which means that Microsoft has also increased its page size to improve performance when accessing and writing data to disk.
The software giant is also replacing database devices, which partition data in the database, with a new on-disk file structure to make it easier for users to create and maintain files.
Version 7.0 is expected to go into its second beta testing phase with 1,000 customers worldwide in the first quarter of next year.
Dr Kuan Hon criticises GDPR consent emails that will only eviscerate marketing databases and 'media misinformation'
Apple squashes Steam Link app on 'business conflicts' grounds
Philip Hammond wants to forget rules that the UK agreed with the EU to ban non-European companies from the satellites
Instapaper to 'go dark' in Europe until it can work out GDPR compliance