270 questions
How to migrate large tables of size around 30gb from sql server 2014 to sql server 2022?
![](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(156.8, 57.99999999999999%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKD%3C/text%3E%3C/svg%3E)
Kumari, Dimpy
0
Reputation points
Hi ,
what would be the best way to migrate table of size 30 GB from sql server 2014 to sql server 2022?
SQL Server Database Engine
{count} votes
-
![](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(60.8, 74%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Michal Skupinski 0 Reputation points2025-04-24T13:17:45.8733333+00:00 Hi, do you expect any compatibility issues between the server versions?
Backup and restore seems to be the simplest option.
-
Kumari, Dimpy 0 Reputation points
2025-04-24T14:35:41.2233333+00:00 the db is quite huge and can’t be backed up.
-
Kumari, Dimpy 0 Reputation points
2025-04-24T14:36:17.25+00:00 Also we don’t have to ant everything. Just few tables
Sign in to comment
Sign in to answer