DMA - A safe way to migrate SQL Server database objects




SQL Server database objects migration was not so easy earlier as of now with the help of DMA(Data Migration Assistant).

The Data Migration Assistant (DMA) which is a free tool from Microsoft. DMA helps us to upgrade to a modern data platform by detecting compatibility issues that can impact database functionality in your new version of SQL Server or Azure SQL Database.

DMA recommends performance and reliability improvements for your target environment and allows you to move your schema, data, and uncontained objects from your source server to your target server.

The DMA assessment workflow detects Migration blocking issues,Partially supported or unsupported features,compatibility issues (Breaking changes,Behavior changes,Deprecated features) and suggests feature recommendations(Performance,Security,Storage).

References :-

https://docs.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-2017
https://channel9.msdn.com/Shows/Data-Exposed/First-Look-at-the-new-SQL-Server-Data-Migration-Assistant

Source - Microsoft.com

Comments

Post a Comment

Popular posts from this blog

OutSystems – A Low-code Development Platform

Image
Introduction :- Low-code is a way for developers of all skill levels to design applications quickly and with minimum hand-coding by dragging and dropping visual blocks of existing code into a workflow to create applications.  It is model-driven or visual development paradigms supported by expression languages or scripting. Benefits of Low-Code Platform:- Faster Delivery Time and Reduce the cost of development by up to 60%.
Read more

What is difference between Azure Cognitive Search and Elastic Search

Image
  Cognitive search and Elastic search Azure Cognitive Search :-  The Azure Cognitive Search service enables search over different types of content by letting you create and manage search indexes. You can import data from a variety of sources, with AI-powered indexing that can infer and extract searchable content from non-text sources. You decide what data is imported into the index, and set up indexers to pull that data into it, or push JSON formatted documents manually. Azure Cognitive Search also lets you query search indexes. The results contain only your data, which can include text inferred or extracted from images, or new entities and key phrases detection through text analytics. It's a Platform as a Service (PaaS) so Microsoft manages the infrastructure and availability, allowing your organization to benefit without the need to purchase or manage additional hardware resources. Azure Cognitive Search exists to compliment existing technologies and provides a programmable ...
Read more

failed to access iis metabase asp.net

http://www.blogger.com/img/blank.gif set the userName to SYSTEM in the processModel of the machine.config file, the http://www.blogger.com/img/blank.gifappliaction works just fine. Omitting the userName attribute gives me the error. From reading other posts, this is indicative of a permissions problem. So, without specifying the userName, I tried the application while running filemon, but I don't see any file access getting denied like I expected to see based on the posts I have read. step1:- aspnet_regiis -i Step2:- aspnet_regiis -ga ASPNET http://www.getitshare.com http://www.shriashoka.com
Read more