1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Importing to MS SQL

Discussion in 'Plesk for Windows - 8.x and Older' started by crucialx, Aug 15, 2007.

  1. crucialx

    crucialx Guest

    0
     
    I'm fairly new to Windows, and MS SQL. We have a client who has been working on their local computer and wants to upload the database they have been working on (MS SQL 2005 Standard) to our server. We are running the free version of MS SQL.

    The client has made a create script, which references mdf files. He has uploaded these files via FTP, and changed the create script to reference these files.

    In myLittleAdmin I use the query analyzer but get a number of errors.

    What is the best way to get the client to upload their database to our service? Am I doing it the correct way?
     
  2. OZyryanov

    OZyryanov Guest

    0
     
  3. crucialx

    crucialx Guest

    0
     
    How can this be used to just transfer a database (no control panel) from another computer/server?
     
  4. OZyryanov

    OZyryanov Guest

    0
     
    Hello!

    This utility (PMM) could be used to transfer databases from external database server to database server at Plesk for Windows only.

    Thanks.
     
  5. crucialx

    crucialx Guest

    0
     
    How can this be done, I have installed Plesk Migration Manager on our server. What steps do we take next to transfer the database over.

    Thanks for your help so far!
     
  6. OZyryanov

    OZyryanov Guest

    0
     
    Please, read Plesk Migration Manager documentation. http://download1.swsoft.com/Plesk/Plesk8.2/Doc/plesk-win-pmm-guide/index.htm

    In short, you should install Plesk Migration Manager in Plesk and Plesk Migration agent at source host (you should have administrative access to source host). Then goto Plesk - Server - > Migration Manager and start migration. Enter host address where Migration Agent works. After succesefull connection you could select Database Migration and starts migration of databases.

    Please note, that PMM will not migrate MSSQL database users to Plesk. To solve this problem read this troublesshouting http://download1.swsoft.com/Plesk/Plesk8.2/Doc/plesk-win-pmm-guide/32698.htm.

    Thanks.
     
  7. crucialx

    crucialx Guest

    0
     
    Thanks for that, I'll see if it works.
     
  8. crucialx

    crucialx Guest

    0
     
    Which ports need to be used in the transfer? We need to know so we can open the ports and do port forwarding on the computer with the Migration Agent.
     
  9. OZyryanov

    OZyryanov Guest

    0
     
  10. crucialx

    crucialx Guest

    0
     
    Its not clear if we need to open all these ports or just the one for PMM. Do we need to open all these ports?

    The reason I ask is the server is behind a NATed network, and we have port forward each port.
     
  11. OZyryanov

    OZyryanov Guest

    0
     
    yes, you need "SAMBA" and "PMM" port for "windows" migration.
     
Loading...