Help Req for DB implementation

  • Hi

    I am supposed to implement a database at client's site.

    This is my first implementation task.

    I need detailed listing of tasks involved (step by step).

    thank you

  • We'll probably need a little more info....

    Is this a new database setup, or are you moving from an older one to a new one? Off the top of my head, the basics would probably be:

    install SQL Server 2005 onto a server

    if you're setting up a new database from scratch, you'll need to create the new database and any structures in it. Hopefully there would be SQL scripts to do this?

    If you're migrating an old database, I'd probably back up the original, and restore on the new installation.

    But really,

    I am supposed to implement a database at client's site.

    This is my first implementation task.

    I need detailed listing of tasks involved (step by step).

    is pretty vague, especially if you've never done something like that before. Do you have any more details?

  • Hi

    Thank you for your reply

    Now I am working with development DB. I have little experience in installing SQL Server, Attach/Detaching Databases, Scripting and Creating Databases.

    As you said I am planning to Install SQL server first with Service Pack 2

    and run DB scripts

    Due to Lack of Deployment experience I am worried about missing out any thing which may create future problems. Can you please add your suggestions regarding effective deployment.

    regards

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

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