Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Restoring .dat file into SQL server 2005


Restoring .dat file into SQL server 2005

Author
Message
shameersinbox
shameersinbox
Grasshopper
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
Points: 11 Visits: 94
I cannot restore my old database from SQL server 2000 into SQL server 2005 which is a .dat file.
I had tried with the MOVE command also.How can i restore the .dat into SQL server 2005. Please help me....
GilaMonster
GilaMonster
SSC-Forever
SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)

Group: General Forum Members
Points: 47143 Visits: 44346
.dat?

That's not a standard SQL file exention. Is it a backup? How did you ceate the .dat file?

Also, what have you tried and what have the results been?


Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


shameersinbox
shameersinbox
Grasshopper
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
Points: 11 Visits: 94
I am running a small software development company..In one of my current projects i got the database as .dat file from the client, but now am using SQL server 2005 and i want all the data from the .dat file.
How can i restore it into SQL server 2005.
IN_Sandeep
IN_Sandeep
Old Hand
Old Hand (377 reputation)Old Hand (377 reputation)Old Hand (377 reputation)Old Hand (377 reputation)Old Hand (377 reputation)Old Hand (377 reputation)Old Hand (377 reputation)Old Hand (377 reputation)

Group: General Forum Members
Points: 377 Visits: 1255
1st tell me where you got this file...WinkTongueSmileCoolHehew00t
and do you have windows media player or not????BigGrinw00tHeheCoolSmileCool

Cheers!

Sandy.

--
GilaMonster
GilaMonster
SSC-Forever
SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)

Group: General Forum Members
Points: 47143 Visits: 44346
shameersinbox (7/22/2008)
How can i restore it into SQL server 2005.


Without knowing how it was created, no idea. Please ask your client where the file came from and what app they used to create it.


Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


Timothy J Hartford
Timothy J Hartford
SSC Veteran
SSC Veteran (246 reputation)SSC Veteran (246 reputation)SSC Veteran (246 reputation)SSC Veteran (246 reputation)SSC Veteran (246 reputation)SSC Veteran (246 reputation)SSC Veteran (246 reputation)SSC Veteran (246 reputation)

Group: General Forum Members
Points: 246 Visits: 502
Just out of curiosity I asked my friend google about .dat files. Check out http://www.fileinfo.net/extension/dat for a general discription. Basically, a DAT file can be anything from a standard CSV (comma delimited data-file) to a proprietary binary file. From my own experience, I have seen .dat files (and .data files, used interchangeable) be used to store sets of class objects from specific applications, to images, to full in-house low-level databases. My guess is that yours is the third.

Hope this helps you understand why everyone wants to know where this file came from! Good luck!Smile
steveb.
steveb.
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2848 Visits: 7195
Open up the .dat file in Textpad,

It may contain SQL scripts to create the required databse objects that you can apply to your database. Check that the scripts are safe to run and run them against your dev server.

Or it may contain table data in a delimmted form that you can import in SQL server.

Either way have a look at the contents of the file to see what to do.
Jeffrey Irish
Jeffrey Irish
SSC-Enthusiastic
SSC-Enthusiastic (155 reputation)SSC-Enthusiastic (155 reputation)SSC-Enthusiastic (155 reputation)SSC-Enthusiastic (155 reputation)SSC-Enthusiastic (155 reputation)SSC-Enthusiastic (155 reputation)SSC-Enthusiastic (155 reputation)SSC-Enthusiastic (155 reputation)

Group: General Forum Members
Points: 155 Visits: 1120
Gail is right. It's really difficult to know what to do if the source of the file is unknown. w00t

Since it is a *.dat file, it's not likely to be a SQL Server Backup, but it could be since SQL does not "require" a backup extension for the file (even though it makes it easier BigGrin)

As suggested earlier, I would try opening the file in notepad or wordpad. A dat file might also be something from Excel for all we know. In any case, it is unlikely to be a database that someone just detached and forwarded along for you to attach to your server.

You might suggest to whomever sent you the file to try taking a backup of the database, assuming one exists, and send you that file to work with the data.

Good luck!

Regards,

Irish w00t
neneco56
neneco56
Valued Member
Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)

Group: General Forum Members
Points: 62 Visits: 534
DAT files are created on old version of sql 6.5
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search