Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Inventor 2010 New Server Installation.

Posted on 2010-11-09
5
Medium Priority
?
549 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 2000 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

In this article, we will see the basic design consideration while designing a Multi-tenant web application in a simple manner. Though, many frameworks are available in the market to develop a multi - tenant application, but do they provide data, cod…
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

661 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