Thanks for the reply,
Did try to manually update but when I went from the last 904 to the first 905 schema changed it threw a lot of errors.
Have just found out what my issue was / is. Under Win Server 2k8 R2 you need to run the change schema in admin mode. you also need to install vantage to a location that does not contain spaces or you will get an error with the schema tool saying it cannot find the conversion log files.
Have u managed to upgrade from 8.0.40x to 9.05.xxx ?
Did try to manually update but when I went from the last 904 to the first 905 schema changed it threw a lot of errors.
Have just found out what my issue was / is. Under Win Server 2k8 R2 you need to run the change schema in admin mode. you also need to install vantage to a location that does not contain spaces or you will get an error with the schema tool saying it cannot find the conversion log files.
Have u managed to upgrade from 8.0.40x to 9.05.xxx ?
--- In vantage@yahoogroups.com, "Ned" <TechnoBabbly@...> wrote:
>
> I would tell you to try skip using the schema change tool.
>
> First, make a backup of the DB and then go to the folder:
>
> Epicor905\ClientServer\db\SQL
>
> That is the folder that has all the SQL scripts the schema change tool is
> going to call.
>
> Check your vntver table in SQL, view the columns and you will see what the
> schema of the DB currently is based on the last column in the table,
> something like v_803400, then go to the folder mentioned above, and run the
> .SQL file that is next in the sequence manually in the SQL Management
> Studio. Then continue til you have all the scripts run up to the most recent
> one, which should be 905-600DF.sql.
>
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> markbetts66
> Sent: Tuesday, May 03, 2011 4:12 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Help: Need Epicor 9.04/5 ossql.bat file
>
> Morning,
>
> Im going thorough the process of upgrading our Vantage 8 SQL to Epicor 9 SQL
> on Win Server 2k8 R2. Ive got all the way to getting the schema change
> process started and its bombed out complaining that it cannot find
> "c:\program files (x86)\epicor software\epicor905\db\sql\ossql.bat" file.
>
> Can someone with Epicor 904/5 send me the file? ive reinstalled the program
> multiple times and its never installed :(
>
> Thanks,
> Mark
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>