Solved! Go to Solution.
Hello all,
My knowledge of ArcSDE and SQL server is limited so I apologize if this question seems silly.
I need to get a copy of an ArcSDE SQL server (2000) geodatabase from someone but they don't have ArcGIS intalled to connect to it (I could do a connect in ArcCat if they did and then just export to an mdb). So can they export the database using (within) SQL server 2000? How do they do that? Once I have that copy how can I use it within ArcGIS? Can I just put it on my server and connect to it in ArcCat? They can export shapefiles but I need the network and relationship tables from the geodatabase. I don't think it's that easy but wondering if this is possible.
I appreciate any help and knowledge!
Thanks,
Ah good idea.
I don't have SQL server but I see on Microsoft's website they have "Microsoft SQL Server 2008 R2 RTM - Express with Management Tools". If I download this, do you have any idea how to install it so I can restore to this database? Or I guess I could look for a 2000 version since that's the data that I'm getting.
Thank you,
Hi,
This isn't going to be in the ArcGIS documentation - most of the stuff you're talking about is strictly SQL Server, and you need to follow their instructions/recommendations for moving and upgrading databases.
You wouldn't be able to install SQL Server Express and restore the SQL Server 2000 database unless the 2000 database was Personal Edition and you were restoring it to SQL Server 2005 Express. See Microsoft's supported upgrade paths:
2005: http://msdn.microsoft.com/en-us/library/ms143393%28v=sql.90%29.aspx
2008: http://msdn.microsoft.com/en-us/library/ms143393%28v=SQL.100%29.aspx
There is no SQL Server Express at the 2000 release.
You mentioned that you need to preserve networks and relationship classes...there're no versions in there that need to be preserved, right? If so, could the person providing the data export it to a file geodatabase, zip that up, and send it to you?
-Kim
You can only do a query layer to a SQL-Server database if the table uses GEOMETRY or
GEOGRAPHY storage.
It'd be far easier to get the client to dump the ArcSDE contents as file geodatabase, shapefile,
or ASCII, then import it again than to access an SDEBINARY storage ArcSDE database without
ArcSDE.
- V