{"id":635,"date":"2006-05-31T11:05:25","date_gmt":"2006-05-31T11:05:25","guid":{"rendered":"\/blogs\/kimberly\/post\/SQL-Server-Migration-Assistants.aspx"},"modified":"2013-01-02T07:08:40","modified_gmt":"2013-01-02T15:08:40","slug":"sql-server-migration-assistants","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/sql-server-migration-assistants\/","title":{"rendered":"SQL Server Migration Assistants"},"content":{"rendered":"

In part 11 of the TechNet webcast series for the ITPro<\/a>, I spoke briefly about the Oracle Migration Assistant<\/a> and the recent release of the Community Tech Preview versions of both the Access and Sybase Migration Assistants… A few of you asked for their download location and there were even a few replies that folks had found them… However, after looking around, I figured out that what was found were the OLD and very outdated Access Upsizing Wizards (and that’s not this!<\/EM>). The new SQL Server Migration Assistant tools are truly Migration <\/STRONG>tools – tools that can help convert code, change data types, etc. More than anything they’re targeted at being more complete and feature rich than just an “upsizing tool” which is excellent for what it is but still requires a lot of additional work.<\/P>
\n

Having said all of that, I have the details about the TRUE Migration Assistants.<\/P>
\n

SSMA for Access download instructions:<\/FONT><\/STRONG><\/P>
\n


\n

Download instructions<\/STRONG><\/P>
\n


    \n
  1. Open the download page here<\/a>.
    \n
  2. Select \u2018Receive File from Microsoft\u2019.
    \n
  3. Enter the Password: w$%dIcKP_TZrf<\/STRONG><\/FONT>
    \n
  4. Download and run ssma-for-access-xxx.msi<\/STRONG><\/FONT><\/LI><\/OL><\/BLOCKQUOTE>
    \n

    SSMA for Sybase download instructions:<\/STRONG><\/FONT><\/P>
    \n


    \n

    Download instructions<\/STRONG><\/P>
    \n


      \n
    1. Open the ftp download site page here<\/A> with the following username and password:
           username: SSMA4Syb2<\/FONT><\/STRONG>
           password: i456$Lk<\/STRONG><\/FONT>
      \n
    2. Download the msi for Sybase or the msi for the Sybase Enterprise Portal (ep).

      IMPORTANT: <\/STRONG>If you access the files from Internet Explorer, please verify IE Browser Settings using Tools, Internet Options, Advanced, under the Browsing section: <\/LI><\/OL>
      \n

      \n

      \n

      CHECK<\/STRONG> – Enable folder view for FTP sites
      UNCHECK<\/STRONG> – Use Passive FTP (for firewall and DSL modem compatibility)<\/P><\/BLOCKQUOTE><\/BLOCKQUOTE><\/BLOCKQUOTE>
      \n

      So… have fun with those downloads and if you run into any issues\/concerns – be sure to post in the SQL Server Migration Assistant newgroup<\/a>.<\/P>
      \n

      Cheers,
      kt<\/P><\/p>\n","protected":false},"excerpt":{"rendered":"

      In part 11 of the TechNet webcast series for the ITPro, I spoke briefly about the Oracle Migration Assistant and the recent release of the Community Tech Preview versions of both the Access and Sybase Migration Assistants… A few of you asked for their download location and there were even a few replies that folks […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[58,65,74],"tags":[],"class_list":["post-635","post","type-post","status-publish","format-standard","hentry","category-resources","category-sql-server-2005","category-technet-webcasts"],"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts\/635","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/comments?post=635"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts\/635\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/media?parent=635"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/categories?post=635"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/tags?post=635"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}