Hi, Is it a topic or sample about moving data between old database to new database structure and handle the difference ( the changes after the first flesh run) Thanks...

Hi, You mean as database comparision? There are many tools for it, even the Visual Studio.Vctor M. Snchez Garca (ES) (BI) Hope this help. Please vote if you find this posting was helpful. if this is an answer to your question, please mark it. http://bifase.blogspot.com | http://twitter.com/atharky

If you are talking about moving the databases between SQL Servers then take a look at the Transfer Database Task Arthur My Blog

Thanks for the help. The two database structure (table structure) is different. We’re developing a new system and trying to move the data over. First run, need to move some preference set data and later on and keeping two systems running and finally, need to move the changed data set. Is it the Integration service is the right tool for this kind task?

Yes, you may be as specific (in mapping of what and how you move) in your Data Flow Transformations. I have one suggestion - you can use SQL Server Import/Export Wizard , set it to what makes sense and make it a SSIS package which you can modify and run anymore times.Arthur My Blog

You can use SSIS packages to populate new schema (alter natively write T-SQL scripts) also would advice to look CDC for incremental data changes here is CDC sample http://www.simple-talk.com/sql/learn-sql-server/introduction-to-change-data-capture-%28cdc%29-in-sql-server-2008/