Q
Problem solve Get help with specific problems with your technologies, process and projects.

Restoring Sybase dump into SQL Server?

Can I restore a dump taken in Sybase into SQL Server? If yes, how? I tried with load and restore from disk command, but it says it is not in Microsoft format.

No Sorry. SQL Server backups use Microsoft Tape Format. The best option is to use DTS to copy the data from Sybase to SQL Server. If you don't have a direct network connection between the two use BCP to export to flat file and then to import into SQL Server.

 

For More Information

Dig Deeper on Microsoft SQL Server Installation

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close