Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  Automation ...

Author  Topic  kamrul3d Starting Member 1 Post Posted - 2009-03-05 : 06:50:48 Here are my requirements, i have around 5000 backup file(full database backup) for the last 2 years.No i wants to create a data warehouse(simple) for my database. my initial tables are 1. item(id,description) 2. category(id,name,pid) and there is a column changes occurs in different version of my database... for example when the image functionality is added to we have changed the table item(id,description) to item(id,description,image_link)... and so on. now i wants all the items information for the last 2 years(using 5000 backup files) what will be the process? any sample scripts are highly appreciated. Thanks ********** [ from my observation ... Procedure may be... [*] create new database for warehouse purpose and another one for restore purpose. [1] use current item table structure [2] column should support null (current_tables_columns-initial_tables_columns) [3] extra one column for database version(i.e .bak file name) ... here i might use cursors for looping purpose of my backup files(5000) [4] restore one database [5] if new id then insert new record else update previous record I'm new to administrating please help me! ]