Archiving old data in sql server 2008

Hi,
[SQL Server 2008 Express]
[C# 4.0]

I've developed a winforms application, I want to give the user the opportunity to archive old data at the beginning

of each year.

The user can for example connect to to consult his archive.

The real scenario happens as follows: The user is working on the database, till the beginning of the

next year(2011), he clicks on , I want to copy then delete all 2010 transactional data

(keeping customers, suppliers, employees, balances...) data to a new database called , I keep track

of all archive filenames and location in an XML file.

I'd like to know the steps to follow on both sides, SQL and C# in order to achieve this task.

I welcome any suggestion, tip, samples, links, books...

Thanks.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Subhendu De16y ago
If your database is SQL Server then I would suggest you to create one SSIS package and call it from .NET code. You can find several articles in internet how to create SSIS package and call it from .NET code.
0