Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Question re: Copy/Import Database Schema

Baylah
in Developer Tools

Featured Replies

While I was looking for something else I stumbled across a feature I did not know existed and I want to verify that I am reading this right. If I am...I will be so happy.

In the Copy DataBase Schema in FMP 8 Advanced it says that I can copy/import an entire table into a new database. OK, that seems pretty straight forward...Does that mean that I can take a DB that was developed in FM6 that was 9 individual tables and turn it into 1 file?

If the answer is "yes" that is a big hooray...But would the scripts that call and move across/through (what were) external tables still work if everything is now inside one "master" file?

Furthermore, and what prompted all of this....This client is taking their securities and priviledges to a different level. Because of that, and since this was created in FMP 6 I have to mirror all of the priviledges across all of the different DB's. If I can combine all of the DB's into 1 file will one set of securites then control all?

Additionally, will I then have to import record information into the new file one table at a time?

I know I should probably know these things but I am self taught and have never had a guru to mentor me. when I think of all of time I could have saved if I did it is is staggering.

Anyway...any help or advice is appreciated.

Steve

Create an account or sign in to comment

https://fmforums.com/topic/49531-question-re-copyimport-database-schema/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.