Post reply

outputting a sql database to an email /to windows

  • May 1, 2010 at 5:54 am

    #218355

    I have imported a microsoft database into sql server but now I want to 'export' it out into a folder in windows explorer in order to email it? has anyone know the easiest wya to do this. Is it making a backup of the database?

  • May 1, 2010 at 6:23 am

    #1160888

    craig 84462 (5/1/2010)

    I have imported a microsoft database into sql server but now I want to 'export' it out into a folder in windows explorer in order to email it? has anyone know the easiest wya to do this. Is it making a backup of the database?

    yes, making a backup, zipping it is the recommended way; but any database with any amount of data is going to exceed most email servers max size limits; you'll most likely need to put the zip of the backup on an ftp site and email the site/ftp_username/ftp_password instead

    making a backup is easy: right click on the database name in SSMS, Select Tasks...Backup...

    let us know if you need more advice.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply