Skip to main content
Question

Creating Multiple Database Tables in SQL Server

  • August 27, 2019
  • 3 replies
  • 125 views
F
Forum|alt.badge.img

Hi all,

 

I am currently attempting to load in 1000 data sets I have in 1000 different tables. I need to do this in Microsoft SQL Server.

My data sources are either in Excel or Geodatabases. The plan is to download all the data sources and put them into one location. Once I have done this, I would directly like to set up some workbenches to load the data directly.

My question is what would be the most efficient way to create the SQL server tables with the Geometry using FME. Then in the future, these tables will need to be continuously updated with the data. As there are so many columns with each data set, is there a quick and easy way to create the 1000 tables without much manual input.

At the moment, I have tried creating the tables individually by writing up SQL Script but is taking a lot of time to create. Any past examples I can base this on or transformers that can speed this would be great.

 

Thank You

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

redgeographics
Celebrity
Forum|alt.badge.img+62

You can try a dynamic workflow, where FME will attempt to create tables using the structure of the input data. This might not be ideal though in cases where the input data schema does thingsthat are not supported in SQL Server

FME rocks! \m/
F
Forum|alt.badge.img
  • fazsnatch
  • Author
  • August 27, 2019

Thanks for the reply. Would you happen to have any examples or workflows that might help with this?

jovitaatsafe
Safer
Forum|alt.badge.img+11

Thanks for the reply. Would you happen to have any examples or workflows that might help with this?

Hi @fazsnatch,

Have you taken a look at these tutorials by chance?

Community Stats

32,207
Posts
122,303
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.