Lost Password?
No account yet? Register
Increase font size Default font size Decrease font size Narrow screen resolution Wide screen resolution Auto adjust screen size default color red color blue color yellow color orange color
Support Forum
Welcome, Guest
Please Login or Register.    Lost Password?
Re:Change database (Repository) (1 viewing) (1) Guests
Go to bottom Post Reply Favoured: 0
TOPIC: Re:Change database (Repository)
#768
acury (User)
Fresh Boarder
Posts: 13
graphgraph
User Offline Click here to see the profile of this user
Change database (Repository) 2 Months, 1 Week ago 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 data_base_ (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 !!
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#770
admin (Admin)
Admin
Posts: 147
graph
User Online Now Click here to see the profile of this user
Re:Change database (Repository) 2 Months ago Karma: 0  
Hello

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

Peter
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#773
acury (User)
Fresh Boarder
Posts: 13
graphgraph
User Offline Click here to see the profile of this user
Re:Change database (Repository) 2 Months ago 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:

http://www.youtube.com/watch?v=JX9c5TXsrJs

Tanks
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#774
admin (Admin)
Admin
Posts: 147
graph
User Online Now Click here to see the profile of this user
Re:Change database (Repository) 1 Month, 4 Weeks ago Karma: 0  
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
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply
Powered by FireBoard

Testimonials

"I needed to integrate and automate disparate systems running different database platforms that speak different languages, even different flavors of SQL. Visual Importer products have become that common link for me."

Gene Kovacs,
Director of Technical Business Operations,
A2B

 

Free Newsletter

Please provide your Name and Email address so that we can tell you about latest releases, new features and free offers.






b.150.100.16777215.0..Screenshots.VimpEnt.vimentbig3.jpg
DB Software Laboratory - Intel Software PartnerDB Software Laboratory - My SQL Ready Partner
DB Software Laboratory Embacadero Technology Partner