Please suggest

[ME_Learner]

Hi I have a senario in which I need to move the data from one database to another depending upon some conditions so that it will reduce some load on one database.For example we have A and B database and lets say lots of new data comes into database A daily.Now i want to put a logic so that some of infrequently used data in database A can be moved to database B on a daily basis.Once data is moved from A database to B databse data will be deleted from A thus reducing load on database A.so daily this process goes on and data from A will be moved to B.So B contains all the data that is moved from A daily and no data of previous day is overwritten on B.Will replication be helpful in this senario ?

[Mycroft Holmes]

What you are talking about is ARCHIVING, and replication can be useful here. You need to identify the database you are using, the strategy will be different for the type (SQL Server/Oracle/ MySQL do not relate to Access). Personally we use an SSIS (SQL Server) package to move the data from the active DB to the archive DB in the low processing period (2am in our case) and do any other maintenance required. You might also look into creating an OLAP cube as you archive destination.

Never underestimate the power of human stupidity RAH

[David Mujica]

Check this article out ... This might be what you are looking to accomplish. http://www.databasejournal.com/features/mssql/article.php/3638236/Data-partitioning-in-SQL-Server-2005---Part-I.htm[^]