HomeForum
Welcome, Guest

Change database (Repository)
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: Change database (Repository)

Change database (Repository) 2 years, 1 month ago #768

  • acury
  • OFFLINE
  • Junior Boarder
  • Posts: 20
  • Karma: 0
hi ! me again...

I have a repository in Access, i need transfer the repository to MySql repository, i try this steps:

1) Connect to MySql database (OK)
2) Run the package \"My Sql\" (OK, no errors)
3) Run Backup repository (from the tools menu) (OK)
4) Change the repository to the MySql (from the step 1-2) (OK)
5) Restore Backup (from the tools menu), the sistem dont show any error, but, i´m try open many projects (transformation, package, etc) but the sistem show me errors, or show me blank page, etc....

How the best process to change (and import) the repository to another server ?

Tanks !!

Re:Change database (Repository) 2 years, 1 month ago #770

  • admin
  • OFFLINE
  • Moderator
  • Posts: 1934
  • Karma: 11
Hello

You are probably running old scripts.
You need scripts from the latest repository.

Peter

Re:Change database (Repository) 2 years ago #773

  • acury
  • OFFLINE
  • Junior Boarder
  • Posts: 20
  • Karma: 0
Hi !

Realy have a problem, i´m try...

1) download a new version for ETL
2) Install
3) Open de default repository
4) Connect to localhost MySql base (empty)
5) Execute package to create a repository in Mysql
6) Execute a Backup (for access repository)
7) Change de default repository to MySql
8) Reconnect (at here, no problem)
9) Open in mysql repository (empty)
10) Restore backup (from the step 6)
11) No error show, but, all package in blank !

I´m record movie from this steps:



Tanks

Re:Change database (Repository) 2 years ago #774

  • admin
  • OFFLINE
  • Moderator
  • Posts: 1934
  • Karma: 11
Cary

Just done exactly the same and it worked fine for me

I used MySQL Driver version 5.1 for connection

I may do a video for you as well if you wish.

Mike
  • Page:
  • 1
Time to create page: 0.16 seconds

Testimonials

I am continually Amazed by the power and versatility of the ETL tool and the Support Team.

Thank You!

http://www.dbsoftlab.com/advanced-etl-processor/2475-de-duplication-of-addresses.html

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top