Big savings, Better ROI! Exclusive discounts on ManageEngine Products!* Boost your business *T&C apply
    Click here to shrink
    Click here to expand Click here to expand

    Migrating data between different versions of MS SQL

    ADAudit Plus allows administrators to store and retrieve Windows servers' audit log data from MySQL, MS SQL, or PostgreSQL databases.

    MS SQL server has built-in methods to migrate data from one version to another.

    MS SQL DB Migration using Import Data Method

    Recommended for: Moving particular table data from one DB to another.

    1. Login to Microsoft SQL Server Management Studio.
    2. Right click on the DB that you want the data moved to (Ex: adap_new). Select Tasks → Import Data.
    3. The SQL Server Import and Export wizard opens up → Click Next
    4. In the Data Source wizard, that opens up, specify: (In the Data source drop down, select SQL Server Native Client if it's not selected already.)
      • Server Name.
      • Authentication (Used to login to SSMS).
      • Database.
      • Click Next.
    5. Under the Destination wizard, enter the following: (In the Data source drop down, select SQL Server Native Client if it's not selected already. )
      • Server Name (will get automatically detected, you can change the destination, if you want).
      • Authentication.
      • Database (will get automatically detected, you can change the destination, if you want).
      • Click Next.
    6. Under Specify Table Copy or Query → Choose Copy Data From One or More Tables/Views → Next.
    7. Under Select Source Tables and Views → Choose the tables to be copied from source, select the tables from the left column using Edit Mappings → Select particular table operations → Next.
    8. Check the Run Immediately box → Next.
    9. Click Finish.

    Don't see what you're looking for?

    •  

      Visit our community

      Post your questions in the forum.

       
    •  

      Request additional resources

      Send us your requirements.

       
    •  

      Need implementation assistance?

      Try onboarding

       

    On this page

    Get download link