Ingres Database Migrate into SQL Server 2008

Question

Post reply

Ingres Database Migrate into SQL Server 2008

SQL Galaxy

One Orange Chip

Points: 29472
More actions
July 20, 2011 at 11:35 pm

#390023

Hi,
I have a clinet that is looking to convert an Ingres Database into SQL Server 2008. WE can easily convert the tables but there are a large number of views and procedures that are complex.
Does anyone know of a method or tool that can convert these tables,data, procedures etc without a manual process of doing so.
Thanks
ananda

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

Ryan007 SSCrazy Eights Points: 8275 More actions · Answer 1

Use SQL server migrant assistant to deal with that.

Ryan
//All our dreams can come true, if we have the courage to pursue them//

SQL Galaxy One Orange Chip Points: 29472 More actions · Answer 2

Sumanta Roy (7/21/2011)
Use SQL server migrant assistant to deal with that.

Thanks for reply....

As per Microsoft SQL Server Migration Assistant (SSMA) makes it easy to migrate data from Oracle, Microsoft Access, MySQL, and Sybase to SQL Server.

Not in INGRES database, Please clarify.

Thanks

ananda

Lowell SSC Guru Points: 323518 More actions · Answer 3

Procedures and functions(and triggers, if they exist) will have to be hand edited; there is no process that i've ever heard of that can convert procs and functions form Ingress to SQL syntax and still keep the correct logic; same thing occurs with Oracle to SQL;

the table definitions and the data can be scripted and transfferred, that's the case with everything that has an ODBC driver.

but procs and functions , no. that'll be developer time for someone who knows SQL and also can follow the Ingress proc logic.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

SQL Galaxy One Orange Chip Points: 29472 More actions · Answer 4

Thanks for reply......

Please tell me, how to transfer table and data to SQL 2008 from INgres database.?

Does SQL 2008 DTS can able import table and data?

Thanks

ananda

Lowell SSC Guru Points: 323518 More actions · Answer 5

ananda.murugesan (7/21/2011)
Thanks for reply......
Please tell me, how to transfer table and data to SQL 2008 from INgres database.?
Does SQL 2008 DTS can able import table and data?
Thanks
ananda

yes exactly. DTS (well actually SSIS's Import Wizard, which can be called straight from SSMS) has the ability to get the table definitions..

ODBC drivers are all about a standard way to get data.

you remember in TSQL, the information_Schemas.*? every ODBC driver has access to the equivilent views for whatever data system it is connecting to ...so using that meta data, a driver can find every table, every column and it's data type, and construct a equivilent table, so at least a basic table and it's data can be copied to any other system.

I don't know if Ingress supports an identity() property, or if it has to use triggers to emulate that functionality the way Oracle does, you'll have to find that part out.

this link from ingress has step by step screenshots:

http://community.ingres.com/wiki/ODBC_on_64_-_Bit_Windows

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

SQL Galaxy One Orange Chip Points: 29472 More actions · Answer 6

Mr.Lowell,

thanks for reply..

In SQL server 2008 server machine Not available Ingress ODBC driver 3.0 or 9.2 etc.. I think Ingress odbc driver required in Ingress machine only. Not in SQL server 2008 machine.

If required Ingress odbc driver in sql manchine, please tell me how install in SQL machine?

Thanks

ananda

Lowell SSC Guru Points: 323518 More actions · Answer 7

ananda.murugesan (7/21/2011)
Mr.Lowell,
thanks for reply..
In SQL server 2008 server machine Not available Ingress ODBC driver 3.0 or 9.2 etc.. I think Ingress odbc driver required in Ingress machine only. Not in SQL server 2008 machine.
If required Ingress odbc driver in sql manchine, please tell me how install in SQL machine?
Thanks
ananda

Well the import wizard is going to look for the ODBC driver on the machine that is executing. you will have to download and isntall the "right" ingress ODBC driver on the machine that is going to use it.

for example, say your machine is DEV1, and you've got a server INGRESS and another server SQL2008.

if you are going to open SSMS on DEV1 to run the import wizard, the ODBC driver needs to be installed on DEV1.

if you are going to call SSMS on the SQL2008 server itself, it needs to be isntalled there.

you'll have to download and install the ingress ODBC driver on the right machine

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 8

I believe that you need to install the Ingres Client on the SQL Server Machine.

Instructions on how to do this:

http://community.ingres.com/wiki/InstallIngresClient

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Ignacio A. Salom Rangel SSC-Insane Points: 20443 More actions · Answer 9

Ignacio A. Salom Rangel

SSC-Insane

Points: 20443

July 25, 2011 at 5:19 am

#1357689

Ananda, Did you manage to install the driver?

My blog

SQL Galaxy One Orange Chip Points: 29472 More actions · Answer 10

No sir, still i am waiting for approval from Application & Business Owner,

Please tell me, Is there any issue for Install Ingress ODBC Driver on SQLSERVER 2008 machine?

Thanks

ananda

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 11

ananda.murugesan (7/25/2011)
No sir, still i am waiting for approval from Application & Business Owner,
Please tell me, Is there any issue for Install Ingress ODBC Driver on SQLSERVER 2008 machine?
Thanks
ananda

You should install it on a Dev/QA machine first and test.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Ignacio A. Salom Rangel SSC-Insane Points: 20443 More actions · Answer 12

Welsh Corgi (7/25/2011)
ananda.murugesan (7/25/2011)
No sir, still i am waiting for approval from Application & Business Owner,
Please tell me, Is there any issue for Install Ingress ODBC Driver on SQLSERVER 2008 machine?
Thanks
ananda
You should install it on a Dev/QA machine first and test.

I have not installed the drivers for Ingress on a SQL Server before, I have done it with Iseries drivers, Welsh Corgi's advice is very good. Before doing something in production servers is it always good to test it on a test Server. If you don't have a test Server create a virtual Server, but make sure you always test things in test Servers first. Good luck!

My blog