Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Database & SysAdmin
  3. Database
  4. Transfer Database

Transfer Database

Scheduled Pinned Locked Moved Database
databasesql-serversysadmincloudtools
6 Posts 5 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • Z Offline
    Z Offline
    Zeyad Jalil
    wrote on last edited by
    #1

    Hi All, I try to transfer my database from sql server 2008 to sql azure but the all ways failed until this time. Please help me.. How I can transfer a database (Schema script + Data) from a local sql server 2008 to sql azure. Thanks all

    F S 2 Replies Last reply
    0
    • Z Zeyad Jalil

      Hi All, I try to transfer my database from sql server 2008 to sql azure but the all ways failed until this time. Please help me.. How I can transfer a database (Schema script + Data) from a local sql server 2008 to sql azure. Thanks all

      F Offline
      F Offline
      foxyland
      wrote on last edited by
      #2

      Doesn't the backup-database-on-MSSQL2008-and-restore-it-on-azure work? Honestly, I have not use Azure yet, but because it worked on 2000-2005-2008, and I guess, it would work on Azure as well. hth, foxyland

      Z 1 Reply Last reply
      0
      • F foxyland

        Doesn't the backup-database-on-MSSQL2008-and-restore-it-on-azure work? Honestly, I have not use Azure yet, but because it worked on 2000-2005-2008, and I guess, it would work on Azure as well. hth, foxyland

        Z Offline
        Z Offline
        Zeyad Jalil
        wrote on last edited by
        #3

        when i try to restore it the following error shown: Statement 'RESTORE DATABASE' is not supported in this version of SQL Server.

        R S 2 Replies Last reply
        0
        • Z Zeyad Jalil

          Hi All, I try to transfer my database from sql server 2008 to sql azure but the all ways failed until this time. Please help me.. How I can transfer a database (Schema script + Data) from a local sql server 2008 to sql azure. Thanks all

          S Offline
          S Offline
          Simon_Whale
          wrote on last edited by
          #4

          Have a read of this Migrating database to SQL Azure[^]

          Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch

          1 Reply Last reply
          0
          • Z Zeyad Jalil

            when i try to restore it the following error shown: Statement 'RESTORE DATABASE' is not supported in this version of SQL Server.

            R Offline
            R Offline
            rana ray
            wrote on last edited by
            #5

            Is it resolved now? regards, Vatsa www.objectiveprogramming.com

            1 Reply Last reply
            0
            • Z Zeyad Jalil

              when i try to restore it the following error shown: Statement 'RESTORE DATABASE' is not supported in this version of SQL Server.

              S Offline
              S Offline
              sherabhs
              wrote on last edited by
              #6

              I think there is edition mismatch between both the database instances where you are trying to backup and restore. Please check the edition of your source instance and destination of target instance. you cannot restore from a higher edition to a lower edition. For Ex- Restoration from standard edition backup to workgroup edition is not possible .

              sheela DBA

              1 Reply Last reply
              0
              Reply
              • Reply as topic
              Log in to reply
              • Oldest to Newest
              • Newest to Oldest
              • Most Votes


              • Login

              • Don't have an account? Register

              • Login or register to search.
              • First post
                Last post
              0
              • Categories
              • Recent
              • Tags
              • Popular
              • World
              • Users
              • Groups