Scripts migrating data from MS SQL Server to MySQL in Laravel API application

Good day, I have experience in PHP for over 5 years and have experience in database migration (partially replication). I am ready to complete the task. The deadline will be final after additional information.

Show original

Translate

Hi, hope you're doing well!

I can handle the MS SQL Server to MySQL migration for your Laravel e-commerce application. I will write custom PHP migration scripts using Laravel's database tools to handle the schema transformation, carefully mapping data types between MS SQL and MySQL (e.g., NVARCHAR to VARCHAR, IDENTITY to AUTO_INCREMENT, DATETIME differences), transferring all e-commerce and blog data with proper foreign key relationships, and updating all blog links using regex pattern matching and SQL queries to match the new system structure.

I will use the populated stage database you provided as a reference to verify schema mapping accuracy and ensure nothing gets lost. After migration, I will run data integrity checks comparing record counts, foreign key relationships, and sample data against the stage database to confirm everything transferred correctly.

Available to start immediately and looking forward to your response.

Thanks, Youssef Hachicha.

Hello!

I have experience in migrating databases between different systems (MS SQL Server → MySQL) and in working with projects based on Laravel, and I can help transfer your data to the new application.

I will prepare migration scripts taking into account the mapping of differences in database schemas, ensure the integrity of relationships, and correctly rewrite links in the blog tables. We can use the staging database as a reference point to verify the correctness of the migration.

I would be happy to familiarize myself with the structure of the current database and the details of the project to precisely define the scope of work and the timeline for completion.

Show original

Translate

Greetings Paweł

I will be happy to help you professionally carry out the migration from MS SQL to MySQL for any volume and load.

Please establish the budget and terms after discussing the details and scope of work.

Write to me, I am eager to collaborate. I look forward to your feedback.

Show original

Translate

Good morning,

I have experience in data migrations between MS SQL Server and MySQL, as well as in Laravel projects, where it was necessary to map different schemas and maintain the consistency of relationships.

I can:
- analyze both databases (production and staging)
- prepare the mapping of tables and fields according to the new schema
- write migration scripts (ETL / scripts in PHP or SQL)
- ensure the proper transfer of relationships (products, categories, blog, users, etc.)
… - update links in the blog tables (e.g., changing the domain / URL structure)
- prepare the migration to be repeatable and safe

I work carefully — first testing on staging, then the target migration.

I would be happy to review the schemas of both databases and propose a specific action plan.

Show original

Translate

Hello!
I have experience in migrating databases between different DBMS (MS SQL Server → MySQL) and working with Laravel projects, so I can help transfer your ecommerce store with a blog to a new application on Laravel. I understand that the schemas differ, so it will require mapping of tables and fields, rather than a "direct" import.

What I can do for the task:
Prepare and describe the correspondence between the tables/fields of the old MS SQL database and the new MySQL one (taking into account the structure of the Laravel application).
Write scripts/migration jobs that will correctly transfer data (products, orders, users, blog posts, etc.) while preserving relationships and keys.
Use your staging database to compare migration results and verify data accuracy.
Update links in the blog tables (URLs in content, internal links) to match the new structure/domain.
If necessary, prepare a repeatable migration script (so that the transfer can be run again before the final launch).
…
Let's discuss the details in private messages: the volume of data, access to MS SQL/MySQL, whether there is a description of the new Laravel schema, and which entities are critical to transfer first. After that, I will be able to propose a work plan, timelines, and an estimated budget.

Show original

Translate

I am a Laravel developer and I can perform the migration from MSSQL to MySQL (e-commerce + blog) with schema mapping, updating links in the blog tables, and verification on the staging database.

Show original

Translate

Hello. I am ready to complete your project after agreeing in private messages. The final deadlines and price will be determined after the agreement. I can also offer technical support and assistance in the future.

Show original

Translate

Good morning,
I can do this. I have extensive experience in data migrations from MS SQL Server to MySQL and in Laravel projects.
I will prepare migration scripts with mapping of differing schemas, ensure data integrity, and update links in the blog tables.
The stage database as a reference is not a problem. I am available immediately.

Show original

Translate

Good day
extensive experience in writing data conversion scripts between databases
for an accurate assessment, it is necessary to look at two databases

Show original

Translate

Hello! The task of transferring data from the e-commerce system on MS SQL to Laravel (MySQL) is clear. This is a complex process where it is important not just to copy the data, but to maintain the integrity of relationships and the correctness of URLs.

Here’s how I propose to solve the task:

Two-level connection: We will configure Laravel to work simultaneously with two data sources. This will allow the script to "stream" data directly without creating intermediate files.

Mapping through Artisan commands: Instead of simple SQL queries, I will write custom Laravel console commands. This will leverage the power of Eloquent and ensure flexible data transformation (for example, converting dates, price formats, and metadata) directly during the transfer process.

Cleaning and updating content: During the blog migration, we will use regular expressions (Regex) to find old links within the article texts. We will replace them with new SEO-friendly URLs that correspond to the Laravel architecture.
…
Validation through Stage: We will use your stage database as a benchmark (Gold Standard) to verify results after each stage of migration.

Below is a fragment of the script architecture that I plan to use for mapping:

PHP
// Fragment of the Artisan command for migration with mapping and link updating
public function handle()
{
// Connect to the old MS SQL database and read data in batches of 100 records
DB::connection('mssql')->table('OldPosts')->chunkById(100, function ($posts) {
foreach ($posts as $post) {

// 1. Mapping fields (transforming the old schema into the new one)
// 2. Content transformation: replacing old links with new ones via Regex
$updatedContent = preg_replace(
'/http:\/\/oldstore\.com\/blog\.php\?id=(\d+)/',
config('app.url') . '/blog/post-$1',
$post->Content
);

// 3. Writing to the new MySQL database (Laravel)
DB::table('posts')->updateOrInsert(
['old_id' => $post->ID], // Preserving the relationship for verification
[
'title' => $post->Title,
'content' => $updatedContent,
'slug' => Str::slug($post->Title),
'created_at' => Carbon::parse($post->DateCreated),
'status' => ($post->IsActive) ? 'published' : 'draft',
]
);
}
$this->info('Another 100 posts migrated...');
});
}
This approach guarantees that the database will be "clean".

Show original

Translate

Hello,

This is not just a simple export/import task since the schemas differ, so proper mapping and data transformation logic will be required. I have experience working with structured database migrations and writing custom scripts to safely transfer and validate data between different systems.

I can:

analyze both schemas and define a clean mapping strategy

write migration scripts for MS SQL → MySQL
…
ensure relational integrity (users, orders, products, blog content, etc.)

update blog links during the migration process

validate results against your stage database

Before confirming final scope, I would like to review the database size and table structure to estimate complexity accurately.

If everything is clear and structured, I can deliver a safe and well-tested migration within the proposed budget.

Looking forward to your response.

Good day, I am ready to implement the script for data comparison and migration from MSSQL to MySQL.

Show original

Translate

Hello
I am ready to complete your task, I will write a migration script and successfully migrate all data from the old ms sql database to the new mysql.
Write to me, we will discuss, I will be happy to collaborate!

Show original

Translate

Hi. I have solid experience with SQL database migrations and writing custom scripts for data transformation.
Since the schemas differ, I can write a script to map and convert your data from the MS SQL structure to the new MySQL format, using your stage DB as a reference. I will also handle the blog link updates during the transfer. Let's chat to discuss the details.

Hello!
I will transfer the database from mssql to mysql without problems and with quality.
Write to me in private messages.

Show original

Translate

Good morning!

I understand the need to migrate data from MS SQL to MySQL for Laravel API, including schema mapping and updating blog links. I have experience in Laravel, API, and complex database migrations.

Please contact me in a private message, and we will discuss the details.

Show original

Translate