Solved

Inventor 2010 New Server Installation.

Posted on 2010-11-09
5
529 Views
Last Modified: 2012-05-10
I need to move Inventor 2010 from Autodesk to a new server, the new version of the software needs sql 2005 or 2008 and the server it is sitting on now is SQL 2000. I cannot upgrade the version of SQL on the old server because another app is using it and is not compatible with 2005 or 2008.

I have SQL installed, and now ready to install the software. I do not know much about inventor, but can I install a fresh copy of the program, let it create all the sql stuff and attached the database files from the old server? I am not too sure if that would work.
0
Comment
Question by:TJacoberger1
  • 4
5 Comments
 
LVL 7

Expert Comment

by:Cboudroz
ID: 34095598
You need to ask to the inventor support service what the best way to migrate their application from 2000 to 2008.

but I see two option:

1 - backup the SQL 2000 database and restore on 2008 if its supported by the new application maybe they have a upgrade database option in the install?
2 - make a fresh install on 2008 and found a way to Export data from old system and import it in the new system.


each software have is own particularity.


0
 

Author Comment

by:TJacoberger1
ID: 34095687
They want me to figure it out, and not for the support. It is expensive. So I am trying to get some input on what I can do. Thank you for the options, I did not think about the backup file I have.
0
 
LVL 7

Accepted Solution

by:
Cboudroz earned 500 total points
ID: 34095775
and try to see if they have export/import option in the software.
0
 
LVL 7

Expert Comment

by:Cboudroz
ID: 34095927
He was trying to Sum all 'Quantities' for Sku 'GTS-JP' that have CUSTNMBR = JP001, JP002 and JP003 from the ShipHistory table. In other words, this could be rewritten as:
no

He was trying to retrieve a dataset  whit one row by sku whit the sum of Quantities if condition match.
So maybe the table have 1000 of row in table, 3 distinct sku, but only 43 row whit JP001 or JP002 or JP003.  You will receive something like this (if quantity always = 1)

sku      total
sku1     10
sku2      33
sku3     0     <----------------

Your code will only return:
total:
43


the following code will almost do the same thing, but in his case if some sku didn't had custnmbr in ('JP001','JP002','JP003') the row would show up whit 0 has quantity (sku3 in my exemple)

SELECT
   sku
   , SUM(quantity) as 'Total'
FROM ShipHistory360      
WHERE locncode = 'JPNPLNT'
And Sku = 'GTS-JP'
And CUSTNMBR IN ('JP001','JP002','JP003')
GROUP BY sku


whit the condition in the where clause you will not have row whit 0 has quantity.

but its kind of stupid that he didn't show the sku in the select column list?

select
 sku
 , case ...


so he was receiving

total
10
33
0
0
 
LVL 7

Expert Comment

by:Cboudroz
ID: 34095951
can  you delete last post... wrong windows...

sorry

0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

943 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now