Solved

Inventor 2010 New Server Installation.

Posted on 2010-11-09
5
525 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

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Suggested Solutions

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

757 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

22 Experts available now in Live!

Get 1:1 Help Now