copying data from sql server to sql server

[impulse24]

Hi All,

I have had a file sent to me from the customer, and it has a .dat extension. They said it was a dump of the sql database. How do I restore this file? I have tried using restore database, and import DTS with no luck. I looked into copying data from a data file into sql, and am still lost. The name of the data file is sqldump.dat. I don't know what the source table name or field layouts are, how do I bring this file into my sql server, and have it create the database, and tables.

Please help me.

 

[tlbroadbent]

How did they dump the data? WHat version of SQL Server did they use? Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[impulse24]

they used sql server 6.5

 

[tlbroadbent]

If the file is a SQL 6.5 database file, the only way you can retrieve the data is to load it into SQL 6.5 and even that would be difficult. You would need to know exactly how ow the database was created, number of segments, etc.

Ask the customer to export the data to a flat file and send that. You may end up with multiple files - one per table - but the files could be imported. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.