importing a sysbase database into SQL server.

Hi

Has anyone done this before, I have been given some flat files for a Sybase database to import into SQL server. Yet SQL server doesn't want to know. I have a .db and .log, but SQLserv er doesn't like either of them.

However I'm not sure what to do, I have been given a .db and .log . but SQL server doesn't like either of these, is their something I should do to make it compatable? First tie I've ever look at Sysserver so please use short words, Thanks EdYou can't restore a Sybase database onto an MS-SQL server. Your best bet is to restore the files to another Sybase server of exactly the same version/service pack (they are really persnickity about that), then use either DTS or a linked server to move the schema/data to an empty MS-SQL database.

-PatP|||Right okay i think we will have to look at talking to the people who have provided the database.

Thanks for the info!|||Microsoft has a Sybase to SQL Server migration tool. I thinks it's available in the SQL server 200 resource kit. It works really well.|||Excellent point Peter! Ed really should check out Chapter 6 (http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0661.mspx) of The SQL Resource Kit before he goes too far with this process!

-PatP|||I'd use the dts utility just like if your were importing a exel file into access.|||Excellent , thanks for the help

I like the sound of the tool in the the "SQL server 200 resource kit" The only thing is I'm not sure how to get hold of it? Do you have to order the CD or is it something I can download?|||Most of the larger bookstores stock the SQL Server Resource Kit. Drop by your friendly neighborhood Barnes and Noble, Borders, etc and you should have no problem. If push comes to shove, you can always order it online (http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=ZYw1fKKpGI&isbn=0735612668&itm=3) for delivery tomorrow.

-PatP