Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2008
    Location
    India
    Posts
    40

    Unanswered: Retreival of data from sql server

    Hi all.
    I am new to sql server.There is a requirement of archiving data from db2 to sqlserver.We need to retreive data from sqlserver.

    Can anybody guide me on the different ways to retreive data from sql server?
    If i get any link or useful documents on that, it would be great.

    Thanks
    Neena

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Quote Originally Posted by Neena John
    an anybody guide me on the different ways to retreive data from sql server?
    Same as in DB2: SELECT

    If i get any link or useful documents on that, it would be great.
    Books Online

  3. #3
    Join Date
    Aug 2008
    Location
    India
    Posts
    55
    Different ways to transfer data between two different servers
    1.Database backup / restore.
    2.Detach the database , copy mdf and ldf files
    3.Import /Export wizard .
    Please refer SQL server Books on line or support.microsoft.com
    How to move databases between computers that are running SQL Server

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •