问题描述
我有一个VB.NET Windows应用程序，可从MS Access数据库中提取信息.该应用程序的主要作用是从各种格式的Excel文件中提取信息，使文件布局标准化并将其写到csv文件中.该应用程序使用MS Access作为密钥和交叉引用文件的源.
I have a VB.NET windows application that pulls information from an MS Access database. The primary role of the application is to extract information from Excel files in various formats, standarize the file layout and write that out to csv files. The application uses MS Access as the source for the keys and cross reference files.
Windows应用程序使用类型化的数据集进行数据库之间的许多用户交互.标准化是在每台客户端计算机上完成的.该应用程序不是...我怎么说呢... FAST:-).
The windows app uses typed datasets for much of the user interaction between the database. The standardization is done on the on each clients machine. The application is not... how can I say this...FAST :-).
问题:将数据库和应用程序迁移到SQL Server 2005的最佳方法是什么.我认为编写用于SSIS和SSIS包中的标准化代码可能是个好主意.
Question: What is the best way to migrate the DB and application to SQL Server 2005. I am thinking it might be a good idea to write the code for the standarization in and SSIS packages.
进行此迁移的适当方法是什么?
What is the appropriate way to go about this migration?
应用程序每周从250个excel文件中提取数据，每月从大约800个文件中提取数据，每个文件平均约5000行.共有13种不同的文件格式经过标准化处理，然后输出为3种不同的标准格式.申请时间为25分钟.以及40分钟的运行时间，具体取决于我们要处理的数据. 95％的申请是标准化过程.用户要做的就是选择一些参数，然后开始运行.
The application pulls data from 250 excel files each week and approximatley 800 files each month with an average of about 5000 rows per file. There are 13 different file formats that are standarized and out put into 3 different standard formats. The application takes between 25 min. and 40 min to run depending on which data run we are taling about. 95% of the appliction is the standarization process. All the user does is pick a few parameters then start the run.
推荐答案
Microsoft提供了免费工具，用于将Access数据库迁移到SQL Server.升级后，您应该可以将连接字符串更改为指向SQL Server.
Microsoft provide a free tool to migrate an Access Database to SQL Server. Once you've upgraded you should be able to change your connection string to point at SQL Server.
这篇关于如何从MS Access迁移到SQL Server 2005?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！