Book a Demo

Author Topic: Copy a project from SQL-Server to local hd ...  (Read 3056 times)

heiko

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Copy a project from SQL-Server to local hd ...
« on: January 10, 2005, 10:49:02 pm »
how can I copy/export a project on a sql-server to local harddisk, modify, and put it back to sql server?

I have a project on our sql server and I want to put it local on my laptop, modify it at home and put it back to our sql-server at office.

How can I do this?

TIA
Heiko

Bruno.Cossi

  • EA User
  • **
  • Posts: 803
  • Karma: +0/-0
    • View Profile
Re: Copy a project from SQL-Server to local hd ...
« Reply #1 on: January 10, 2005, 11:08:25 pm »
Hi,

if you are the only one making changes to the project, have a look at menu Tools > Data Management > Data Transfer. This will allow you to transfer the data from your SQL Server to an .EAP file and later on back from .EAP to SQL Server. (Please note, the .EAP file has to already exist, so you may have to create a new .EAP file prior to doing the data transfer).
This functionality however copies the WHOLE project, so if anyone makes changes to the SQL Server-based project while you work on your laptop, their changes will be overwritten once you transfer the project from your laptop back to the SQL Server. If there are multiple people working on the project, you may want to simply export the package(s) that you want to work on (right-click on the package and click on Import/Export), import it into a new project on your laptop, and then move the changes back to SQL Server once you are done.

Hope this helps!

Bruno

heiko

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Re: Copy a project from SQL-Server to local hd ...
« Reply #2 on: January 10, 2005, 11:11:33 pm »
thx for the quick answer. I'll have a try.