How can I bring a .dat database file into SQL Server 2005?

Tags:
SQL Server 2000
SQL Server 2005
I need to bring a .dat database into SQL Server 2005. When I right click on database and Task, I don’t get the "Copy Database" option. What do I need to have this? What is an alternative method to bring the SQL Server 2000 database into SQL Server 2005 Express?

Answer Wiki

Thanks. We'll let you know when a new response is added.

.DAT files aren’t usually SQL Server databases. Microsoft SQL Server database files are usually MDF and LDF files with the MDF files being the data file and the LDF being the log file. Microsoft SQL Server hasn’t used the .DAT file extension since SQL Server 6.5. Are you sure that this is a SQL Server database file?

Assuming that it is a SQL Server database file you can right click on the databases node in the Enterprise Manager (SQL 2000) or Management Studio (SQL 2005) and select attach database. Select the correct data file and click OK, or Attach. If it’s a valid SQL Server file SQL will attach the database and you will then be able to query the file.

If it’s not a SQL Server database file you’ll need to use whatever database software made the file and then use the import/export wizard to connect to that database and copy the records into the SQL Server database.

In either case the process is basically the same in SQL Server 7-SQL Server 2008.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following