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 |