I don't think you are going to be able to load a Sybase DB via restore database in SQL Server. I think you are going to have to go the SSIS route, or extract DDL/create and then BCP/Bulk Load data to the tables.