I've a sql server 2000 database, and now its size has increased tremendously. it is roughly 20 GB. this db contains data since last 4 years i.e. 2007.
so i would like to create a new db with same schema, move all the data for the year 2007-2008 from the existing database to this newly created db. and then continue to use the exisitng db with my application. now in my application, there will be an
option to switch db, if i select the newly created db, it will fetch the data for year 2007-2008. if i select the existing db, it will be working with the current data.
please suggest what is the best approah to work on this. my application is a vb.net desktop application with framework 2.0.
View Complete Post