User not logged in - login - register
Home Calendar Books School Tool Photo Gallery Message Boards Users Statistics Advertise Site Info
go to bottom | |
 Message Boards » » Any DBA's out there can help? (.BAK file convert) Page [1]  
Kainen
All American
3507 Posts
user info
edit post

AIIIIEEEE! Guys, can someone help me convert a .BAK file to a .CSV spreadsheet?

Basically I've got this database backup file but need it in CSV to import it into a new database I'm using. Now I'm not too sure how to do this or convert this. I need it to be a free tool, or perhaps one of you have SQL server or something else that can make this conversion?

11/4/2008 2:09:40 PM

Tiberius
Suspended
7607 Posts
user info
edit post

50 dollars

[Edited on November 4, 2008 at 2:11 PM. Reason : dead serious, I don't do people's jobs for free]

11/4/2008 2:11:08 PM

Kainen
All American
3507 Posts
user info
edit post



Well jeez even some free guidance for a fellow alum then? I don't have any money to spend and I just need help with a conversion. i have the .BAK file in a 29 meg zip. I used a freeware excel converter that did this but the output was garbage

11/4/2008 2:15:37 PM

qntmfred
retired
40726 Posts
user info
edit post

i'll do it for $85

11/4/2008 2:15:47 PM

moe
All American
683 Posts
user info
edit post

if it isn't that big of a database (could get tedious if you have a lot of tables) maybe you could try...

1) download microsoft sql server express
2) restore database from .BAK file
3) open the table
4) copy/paste into excel
5) save as .csv

not sure that works, but maybe give it a try.

11/4/2008 2:19:25 PM

qntmfred
retired
40726 Posts
user info
edit post

if you right click on the db in sql express, there's a data export under tasks where you can do multiple tables

[Edited on November 4, 2008 at 2:22 PM. Reason : rather than open table copy/paste]

11/4/2008 2:21:41 PM

moe
All American
683 Posts
user info
edit post

^ yes I suppose that would be easier

11/4/2008 2:23:36 PM

qntmfred
retired
40726 Posts
user info
edit post

i'll send my bill in the mail

11/4/2008 2:28:51 PM

synapse
play so hard
60939 Posts
user info
edit post

Quote :
"microsoft sql server express"


yepp

http://www.microsoft.com/express/sql/

11/4/2008 3:47:34 PM

evan
All American
27701 Posts
user info
edit post

yeah, you can't go straight from a bak to plaintext.

restore it into sql server express and then use something like DTS

11/4/2008 4:53:57 PM

 Message Boards » Tech Talk » Any DBA's out there can help? (.BAK file convert) Page [1]  
go to top | |
Admin Options : move topic | lock topic

© 2024 by The Wolf Web - All Rights Reserved.
The material located at this site is not endorsed, sponsored or provided by or on behalf of North Carolina State University.
Powered by CrazyWeb v2.39 - our disclaimer.