Book a Demo
« previous next »
Pages: [1]

Author Topic: Move an SQL Server database  (Read 3996 times)

Greg Bogle

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Move an SQL Server database
« on: October 18, 2014, 04:18:25 am »
I need to move an EA database from SQL Server to another.  Are there any guides to that?  I looked but didn't find anything.  Thanks for any help.
Logged

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Move an SQL Server database
« Reply #1 on: October 18, 2014, 07:29:32 am »
Check Tools/DB Management/Transfer. It's quite obvious. Note that you have to create the schema prior to the transfer. The script is available from somewhere at Sparx' resource page (if you lost the one for the current DB).

q.
Logged

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Move an SQL Server database
« Reply #2 on: October 20, 2014, 06:00:08 pm »
I would simply restore a backup.

Geert
Logged

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Move an SQL Server database
« Reply #3 on: October 20, 2014, 08:25:52 pm »
Quote
I would simply restore a backup.

Geert
Ugh... that was too obvious.

q.
Logged
Pages: [1]
« previous next »