March 21st, 2005, 02:44 AM
|
|
Registered User
|
|
Join Date: Mar 2005
Posts: 2
Time spent in forums: 30 m 12 sec
Reputation Power: 0
|
|
|
Estimate for SQL Server Data management
Hello,
I have experianc in working on very similar application, I propose to import the data into the SQl server using import Export utility of SQL server, We will use stored procedures to query the data and update the data, we can write pre built scripts to execute this job if it is a repeating project. The first time I presume it would take about 20 hours for me to complete this also include varification of the data, also the time is totally dependent on the total number of varifications.
The second time we will complete the same job in 5 hours.
Regards
Quote: | Originally Posted by Memnoch Give me an estimate on how long you think it would take to do the following, with brief explanation of how you would do it.
1) Import 5 text files into staging tables in a SQL Server database.
2) Compare data in staging tables to 5 other corresponding tables.
3) If record exists in its corresponding table, update the record, If not add a new record.
I get updates every month in txt format, some comma delimited some tab delimited, that I need an application to import these files into my staging tables and then update any existing records or add any new records. |
|
ASP Free Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
