MSSQLTips

Need logic to implement, export of data from different tables to their respective files in a single batch.. No joins, merge, nothing... just a file containing 'increment' extract of the table. a daily batch.

I am going to migrate SQL Database-2000 with Service Pack-1 TO SQl 2005. But I do not want to change the Compatibility mode. So, what are the changes should require? Or what is the list of changes, which I should keep in mind at the time of migration.