Getting Started with Adobe After Effects - Part 6: Motion Blur
Ask
Ask questions, discuss or help others by answering
Related Posts · View All
SQL Server 146
TSQL 76
SSRS 71
SSIS 68
XML 57

Top Categories · View All
SQL Server 146
TSQL 76
SSRS 71
SSIS 68
XML 57

Pre Migration Utility

Jun 20 2014 12:00AM by snehaniarav13   

Hello Sir,

 do we have any thirdparty software tool for SQL DB like Pre Migration Utility?

 Please suggest.

Submitted under: Microsoft SQL Server · DBA ·  ·  · 


snehaniarav13
924 · 0% · 31

4 Replies

  • Hello,

    You have not mentioned which kind of Migration you would like to perform & which SQL Server you are targetting. Pre Migration Utility - Upgrade Advisor. You also need to check Breaking changes between SQL server versions (yours one & the one you are targetting). You should also check deprecated featutes list so you can also work on it whenever time permits.

    Please share more details about your migration so we can provide input accordingly.

    commented on Sep 14 2014 11:57PM
    Hardik Doshi
    20 · 9% · 2864
  • Hello!

    A lot depends upon the kind of migration you are talking about - is it moving from one SQL server instance to another, changing the compatibility level of a database, or just upgrading from a product database fron version (n) to version (n+1)?

    For product database upgrades, suggest you contact the product vendor for more details. For others (or in case you are a vendor yourself), the following posts may give you a good starting point:

    • Thinking about Deprecated, Discontinued Features and Breaking Changes while Upgrading to SQL Server 2012 [Link]
    • #0228 - SQL Server 2012 - Using the Upgrade Advisor [Link]
    commented on Sep 15 2014 1:43AM
    Nakul Vachhrajani
    4 · 36% · 11648
  • Pre-Migration Check Database Utility in sql Database it should included below functionality

    · Schema comparison

    · Data Integrity Check

    · Logical Analysis

    Please provide your inputs in this.

    commented on Sep 29 2014 1:49AM
    snehaniarav13
    924 · 0% · 31
  • Hello!

    Schema & data comparison utilites are commercially available off-the-shelf from various vendors (including Microsoft (as part of Visual Studio/SSDT) and RedGate).

    Data Integrity Checking has a very wide scope - what do you mean by integrity? If it is just the consistency of the data on disk, DBCC would be a great starting point. If it is the relationship of data in your user tables, then it would have to be something custom built - I'm unaware of any off-the-shelf product that can help here.

    Similarly, for logical analysis. What is the logical analysis that you are looking at? Do you want number of records in the table? The distribution of data across various files? Level of duplication of data, etc. Most of these questions require custom built solutions.

    commented on Sep 30 2014 12:46PM
    Nakul Vachhrajani
    4 · 36% · 11648

Your Reply


Sign Up or Login to post a comment.

    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]