Solved

Inventor 2010 New Server Installation.

Posted on 2010-11-09
5
535 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

738 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