Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
daveofgv
Starting Member
6 Posts |
 Posted - 2010-01-08 : 22:50:55
|
| Hello all, I am new to this forum and hope that someone can help.I am an ASP programmer. The company I work for has gone to a new level and have developed a new web application. I now have a new job and need some help.We have a web application that has a database with about 100 tables (or more)I need to write a process (package) that pulls one table from a database and stores it into another database for temporary then takes that table and puts it into another database. The 1st database will keep the table - 2nd database holds the table until the next process run then which will overwrite the table - 3rd database gets updated (or is overwritten by the 2nd database)The reason for the 3rd database is that our clients have not been trained on this application and we can not put it into the final database until they have been trained. Also, the second database can be used to back up the data the was pulled in case there was an error on the 3rd database.We need to make the process run at a specific time every night and email us with a report (successful process or unsuccessful process with error description)We own the servers so all the database's are on our servers and not hosted thru another company. We do have some clients that are hosted on another server and eventually will have to pull the data from them also.Can anyone help me along since I am not an experienced SQL developer?Thanks in advanceddaveofgv |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
daveofgv
Starting Member
6 Posts |
Posted - 2010-01-09 : 11:29:14
|
| Thank you for your reply. They are all on the same instance. As I said I am a ASP programmer. SQL is a little foreign. We have 4 ASP programmers, but the other 3 can not even help with SQL. Is there a good place to learn about doing what I asked above or where can I go to really know what to do.Thank you |
 |
|
|
|
|
|
Extract Table from database