The "Migrate Database" feature allows you to specify or create a remote server and import all of its tables into the current database.

It seems to do this by creating the necessary proxy tables and selecting the data from each into local tables with the same name.

In our migration scenarios we frequently find that we have tables of the same name in both the local and remote databases. In our scenarios we want to keep our own structure's naming standard, so the remote table would be the one to rename on import. When adding a proxy table manually, you have the option to rename it, but this option is not available using the migration wizard.

What would help a great deal is an option to add a prefix or suffix to each imported table name. For instance I could prepend each imported table with S_ so that they all are labelled as source tables for further manipulation of the data into our structure.

When I don't have duplicate table names it works great, so thanks for a great tool.

asked 27 Feb '13, 19:23

Siger%20Matt's gravatar image

Siger Matt
3.2k496697
accept rate: 13%

edited 15 Mar '13, 19:10

Mark%20Culp's gravatar image

Mark Culp
23.0k9130270

For reference, this issue was raied by Siger in a comment to this question: http://sqlanywhere-forum.sap.com/questions/15739/ms-access-connection-string

(27 Feb '13, 21:11) Mark Culp

Your enhancement request is a very valid one and will certainly be considered for a future release. In the meantime, you could consider creating a new user or group to own all the migrated tables and then specify that user as the table owner in the migration wizard. Then it should not matter whether a table with the same name already exists because the table owner of the migrated tables will be the new user or group. I realize having a different owner for the migrated tables might be a pain, but it would get you beyond the current issue.

permanent link

answered 04 Mar '13, 10:57

Karim%20Khamis's gravatar image

Karim Khamis
5.6k53870
accept rate: 40%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×107
×102
×45

question asked: 27 Feb '13, 19:23

question was seen: 811 times

last updated: 15 Mar '13, 19:10