Post reply

Script to Export existing SQL 2008 DB

  • March 2, 2010 at 10:36 pm

    #221231

    Hi There,

    Can someone please help me ?

    I need a script to export an existing DB in SQL2008.

    Thank You !!

  • March 2, 2010 at 11:39 pm

    #1127546

    Right click on user DB for which script is required -> Task - > Generate scripts and choose all items needed and then get the script to query window or to a file , this will only copy schema , database definition , data needs to be required to be export/Import wizard or copied using BCP OUT and BCP IN . or Backup database and restore it in required place , this will not get along with user permissions

  • March 3, 2010 at 2:14 am

    #1127590

    Hi rajganesh.dba,

    Sorry if i sound like a n00b, but im quite new to being a junior dba, and i really dont understand all that you are explaining. Could you maybe explain it more in lamens terms, or give me a break down ? Id really appreciate it !

    Thank you !

  • March 3, 2010 at 11:12 pm

    #1128279

    Hello ? Anybody ?

  • March 4, 2010 at 1:39 am

    #1128324

    Would you please tell us what you intend to do with the 'scripted db'..what the end goal is? Is this for source control, the creation of an empty DB, are you intentionally excluding data?

Viewing 5 posts - 1 through 4 (of 4 total)

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