topic Re: How to import a file geodatabase to SQL Server using a Python Script? in ArcGIS Enterprise Questions

How to import a file geodatabase to SQL Server using a Python Script?

deleted-user-qRkMX6AKcIjf — Sun, 23 Jul 2017 15:15:56 GMT

How to import a file geodatabase to SQL Server using a Python Script? Are there any limitations? Which modules can I use to create a python script? Is pyodbc module the most appropriate one? Anyone has already any examples to show? thks, M.

Re: How to import a file geodatabase to SQL Server using a Python Script?

JoeFlannery — Sun, 23 Jul 2017 15:30:47 GMT

Manuela:

Have you considered arcpy and the Feature Class to Feature Class command?

Here is a code sample:

http://pro.arcgis.com/en/pro-app/tool-reference/conversion/feature-class-to-feature-class.htm#C_GUID-0D434010-EED4-4937-B4F6-24BD39AA9A42

Re: How to import a file geodatabase to SQL Server using a Python Script?

deleted-user-qRkMX6AKcIjf — Sun, 23 Jul 2017 15:49:44 GMT

I did Joe. But I am looking to import the full file geodatabase in one go rather than exporting each feature class..

Re: How to import a file geodatabase to SQL Server using a Python Script?

XanderBakker — Sun, 23 Jul 2017 15:58:27 GMT

There are some options mentioned here (although it is the other way around it will work for your case too): Copy a list of feature classes from Enterprise to Geodatabase

Re: How to import a file geodatabase to SQL Server using a Python Script?

shan_sarkar — Sun, 23 Jul 2017 16:06:16 GMT

Manuela,

You can simply use the same code mentioned in the help for Feature Class To Geodatabase—Help | ArcGIS Desktop. This should easily create all you feature classes in your target database with the same names. In case you have some non-spatial tables that also need to be moved in your target database you can use Table To Geodatabase—Help | ArcGIS Desktop

Just keep in mind that you will have to add the an environment setting for the if you are using any. Refer What are configuration keywords?—ArcGIS Help | ArcGIS Desktop

I hope this helps!

~Shan

Re: How to import a file geodatabase to SQL Server using a Python Script?

RebeccaStrauch__GISP — Sun, 23 Jul 2017 22:31:08 GMT

If this is a one time deal, and you don't need it to be a Python script, you can do a copy-paste (using OS commands like control-c, control-v) into a Sde geodatabase. The geodatabase would have to exist first, and you my want to copy datasets one at a time, not that it will not work all at once, but you have a bit more control knowing what has completed.

if for a class or will be repeated, I agree that feature classe to featureclass as mentioned above would be you best option.

Re: How to import a file geodatabase to SQL Server using a Python Script?

deleted-user-qRkMX6AKcIjf — Mon, 24 Jul 2017 08:55:20 GMT

HI Rebecca, it is not a one time deal. It should be automated a recorrer every month.

Re: How to import a file geodatabase to SQL Server using a Python Script?

shan_sarkar — Mon, 24 Jul 2017 10:47:20 GMT

Manuela,

The sample script that is provided in Feature Class To Geodatabase—Help | ArcGIS Desktop and Table To Geodatabase—Help | ArcGIS Desktop

along with the CONFIG_KEYWORD can be invoked on demand using Task Scheduler which can be set to execute on a desired date in the month.

Refer Scheduling a Python script to run at prescribed times—Help | ArcGIS Desktop

I hope this helps!

~Shan

Re: How to import a file geodatabase to SQL Server using a Python Script?

1812rishabhp — Fri, 30 Aug 2024 02:55:03 GMT

Hey Shan, how can I add/ update config keyword while copying the fgdb to sql server? I can do it in GUI where it allows me the option to change it from DEFAULT to GEOMETRY. How can I do it using Arcpy?