is there any featurein SQL 2K5 that will allow me to transfer both data and table schema (i.e. table definition, indexes, primary key, trigger, etc) in a single process, which can be done in SQL 2K.
While the feature isn't available in the import/export wizard anymore, it is still a task in SSIS called Transfer SQL Server Objects task. You have to create an SSIS package rather than run the wizard.