Hi guys
I am currently doing a job that I need to migrate a database from a sql 2000 server to sql 2008 server. My questions are:
1. if I get the backup file (database.bak) and restore it onto the sql 2008 server, will the DTS packages, security settings, tables, views ect all be transferred? (what data does a bak file actually contain?)
2. if not, what's the best way to migrate DTS packages to SSISs ? I learned that it's like only 50% of DTS can be transferred ok.......
3. if not, how do I transfer security settings?
Thanks for your helps guys!
Xavier