Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jono78
Starting Member
1 Post |
 Posted - 2005-11-11 : 22:41:37
|
| i have a BAK file that was created from M S S Q L 7. how can i open or convert that file to a different format?what i'm trying to do is: take an existing database with its contents and then save it in a different file format to be used in a different database.i'm trying to use Case Studiohttp://www.casestudio.com/enu/products.aspxany help? |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-11-12 : 01:01:16
|
| you can't open that bak file with any tool that I know of. The only way to do what you are trying to do is to restore the .bak file into a running instance of SQL Server. You can then point your tools at that database to perform the conversion.-ec |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-11-12 : 05:44:50
|
| Hi jono78, Welcome to SQL Team!MSDE is a "freebie" version of SQL Server, so if you can find a copy you can download (SQL7 or SQL2000 will do, either can restore a SQL7 backup) then you could get the backup into that database - to then export/migrate it.Kristen |
|
|
|
|
|
|
sql conversion from bak file