Post reply

Needed database structure of the current database

  • April 20, 2006 at 10:59 am

    #89923

    Hi Everyone,

    I will need SQL database structure of my current database. Let me describe my problem in brief. We have SQL database with around 50 GB size now company wants to migrate that database with only database structure and data should be start from beginning.

    We are using SQL server 2000 standard edition.

    Any thoughts appriciates.

    Thanks,

    Shardul Shah

  • April 20, 2006 at 11:10 am

    #633325

    Are you saying that you need to script your current database and recreate it? What is your question?

  • April 20, 2006 at 11:18 am

    #633327

    Yes. some short of script or SP or anything which can truncate all the tables including login info and i will get database structure back.

     

  • April 20, 2006 at 12:01 pm

    #633337

    If all you want is the table structures, there's a way to do that through the right-click menu in Enterprise Manager (All tasks | generate SQL Script). 

    Also take a look at this:

    http://www.sqlservercentral.com/columnists/jyao/migratingdatabaseobjects.asp

  • April 20, 2006 at 12:06 pm

    #633340

    This is really great and once again thanks..

     

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

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