I want to separate it into 2 databases in sqlserver
I have more than 7 years datas (91 GB).I want to separate it into 2 databasesone for current data's ie. for the last 2 financial years
another one for old data's
how to do it?.
You must Sign In to post a response.
Category: SQL Server
one for current data's ie. for the last 2 financial years
another one for old data's
how to do it?.
#769771
I think you have to create 2 separate data bases i.e DB_LIVE and DB_Archive to achieve this requirement
So, same table schema definitions should be there in 2nd DB and on the first DB i.e DB_LIVE tables will be having triggers to post the data into DB_Archive once the rule which is satisfied like 2 years from the current date results rows will get inserted into the Archive DB tables and same results will get deleted from the DB_Live.
similar thing you can achieve by writing SQL Jobs to process the beyond 2 years data into Archive and delete from LIVE
Thanks!
B.Ramana Reddy
So, same table schema definitions should be there in 2nd DB and on the first DB i.e DB_LIVE tables will be having triggers to post the data into DB_Archive once the rule which is satisfied like 2 years from the current date results rows will get inserted into the Archive DB tables and same results will get deleted from the DB_Live.
similar thing you can achieve by writing SQL Jobs to process the beyond 2 years data into Archive and delete from LIVE
Thanks!
B.Ramana Reddy
#769772
hi
If you have datefield we need segregate datewise records push to temp table .
create one tool for reading data and push to new table using import and export tool depends your table date wise
Name : Dotnet Developer-2015
Email Id : kumaraspcode2009@gmail.com
'Not by might nor by power, but by my Spirit,' says the LORD Almighty.
If you have datefield we need segregate datewise records push to temp table .
create one tool for reading data and push to new table using import and export tool depends your table date wise
Name : Dotnet Developer-2015
Email Id : kumaraspcode2009@gmail.com
'Not by might nor by power, but by my Spirit,' says the LORD Almighty.
Return to Return to Discussion Forum