Home > IT Answers > Storage > Archiving a row of data into another database on SQL Server 2005
SQL Server Ask the Experts
2,585 pts.
 Archiving a row of data into another database on SQL Server 2005
Archiving, SQL Server 2005, SQL Server archiving, SQL Server database
I work on SQL Server 2005, and I need to archive a row and its relationship into another database. I know a script could be written to do this, but I would like to know if software exists that could be given the data row and then complete the archiving by itself. Is this possible?

Software/Hardware used:
ASKED: September 16, 2008  6:19 PM
UPDATED: September 16, 2008  11:45 PM
RELATED QUESTIONS
Answer Wiki:
Data archiving requires a very one off approach most of the time. The most effective, scalable and reliable method will be to write scripts to handle the data migration manually.
Last Wiki Answer Submitted:  September 16, 2008  11:45 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

Denny Cherry
 64,520 pts.