I am upgrading a clients app to a newer version, the databases are close but slightly different. I need to figure out a way to transform and copy the data from one table in one database to another table in the new database. Oh geez :(
我正在将客户端应用程序升级到更新版本,数据库很接近但略有不同。我需要找到一种方法来将数据从一个数据库中的一个表转换并复制到新数据库中的另一个表。哦,geez :(
3 个解决方案
#1
INSERT INTO new_db.dbo.TableA
SELECT * FROM old_db.dbo.TableB
If the tables are the same, this is probably the easiest way.
如果表格相同,这可能是最简单的方法。
#2
SQL Server Integration Services (previously known as Data Transformation Services) is the way to go.
SQL Server Integration Services(以前称为数据转换服务)是最佳选择。
SQL Server Import and Export data wizard works for simple tasks pretty well.
SQL Server导入和导出数据向导非常适用于简单任务。
#3
SQL Server Integration Services is going to be your best bet. If you're familiar with the SQL 2000 DTS Packages, you shouldn't have too much difficulty figuring out SSIS packages.
SQL Server Integration Services将是您最好的选择。如果您熟悉SQL 2000 DTS包,那么找出SSIS包不会太困难。
#1
INSERT INTO new_db.dbo.TableA
SELECT * FROM old_db.dbo.TableB
If the tables are the same, this is probably the easiest way.
如果表格相同,这可能是最简单的方法。
#2
SQL Server Integration Services (previously known as Data Transformation Services) is the way to go.
SQL Server Integration Services(以前称为数据转换服务)是最佳选择。
SQL Server Import and Export data wizard works for simple tasks pretty well.
SQL Server导入和导出数据向导非常适用于简单任务。
#3
SQL Server Integration Services is going to be your best bet. If you're familiar with the SQL 2000 DTS Packages, you shouldn't have too much difficulty figuring out SSIS packages.
SQL Server Integration Services将是您最好的选择。如果您熟悉SQL 2000 DTS包,那么找出SSIS包不会太困难。