The structure of the SQL Server database data migration table is different.

A gas station management system developed by the company, written in C #, was previously developed using SQLSERVER2000, currently, the SQL Server 1.0 database is the same. The first version is 1.1, and the second version is, all are called GPOSDB, but the database of Version 1.1 has three table fields that are several more than those of version 1.0.

A gas station management system developed by the company, written in C #, was previously developed using SQLSERVER2000, currently, the SQL Server 1.0 database is the same. The first version is 1.1, and the second version is, all are called GPOSDB, but the database of Version 1.1 has three table fields that are several more than those of version 1.0.

A gas station management system developed by the company, which is written in C #. It was previously developed using SQLSERVER2000 and now uses SQLSERVER2005.

Databases are the same.

The first version is 1.0.

The second version is 1.1.

The two versions of the database are identical, both called GPOSDB.

However, in database 1.1, there are three more fields in the table than in database 1.0.

In addition, Version 1.1 has a lot more stored procedures than Version 1.0.

I would like to ask, what should I do if I want to upgrade the system with data from the customer to version 1.1?

Exporting table data is definitely not acceptable, regardless of whether the previous 1.0 version uses SQL2000 or SQL2005.

Because the fields are different, do you need to use C # To write a tool to migrate data?