FMDesktop (Read Only)
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Facility Manager - SQL

3 REPLIES 3
Reply
Message 1 of 4
Jennifer.Eckert
429 Views, 3 Replies

Facility Manager - SQL

I have recently installed Facility Manager - SQL on my laptop. Can I access my database I created originally with Facility Manager - ACCESS with this?
3 REPLIES 3
Message 2 of 4
Anonymous
in reply to: Jennifer.Eckert

No each back end database maintains it's own data. The data in the access database would need to be ported over to MS-SQL. Be advised that this process needs to follow the database schema rules. For example Properties, Buildings, Floors, must be imported before spaces can be linked. Also remember each database maintains its own tracking information, so you will need to make sure the records import correctly.

Stephen Komisarek
FM Solutions Consultant
Building Solutions Division
www.autodesk.com
www.fmdesktop.com
Message 3 of 4
Anonymous
in reply to: Jennifer.Eckert

Can't the Access SQL Update Wizard be used in this context?

<%= Clinton Gallagher
NET csgallagher AT metromilwaukee.com
URL http://clintongallagher.metromilwaukee.com/
MAP 43°2'17"N 88°2'37"W : 43°2'17"N 88°2'37"W

wrote in message news:5353941@discussion.autodesk.com...
No each back end database maintains it's own data. The data in the access
database would need to be ported over to MS-SQL. Be advised that this
process needs to follow the database schema rules. For example Properties,
Buildings, Floors, must be imported before spaces can be linked. Also
remember each database maintains its own tracking information, so you will
need to make sure the records import correctly.

Stephen Komisarek
FM Solutions Consultant
Building Solutions Division
www.autodesk.com
www.fmdesktop.com
Message 4 of 4

Steve,
How best can I contact you about a business proposal?

I was in the FM Desktop training you did in Southfield, MI last week.
Thanks,
Bill Orlowski
william.orlowski@arvinmeritor.com

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report