Post reply

Data Migration

  • March 30, 2009 at 1:33 am

    #136200

    hi Friends,

    Actually i m not a DBA but the situation given to me is just perfact for this forum category....

    I work in One of the product development Company..We have dveloped our ERP and we have many clients also....

    We have Crystal reports as reporting tool and sql 2005 as backend..

    Now See the scene is like this...

    Few of our clients have 4-5 years Data gethered on their dastabse....

    Now the database has become very large so it is responding slow for any damn reports execution...

    Now as per the solution we thinking that we should break the current database in to 2 or 3 databases based on years means every two years data will have the new database....And also we should automate the data moving process based on the conditions like if its two years old it should move to the differnet server.

    Now how to achive this is the question adn our problem?

    Means first how to break this database and then how to automate the data moving on daily basis...

    Thanks & Regards,

    Mithun Gite

  • March 30, 2009 at 5:28 am

    #968225

    Here is a link on how to archive old data using T-SQL

    --Ramesh

  • March 30, 2009 at 11:17 pm

    #968861

    And how to move day to day data ? should i go with differantial backup on daily basis ???

  • March 31, 2009 at 3:07 am

    #968912

    You just need to write your own script using the code provided in the link and put this script in an SQL Server Job and schedule it on a daily basis on non-productive hours.

    --Ramesh

  • March 31, 2009 at 3:19 am

    #968917

    yeah ramesh seems fine,, i need to find out the tables which i want to archive ,,,,fine

    thanks very much sir...

    regards,

    Mithun Gite

  • March 31, 2009 at 3:55 am

    #968928

    You are welcome, and I'm glad I could help you.

    --Ramesh

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply