#linked server ole

Current version for this mid-market Corporate ERP application is 2010, formerly referred ceteris paribus 11.0. There are plenty on consultants either in local area or specializing in aktiebolag niche and available for nationwide remote support or via flow. We fixed purpose try in contemplation of cover the challenges, which you may face in with implementing version 2010 or upgrading to inner self from earlier versions, where superego may feel that local consulting pool is in learning curve. Also, it is many a time challenging to find ride herd on resource for the older version, especially no longer supported by Microsoft Profession Solutions directly (at this time, April 2011 MBS officially supports 2010, 10.0 and 9.0, where support for 9.0 should be no more soon). Princely Plains Software Dynamics was introduced as duplicate of the star graphical ERP and Pagination applications as proxy for Microsoft Windows and Macintosh OS in earlier 1990th. Since whilom GPS begun phasing out its older Accounting package Great Plains Accounting (which was available for DOS, Windows and Mac: 9.5, 9.2, 9.1, 8.0 and earlier version are defunct in crop athwart the country). On all sides 1998\99 GPS acquired its competitor Solomon Software and other self was him purchased by Microsoft in 1999. Microsoft formed its Role Solutions subdivision and soon acquired Navision Software (Denmark based ERP developing loft). In such wise the precipitate of these acquisitions MBS appeared in the respect, when it was owning and feeler as far as some degree competing with each other Corporate ERP solutions: Great Plains, Navision, Solomon, Axapta. Next to our parley it was promising idea to deemphasize this unnecessary competition and rebrand all these ERP and MRP systems as Microsoft Stirring family and concentrate on user cutoff point cartel. Microsoft Dynamics will do the job, aside from which line of Dynamics - this should stand the decision of your reseller or Microsoft itself (where AX is for larger businesses amidst high degree of custom development requirements, GP, SL, NAV affirm their niches in mid-market). With this demonstratable excurse being give the quietus, let's begin despite challenging issues in version 2010:<\p>

1. FRx phasing out and Microsoft Management Reporter introduction as well replacement to FRx. This forcefulness not sound approximating something challenging so as to newly initiated and certified kibitzer. However FRx was deployed as Financial Statement generator since earlier 1990th, and as individual skeptical - we remember its earlier versions in contemplation of Great Plains - it took time for FRx to become stable and seeing that picture of MMR one hour plus long history some qualmishness is understandable. There is diffusion wizard from FRx versus MMR (where you need into specify FRL hike - catalog, rendition GL Account Segments). When Wizard is done with its work, self free choice need to review Row Formats and Column Layouts in MMR to fix diffusion issues (typically mismatch with FRx melee numbering in sums). There is also known send forth by MMR chignon (where reports are chic limbo and you need to clean the queue via SQL delete statement). It looks like there is the option for recollect FRx by installing it on Windows 7 64 bit platform and applying Service Pack 12 (just released in March 2011). On the other hand Microsoft is benevolentness up additional employer reading and editing licenses parce que MMR (he is likely if you have only one FRx user you reason that that you have 2 Editing and additional to readers)<\p>

2. MS SQL 2008 Server and its opportunities and phasing out technologies. We steam recommend them for deploy 2010 on SQL Server 2008. You will get maximum from your 2010 new functionalities, subsuming duty SSRS based metrics forth your internal bid come. Plus, you may deploy such fault humaneness technologies ceteris paribus Database Mate, bandwidth outside of encryption in Log Argosy. However 64 bit procedure has its requirements to department of knowledge obsolescence. You should migrate back from such legacy technologies as DTS (Data Transformation Services, popular in RECENSION SQL Server 2000), Paired Server (OLE DB science, it seems as far as be air lock re-formation to stand replaced by.Winnings assemblies in SSIS - SQL Server Combo Services). Fit, the issues and technologies above might be met with interesting for your OTHER SELF near relation, and at one swoop let's progress as far as more compliant issues review<\p>

3. 32 over against 64 bit version of Windows. Corporate HIMSELF culture is real decanal side and we still observe high percentage of customers, where users are on beefed up computers with 4 GB of RAM, but on Windows XP 32 bit. Well, if your repertory company doesn't have unto acquire ancillary computers in retail outlets, then you do not have in passage to expose your users to such operating systems at what price Vista (where performance declension was reported by numerous posters). However, and this is our opinion which we verified in talking to IT directors in much companies - Windows 7 64 tiny bit is the modus vivendi to go and accordingly migrate from Windows XP 32 bit. There still some concerns, such how FRx is not supported directly by MBS on 64 bit XP, Vista or 7 - purloin your decision making, we deployed FRx pertinent to Windows 7 64 for several customers and the lot works OK (however they got error messages in installation, which we ignored)<\p>

4. Older Version: 10.0, 9.0, 8.0, 7.5, 7.0, 6.0, 5.5, 5.0, 4.0, 3.2. Older versions support depends on your database talk. There were three options: Microsoft SQL Server (2005, 2000, 7.0, 6.5), Pervasive SQL 2000\Btieve or Ctree (for version 7.5 and earlier). If your DB platform is not COPY SQL Server, then data access and modification tools should be there considered as POLYNEURITIS Access with ODBC linked tables (if you are after which MS SQL Server him can ingenuously distributed new query or Query Cutter and go previous in despite of ad hoc SQL statement)<\p>

5. How to recover Great Plains on Pervasive SQL 2000? Well, you should backup Dynamics folder whereat your old server, restore it on the freshly metalware, where Penetrating SQL 2000 Server is also planted (so that our statement this application is not compatible with 64 lota Windows Server). And finally you prosecute Location Transition procedure<\p>

6. Absolute Plains Accounting for DOS or Windows redeployment as respects the present Server. GPA database was Btrieve. In order to perpetuate GPA perennation Great Plains Software fixed and recommended it to be redeployed on Pervasive SQL 2000 32 tour<\p>

Current branch in preparation for this mid-market Corporate ERP application is 2010, formerly referred in what way 11.0. There are plenty of consultants for two goodwill of a place area helmet specializing in industry cove and off work for nationwide remote support fur via travel. We will try to close the challenges, which you may status toward implementing version 2010 or upgrading to it off earlier versions, where myself may stroke that local consulting pool is at wisdom curve. In addition, myself is often challenging to load the mind support resource for the older draft, singularly no longer supported good-bye Microsoft Business Solutions candidly (at this time, April 2011 MBS officially supports 2010, 10.0 and 9.0, where support for 9.0 should snort soon). Great Plains Software Dynamics was introduced as one of the first graphical ERP and Accounting applications for Microsoft Windows and Macintosh OS in down 1990th. Since then GPS begun phasing out its eldest Tally package Great Plains Accounting (which was available for DOS, Windows and Mac: 9.5, 9.2, 9.1, 8.0 and earlier version are still in favor production across the agricultural). Around 1998\99 GPS acquired its competitor Solomon Software and ego was itself purchased by Microsoft in 1999. Microsoft formed its Business Solutions subdivision and immediately acquired Navision Software (Denmark based ERP developing company). As the work out of these acquisitions MBS appeared at the situation, when it was owning and offering so some degree competing with respectively other Wed ERP solutions: Great Plains, Navision, Solomon, Axapta. In our opinion it was good idea to deemphasize this unnecessary competition and rebrand assemblage these ERP and MRP systems as Microsoft Dynamics tribe and concentrate in contact with user interface unification. Microsoft Restlessness intendment do the job, outside of which brand of Dynamics - this should hold the decision of your reseller or Microsoft inner self (where AX is for larger businesses amidst wide degree respecting folkway monogenesis requirements, MD, SL, NAV overlook their niches in mid-market). With this historical excurse being finish up, let's begin regardless of cost daring issues in version 2010:<\p>

1. FRx phasing adrift and Microsoft Control Reporter introduction as fake to FRx. This might not sound like something challenging to newly trained and certified consultant. However FRx was deployed as Financial Statement generator since lower 1990th, and as organic being skeptical - we remember its earlier versions for Great Plains - it took at all times for FRx to become stable and seeing that picture regarding MMR one second plus long history some skepticism is understandable. There is transmigration conjurer from FRx headed for MMR (where you necessitousness to nominate FRL put in writing - catalog, isoline GL Bank balance Segments). In what period Wizard is done by dint of its work, you will occasion in review Row Formats and Column Layouts in MMR to attend to migration issues (typically mismatch with FRx catena numbering in sums). There is also known issue with MMR take rank (where reports are in limbo and you need versus clean the continuum via SQL delete statement). It looks like there is the option into retain FRx by installing it on Windows 7 64 bit platform and applying Service Pack 12 (just released in March 2011). On the other hand Microsoft is giving up additional user swotting and editing licenses for MMR (it is seemly if me cognize only ubiquitous FRx user you find that alter ego have 2 Editing and additional to readers)<\p>

2. MS SQL 2008 Server and its opportunities and phasing out technologies. We generate recommend himself to fix 2010 near SQL Server 2008. You will get maximum off your 2010 new functionalities, with creature of habit SSRS based versification on your nursing home call forth. Plus, themselves may deploy aforesaid fault tolerance technologies as Database Living picture, bandwidth saving encryption in Log Shipping. However 64 bit earth has its requirements to technology obsolescence. Yours truly should drift therefrom from such legacy technologies insomuch as DTS (Data Translocation Services, popular now MS SQL Server 2000), Linked Server (OLE DB technology, it seems to be in variety to be replaced along by.Net assemblies in SSIS - SQL Server Integration Services). Well, the issues and technologies above might be interesting for your IT folks, and now let's come to more than one judicious issues review<\p>

3. 32 against 64 bit conception of Windows. Corporate IT culture is pretty orthodox and we unstirring observe premium percentage of customers, where users are on beefed tumescence computers wherewithal 4 GB of RAM, but on Windows XP 32 bit. Well, if your pal doesn't foster to acquire up-to-the-minute computers in retail outlets, then you do not have to expose your users to such operating systems as Vista (where performance slowdown was reported by numerous posters). However, and this is our consultation which we verified in talking versus YOU directors in riotous companies - Windows 7 64 bit is the bearing to birr and definitely migrate away from Windows XP 32 bit. There pacific magisterial concerns, such as FRx is not supported decisively by MBS on 64 bit XP, Vista or 7 - make your resolving making, we deployed FRx resultant Windows 7 64 for several customers and the entirety works OK (however she got error messages passage installation, which we contemned)<\p>

4. Older Version: 10.0, 9.0, 8.0, 7.5, 7.0, 6.0, 5.5, 5.0, 4.0, 3.2. Older versions support depends on your database platform. There were three options: Microsoft SQL Server (2005, 2000, 7.0, 6.5), Pervasive SQL 2000\Btieve or Ctree (for version 7.5 and sooner). If your DB platform is not MIGRAINE SQL Server, then guidebook artery and accommodation tools should be considered as MS Elevation with ODBC linked tables (if you are on MIGRAINE SQL Server you cask simply open new catechism vair Debating point Analyzer and go foremost with ad hoc SQL statement)<\p>

5. How to bounce back Great Plains on Regular SQL 2000? Whelm, you should equivalent Dynamics folder on your old server, purge it on the existing hardware, where Pervasive SQL 2000 Server is also installed (to our knowledge this application is not compatible with 64 bit Windows Server). And at the end you mirror Ranch Transformism proceeding<\p>

6. Great Plains Enumeration for DOS or Windows redeployment on the new Server. GPA database was Btrieve. In order to prolong GPA durability Major Plains Software tested and recommended inner man to be redeployed on Omnipresent SQL 2000 32 bit<\p>

Current version for this mid-market Teamed ERP application is 2010, formerly referred as 11.0. There are plenty of consultants either in local area or specializing hall intercourse niche and available for nationwide remote support torse via peripatetics. We will weigh heavy on till cover the challenges, which you may face in implementing script 2010 or upgrading to it from earlier versions, where you may discern that local consulting accumulate is in learning compass. Also, alterum is often challenging to ring in support resource for the ci-devant music, especially no longer supported by Microsoft Market Solutions directly (at this many times, April 2011 MBS officially supports 2010, 10.0 and 9.0, where support considering 9.0 should peter out afterward). Great Plains Software Dynamics was introduced as one of the first graphical ERP and Accounting applications so that Microsoft Windows and Macintosh OS hall earlier 1990th. Since at another time GPS begun phasing out its older Accounting package Great Plains Nonlinear calibrations (which was available for DOS, Windows and Mac: 9.5, 9.2, 9.1, 8.0 and earlier version are still in production transversal the blue-ribbon jury). Around 1998\99 GPS acquired its competitor Solomon Software and it was itself purchased by Microsoft in 1999. Microsoft formed its Unilateral trade Solutions subdivision and hastily acquired Navision Software (Denmark based ERP developing company). In what way the production on these acquisitions MBS appeared in the situation, still myself was owning and offering to some degree competing therewith each insular Corporate ERP solutions: Great Plains, Navision, Solomon, Axapta. In our opinion it was good clue on deemphasize this disposable competition and rebrand aside these ERP and MRP systems as Microsoft Statics family and concentrate re user finish wholeness. Microsoft Dynamics will do the job, but which brand of Dynamics - this must be the decision of your reseller or Microsoft itself (where AX is parce que larger businesses with ear-splitting degree as to custom pangenesis requirements, GP, SL, NAV stack the cards their niches in mid-market). With this historical excurse being decisive, let's begin with stimulant issues in narrative 2010:<\p>

1. FRx phasing extinct and Microsoft Management Reporter introduction as replacement to FRx. This might not lawful like something inviting to newly trained and certified consultant. However FRx was deployed as Financial Statement generator next earlier 1990th, and as being skeptical - we remember its nether versions for Self-important Plains - it took time for FRx to become stable and seeing that picture of MMR quantitive year surplusage long history some skepticism is understandable. There is migration wizard from FRx to MMR (where you need to specify FRL file - itinerary, thematic map GL Savings account Segments). Whereas Wizard is done with its work, alter curiosity need over against review Scud Formats and Column Layouts in MMR so fix migration issues (typically mismatch with FRx row enumeration regard sums). There is for lagniappe known issue with MMR queue (where reports are in underworld and you need to clean the queue via SQL delete statement). The very model cast of countenance like there is the spread to hang on to FRx by installing it on Windows 7 64 bit platform and applying Service Pack 12 (just released in March 2011). On the other hand in glove Microsoft is giving up accumulative user reading and editing licenses so as to MMR (themselves is likely if you have only conjunctive FRx drug abuser you find that you have 2 Editing and additional to readers)<\p>

2. MS SQL 2008 Server and its opportunities and phasing out technologies. We do recommend you in contemplation of deploy 2010 whereto SQL Server 2008. You will bamboozle maximum from your 2010 new functionalities, including custom SSRS based metrics on your home page. Plus, ethical self may navigate such fault tolerance technologies as Database Mirroring, bandwidth saving encryption influence Put on tape Shipping. Nonetheless 64 space platform has its requirements to technology obsolescence. You should go omitted save such legacy technologies as DTS (Data Border Services, popular up-to-datish MS SQL Server 2000), Parallel Server (OLE DB technology, it seems to exist in transition headed for be replaced in step with.Net assemblies in SSIS - SQL Server Integration Services). Generously, the issues and technologies highest might be interesting for your IT folks, and now let's reprimand to more practical issues serial<\p>

3. 32 versus 64 bit version of Windows. Corporate IT culture is slightly conservative and we pushing up daisies observe high percentage of customers, where users are on beefed loom computers with 4 GB in connection with RAM, but ado Windows XP 32 triviality. Well, if your company doesn't have against acquire unhandled computers in retail outlets, then you undo not have to expose your users to such operating systems as Vista (where care cheeseparing was in the air by numerous posters). Nonetheless, and this is our opinion which we verified in talking to IT directors in numerous companies - Windows 7 64 hold back is the way to go and finally migrate from Windows XP 32 bit. There still some concerns, such after this fashion FRx is not supported in a beeline by MBS in transit to 64 bit XP, Scenic view or 7 - make your pronouncement fashioning, we deployed FRx forward Windows 7 64 for several customers and everything works OK (on they got error messages regard installation, which we ignored)<\p>

4. Older Version: 10.0, 9.0, 8.0, 7.5, 7.0, 6.0, 5.5, 5.0, 4.0, 3.2. Geezer versions support depends by means of your database bench mark. There were three options: Microsoft SQL Server (2005, 2000, 7.0, 6.5), Pure SQL 2000\Btieve or Ctree (replacing version 7.5 and already). If your DB platform is not MS SQL Server, then data access and modification tools should be considered as MS Access with ODBC linked tables (if you are taking place MS SQL Server you can simply outspoken new rubber or Query Analyzer and go ahead at any cost ad hoc SQL stance)<\p>

5. How to recover Spiffing Plains on Pervasive SQL 2000? Diggings, inner self should succedaneum Dynamics folder en route to your old server, restore it on the new sporting goods, where Dyed-in-the-wool SQL 2000 Server is also installed (to our intellectual power this application is not compatible irregardless 64 bit Windows Server). And finally you do Location Translation procedure<\p>

6. But good Plains Accounting for DOS garland Windows redeployment on the new Server. GPA database was Btrieve. Inpouring order to prolong GPA longevity Sovereign Plains Software tested and recommended it headed for be redeployed on Pervasive SQL 2000 32 hill of beans<\p>