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 |
|
ck1
Starting Member
1 Post |
 Posted - 2005-12-05 : 09:02:19
|
| Anyone have any suggestions or tools on how to gain access to a .bak file without having SQL? Are there any tools that can extract the individual db's contained? |
|
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2005-12-05 : 14:29:06
|
| Do you know assembly/ how to read binary data? LOL. Why not get a trial copy of SQL Server from microsoft for $10?Daniel, MCP, A+SQL Server DBAwww.dallasteam.com |
 |
|
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2005-12-05 : 14:50:09
|
quote:
Originally posted by SQLServerDBA_Dan
Do you know assembly/ how to read binary data? LOL. Why not get a trial copy of SQL Server from microsoft for $10?Daniel, MCP, A+SQL Server DBAwww.dallasteam.com
I can't find a link to get SQL 2000 anymore. Everything seems to be taken over by SQL 2005. Maybe you could call them... |
|
|
|
bakerjon
Posting Yak Master
145 Posts |
|
|
sqlfan2
26 Posts |
Posted - 2006-01-19 : 23:08:43
|
| Can I import an MS SQL bak file into an Access DB? If not, then how would you suggest I get a file structure from an MS SQL DB to an Access DB?Thanks!----------------------------------Standing on the shoulders of giants |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-01-20 : 03:53:30
|
| "Can I import an MS SQL bak file into an Access DB"No"how would you suggest I get a file structure from an MS SQL DB to an Access DB?"1) Restore the BAK file to an instance of MS SQL Server.Use Enterprise Manager to "Generate script" for the databaseRun the script on Access - fix each syntax variation as it arises.2) Don't! Use MSDE as the database "host" and link Access to itKristen |
|
|
|
sqlfan2
26 Posts |
Posted - 2006-01-24 : 11:54:11
|
| Thanks Kristen!I don't have Enterprise Manager - I use osql. So I assume that I just need to find the osql command to "generate script" for the DB then?Thanks again!----------------------------------Standing on the shoulders of giants |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-01-24 : 13:46:07
|
"I just need to find the osql command to "generate script" for the DB then"Ah ...  ... there isn't an OSQL command to do this ...The SQL Client Tools work just find with MSDE etc. So you just need to root around your CD box, or your mate's  , to find and install a copy of them.There are other ways of scripting everything, but to be honest its a bit tortuous by comparison.Kristen |
|
|
|
sqlfan2
26 Posts |
Posted - 2006-01-24 : 14:20:28
|
Thanks Kristen - your help is appreciated as always  ----------------------------------Standing on the shoulders of giants |
|
|
|
|
|
|
SQL .bak file