• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 263
  • Last Modified:

Copy Data Nightly?

Hi,

I am using SQL 2005

I have a database that contains just one table and I would like to copy the data to 3 other tables that are in different databases.   If a column gets added to the source database table AND the data has changed for example in that column, I want to ensure when the copy process starts, it either drops the table on the destination databases and then re-creates the table and pushes the data across.   How can I do this in a way that will keep my constraints and everything intact.

Say the source database has a table called "Employees".  The columns are:

employee_id
first_name
last_name

I would like to copy the schema and the data and push it to 3 other destination/target db each night at midnight.

Any help appreciated

Thanks,

-ws
0
Westside2004
Asked:
Westside2004
  • 2
  • 2
1 Solution
 
jorge_torizResearch & Development ManagerCommented:
If you use the import/export wizard to generate a SSIS package, and then run this package with the sql server agent?
0
 
Westside2004Author Commented:
Hi,

How can I automate this though?

-ws
0
 
jorge_torizResearch & Development ManagerCommented:
Right click in your database and then choose tasks - import/export data... this wizard will guide you to generate a SSIS package... then, IN THE WIZARD save the package in sql server.

In your sql server agent, add a job that execute this package.
0
 
Westside2004Author Commented:
Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now