| Author |
Topic |
|
jhermiz
3564 Posts |
 Posted - 2007-02-12 : 17:00:38
|
We are in the midst of migrating domains and I have a small dilema. Most of our end users (Although we've stated in the past that their is no support for any application not approved by IT) have little excel / access / project / word applications off on our network. Most of these apps have macros / code written in them to accomplish a task (Talk about source control :)). Anyhow the issue is some of these macros have hardcoded paths / urls to obtain / link to / or work with another file on our network. For instance, one excel file might call another excel file that is on our network to perform some specific task.
What is the best way to migrate domains and these applications still work correctly...is it just going into each one and changing the hard coded path ?
Errrrrrrrrrrrrr....................
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]
RS Blog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-02-12 : 17:08:28
|
If the servernames, share names, and permissions do not change, what will be the problem?
CODO ERGO SUM |
 |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2007-02-12 : 17:49:04
|
"one excel file might call another excel file"
Microsoft Best Practice?
Cause I don't know...
I'm just another motherfucker
With the money to spend
Viva Las Vegas
rockmoose |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2007-02-12 : 23:29:33
|
Just do it and see what breaks. Maybe put out a guide explaining what the new paths would be.
Presumably if they are able to write the macro the first time, they can change it later. You can offer support to help them fix it, but you will go crazy trying to figure out every possible problem before your migration.
Damian
"A foolish consistency is the hobgoblin of little minds." - Emerson |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-02-12 : 23:46:40
|
when you say hardcoded paths, do you mean UNC paths? why would that change when you migrate domains?
Give us some specific examples of what you think is going to break.
-ec |
|
|
|
jhermiz
3564 Posts |
Posted - 2007-02-13 : 08:20:18
|
quote:
Originally posted by eyechart
when you say hardcoded paths, do you mean UNC paths? why would that change when you migrate domains?
Give us some specific examples of what you think is going to break.
-ec
Im talking about the entire file system. What might of been J:\business\apps\...
may become M:\ah\business\apps. We are moving to DFS.
I think Ill take merkin's suggestion and just let it all break :).
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]
RS Blog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
|
|
|
jhermiz
3564 Posts |
Posted - 2007-02-13 : 08:26:32
|
quote:
Originally posted by Michael Valentine Jones
If the servernames, share names, and permissions do not change, what will be the problem?
CODO ERGO SUM
That's the problem it does change.
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]
RS Blog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-02-13 : 11:51:23
|
quote:
Originally posted by jhermiz
quote:
Originally posted by Michael Valentine Jones
If the servernames, share names, and permissions do not change, what will be the problem?
CODO ERGO SUM
That's the problem it does change.
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]
RS Blog -- [url]http://weblogs.sqlteam.com/jhermiz[/url]
It sounds like you are doing more than just changing domains. Are you renaming your servers or shares?
CODO ERGO SUM |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
|
|
|
Domain Migration