How do I copy records from one database to another?

I need to pull data from one SQL 2005 Express database to another and I need to do this periodically. It is not a straight copy from one table to another, but I would use different views from the source table. I also need to do this periodically.

My first idea is to write a small application in C# and run it somehow in every hour or so, but I would like to keep this data manipulation logic as close to the database server as possible.

What are the tools and features that I can use SQL 开发者_Python百科Server 2005 Express?

1. Add linked server: Server Objects->Linked Servers
2. a) Write script to copy (you don't prefer this method, I think)
   b) Create package SSIS in VS and execute it with different parameters (you can pass input parameters to package)
   c) Use wizard (Import/Export) than save this task as package (as file to edit or to server to execute)

I think c) is your case.

EXPRESS has no SQL Server Agent, so use other server (enterprise or standard editions) to execute your package periodically