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 <myApp_db_year> to consult his <year>archive.
The real scenario happens as follows: The user is working on the <myApp_db> database, till the beginning of the
next year(2011), he clicks on <Archive Last Year Data>, I want to copy then delete all 2010 transactional data
(keeping customers, suppliers, employees, balances...) data to a new database called <myApp_db_2010>, 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.