How to migrate the data from on-prem MS SQL server blob table (having structured and un-structured data) to AWS RDS using MS SQL Server

C, Manoharan (Cognizant) 40 Reputation points
2025-04-01T16:23:15.97+00:00

I have a table contains 7 columns.

CREATE TABLE DEV.My_Files (    file_id INT IDENTITY(1,1) PRIMARY KEY,   -- Unique identifier for each file    filename NVARCHAR(255) NOT NULL,         -- Original file name    file_extension NVARCHAR(10) NOT NULL,    -- File extension (.jpg, .pdf, etc.)    mime_type NVARCHAR(255) NOT NULL,        -- MIME type (image/jpeg, application/pdf)    file_size BIGINT NOT NULL,               -- Size of the file in bytes    encrypted_file_data VARBINARY(MAX) NOT NULL,  -- ✅ BLOB Data (Binary File)    created_by NVARCHAR(100),                -- User who uploaded the file    created_at DATETIME DEFAULT GETDATE(),   -- Timestamp when the file was created    updated_at DATETIME NULL                 -- Last modified timestamp );

and wanted to move this table to AWS RDS and store images/pdf/docs in S3 and created a new url column in My_files table

what are the AWS components/tools needed and what is the best approach for Data Migration. Table have structured and unstructured data.

SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
177 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.