BorlandTalk.com

Alan T · Guest

Hi,

I would like to zip up the database in cases of MS Access and SQL Server.
There is no problem in Access but have no idea how do I zip up the SQL
Server database.

Craig · Guest

Brian Bushay TeamB · Guest

Bill Todd · Guest

Instead of detaching the database then zipping the database and log why
not backup the database, zip the backup file then perform a restore at
the destination.

--
Bill Todd (TeamB)

Gary Wardell · Guest

If the idea is to send it to another location,

And if the database is set to "Full" recovery, I would reommend doing a full
backup and a transaction log backup to remove no longer used log records. I
belive this can also be accomplished by setting the Recovery Model to
Simple. (you would want to set it back to Full after the move.)

Then shrink the database to with Move Pages to Beginning of File checked.
This will make your database smaller and result in a smaller zip file. That
savings can be considerable.

It doesn't seem to make much difference if you detach or backup. The only
difference I've noticed is one way you have two files to zip and the other
only one. But once it's zipped there is only one either way.

On the destination machine simply attach the database (mdf file). I
recommend also setting the proper database owner.

If you did a backup instead, then restored the backup. There is one tricky
part here, if the drive layout/database location is different than the
source machine you'll need to adjust for that on the Restore Database
Options tab (I use Enterprise Manager for this) You can edit the names in
the grid to suite your situation. Notice that one column is the logical
file name in the backup and the other column is the physical file on the
destination hard drive.

After moving the database you will have to reconnect your now orphaned
users. This is explained in books Online and in a few KB articles.
Sometimes it's easier to delete all of the users except one, the dbo, before
the move and then re add them on the target server.

Hope this helps.

Alan T · Guest

Hi,
This is our situation: sometimes our client have problem in the application,
we want them to send us their database file to investigate. So they need to
make a copy of the database, strip off some confidential data like employee
table fields, eg. name, dob, gender, address...etc.

The steps are as follows in our application:
1) User press a button in the application
2) Our application will make a copy of the database
2) Replace personal data with dummy data of that copy
3) Zip that copy up

Then the client will send the zipped file by email to us.

"Gary Wardell" <nospam (AT) sample (DOT) com> wrote in message
news:4639e815$1 (AT) newsgroups (DOT) borland.com...

Alan T · Guest

Hi,
If my situation is too complicated, can I do this for the SQL Server
database:
1) Export the database into a text file
2) During the data export, replace the firstname and lastname field of a
table with some string like yymmdd_1..etc?

"Alan T" <alanpltseNOSPAM (AT) yahoo (DOT) com.au> wrote in message
news:463a83c6 (AT) newsgroups (DOT) borland.com...