SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
Thank You very much!
SQL 2014 Migration
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 39%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIC%3C/text%3E%3C/svg%3E)
Ismail Cassiem
226
Reputation points
Hi,
I am reposting as the previous thread was closed.
Please clarify my list below and recommend changes
Realtime Refreshes with Parallel Jobs, Equivelant to MPP (PDW, Multiple Physical Servers with VM)
• Infrastructure 2 VM (Storage & Presentation)
VM Storage (Cube Process and copy after completion)
Hardware
- Windows 19 x64 with Hyper-V Enabled
`` - 64 Bit Processors (A) 120 Win19, (B) 64 Win16 (Multiple Numa Nodes 4)
CPU Speed (Fast), latest spec?
Cores, How many?
CPU Architecture, latest spec? - SSD Storage (A) 7TB, (B) 5TB
- RAM (A) 3TB, (B) 2TB
RAM Speed (Fast), latest spec?
- Increase Netwrok Sockets/Speek in DataCenter between Storage VM & ERP (AS400), particular specs?
Software - VS2019/21 Community with SSDT
- SQL21 or SQL19 (DB, SSIS, MDS) for collumn store indexing, change all from rows (20% improvement)
- WINSCP, PKZip, 7Zip, Excel only for static Reports
- PowerPivot Rolled out as a Group "specific users"
- Not Increasing PBI licenses (decrease in usage)
- LiteSpeed (Object Recovery)
VM Presentation
- Hardware Requirements the same as Storage, but 3TB Hardrive & 64 Processors?
- SSAS,SSAS Tabular, PBI, PowerPivot
Innovation/Evolve
- PowerPivot, thoughts on innvovation please ? > Equivelant to Qlikview (Bridge gap between Excel and PowerBI)
Please Advise!
SQL Server Migration Assistant
4 answers
Sort by: Most helpful
-
Olaf Helper 47,621 Reputation points2020-11-27T07:34:01.24+00:00 i read that SQL2020 known as SQL16.0 is being developed
There is no such/next version announced, yet; so no one of use can say, when the next version will be released.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 6%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EII%3C/text%3E%3C/svg%3E)
IC IC 236 Reputation points2020-11-23T08:03:11.353+00:00 Hi,
Thank You for assisting, i read that SQL2020 known as SQL16.0 is being developed
I want the latest version, when i go live in Feb/Mar
any idea when and the benifts ?
would the above architecture work?regards
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 46%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
AmeliaGu-MSFT 14,016 Reputation points Microsoft External Staff2020-11-23T07:17:14.67+00:00 Hi @Ismail Cassiem ,
Which version and edition of SQL Server do you want to migrate to? Do you want to migrate to SQL Server 2019?
Did you encounter any issues during the migration?
You can use DMA (Data Migration Assistant) to migrate SQL Server. DMA will recommend 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.Best Regards,
Amelia
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
What can I do if my transaction log is full?--- Hot issues November
How to convert Profiler trace into a SQL Server table -- Hot issues November