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
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.