Transfer of spatial data from access to sql server 2005

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Data Transformation Services (DTS) » Transfer of spatial data from access to sql...

Transfer of spatial data from access to sql server 2005

Rate Topic

Display Mode

Topic Options

Author

Message

sam_invincible1

Posted Friday, February 22, 2008 1:30 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 28, 2008 9:04 AM
Points: 6, Visits: 34

i have to migrate geomedia professional's spatial data from access to sql server 2005 , is it possible through DTS ? and what precautions should i take before migrating , will it be a successful transfer ? could anyone plz tell me the important things that are needed in that migration of spatial data to sql server 2005

Thank you

Post #458952

Ian Yates

Posted Friday, February 22, 2008 2:02 AM

Ten Centuries

Group: General Forum Members
Last Login: Sunday, September 16, 2012 3:26 AM
Points: 1,038, Visits: 443

I've never worked with that product. Could you post some of the table structure? Can your client application work with MS SQL Server instead of MS Access?

I'd suggest that for an MS Access database you try the upsizing wizard.

Post #458961

asr777

Posted Tuesday, April 27, 2010 10:29 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, January 11, 2013 12:58 PM
Points: 1, Visits: 13

look up SAFE FME and read up on the instructions on importing db mapping.

http://www.safe.com/solutions/BIS/documents/microsoft/FMEExtensionforSSISTutorial.pdf Cool

Post #911617

« Prev Topic | Next Topic »

Permissions