Exporting SQL database
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=3386
Printed Date: 29 March 2026 at 10:54pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Exporting SQL database
Posted By: Gullanian
Subject: Exporting SQL database
Date Posted: 08 June 2003 at 1:24pm
| How can I send an SQL database to someone keeping all database relations etc? |
Replies:
Posted By: michael
Date Posted: 08 June 2003 at 6:23pm
|
Make a backup of you db and as him to restore it or send him a Script of your db and export your data to a file, send him both, there are a few ways but I guess a backup file would be the most feasable ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: Gullanian
Date Posted: 09 June 2003 at 3:13am
| so i mean is it possible to actually copy and paste the two database files, would that work? |
Posted By: MorningZ
Date Posted: 09 June 2003 at 5:32am
|
no, its a bit more effort than that.. you have to "restore", then "backup" man, all these SQL q's.. RTFM ------------- Contribute to the working anarchy we fondly call the Internet |
Posted By: michael
Date Posted: 09 June 2003 at 7:57am
|
You theoretically could copy the mdfs and ldfs then re-attach them through EM or script but the problem is that if the db has users, those links might get dropped as the links are via id's and not names. ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: michael
Date Posted: 09 June 2003 at 8:01am
|
Also if you worried about space and need to do it more often consider SQL http://www.sqllitespeed.com/slsevaluation.asp - LiteSpeed it got me to shrink our master backup (0.8 TB Database) from 320MB to 82 MB and cut the time in to backup in less then half. ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: mrd_yaddayadda
Date Posted: 16 June 2003 at 6:50am
Yeah! How dare people ask.... database questions in a... database forum. Freaks! |
MorningZ wrote: