Unanswered: importing a sysbase database into SQL server.
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 Ed
You 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.
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 for delivery tomorrow.