URGENT.. REPLICATE FROM SQL 2005 TO INFORMIX 10
Nov 7, 2005Hi.
View 1 Replies
ADVERTISEMENT
Informix------SQL Server.....URGENT
Feb 21, 2000Hi ,
I am an Informix user who has shifted to SQL Server,,,,I just wanted to know the equivalent of 'ISOLATION TO DIRTY READ' as in Informix in SQL SERVER....
Thanks,
Visitor
INFORMIX SQL To SQL 2005
Mar 18, 2008My task is to convert this Informix SQl Script to SQL 2005, unfortunately I am not really familiar with Informix SQL. Below is an example script. I can figure out the "Select" statement and the "Where" statement, but the "From" statement is giving me a hard time. Any assistance would be appreciated.Thanks
set explain on;
UNLOAD TO '/export/home/permit/propinact.txt'
SELECT distinct property.parcel_number,
property.id,
property.eff_from_date,
property.eff_to_date,
property.situs_address_id,
legal_lines.legal_desc_line,
tax_code_area.tca_number,
usecd.value,
ct.code_description,
property_char.value,
property.property_status_cd,
legal_description.section,
legal_description.township,
legal_description.range,
property.pact_code
FROM property,
OUTER (legal_description, legal_lines),
outer property_char,
outer (property_char usecd, code_table ct),
tax_code_area,
prop_valuation
WHERE property.id = prop_valuation.property_id
AND property.id = legal_description.property_id
AND property.eff_to_date <= TODAY
AND legal_description.id = legal_lines.legal_id
AND legal_lines.line_nr = 1
AND tax_code_area.id = prop_valuation.tca_id
AND property.id = property_char.property_id
AND property_char.prop_char_typ_code = "SIZE"
AND property.id = usecd.property_id
AND usecd.prop_char_typ_code = "USECD"
AND usecd.value = ct.code_table_cd
AND property.pact_code <> 'PERS'
ORDER BY id
REPLICATION FROM INFORMIX 10 TO SQL SERVER 2005
Sep 8, 2005HI..
View 1 Replies View RelatedSSIS Help Loading From Sql Server 2005 To Informix 7.3.1 SE
May 16, 2008HI
I am transferring the data from sql server 2005 to Informix 7.3.1 SE using SSIS .
I am using the OLEDB data connection for both source as well as destination databases.
I am trying to mapping the source and destination tables .I am getting the following error.
TITLE: Microsoft Visual Studio
------------------------------
Error at Data Flow Task [OLE DB Destination [184]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21.
Error at Data Flow Task [OLE DB Destination [184]]: Opening a rowset for ""srinivas"."company"" failed. Check that the object exists in the database.
------------------------------
ADDITIONAL INFORMATION:
Exception from HRESULT: 0xC02020E8 (Microsoft.SqlServer.DTSPipelineWrap)
------------------------------
BUTTONS:
OK
------------------------------
I am using the following ODBC driver for the connecting INFORMIX 7.3.1 which is running on LINUX environment.
Openlink Generic ODBC Driver
It's creates the table in the informix 7.3.1 but it's not mapping the source and destination databases columns.
Please help me any one. it's urgent .
Thanks,
Srinivas Unnam
Need To Link Table In SQL Express 2005 From Informix/Access
Apr 5, 2007Hi,
Can someone help me and advise steps how to create link through ODBC between SQL Express 2005 & Informix ODBC / Access Database
Thanks
Amir
Connection Problem To Informix From SQL Server 2005 With Unicode Data
Dec 5, 2007I have Informix 9.4TC6 and SQL Server 2005.DB_LOCALE in Informix DB is en_US.utf8 (en_US.57372).First, I created DSN to Informix. Then tried to get data with WinSqltool and it works fine.But when I created linked server in SQL Server 2005 I have problemswith languages other than English.I get a string like:è 'å· åŒ-å|å·¥æ¥æ ªå1/4 ä1/4šç¤3/4It seems to me that SQL Server splits 2-byte characters in 2 1-bytecharacters.If in options of linked server we set Collation Name to exactlanguagewe want --then string data will be correct (of course only oflanguage that we choose).Do you have any suggestions?????????P.S. I don't want to use SSIS (DTS) for extraction from Informix DB
View 1 Replies View RelatedHow Can Replicate Between Ms SQL 2005 To MYSQL
Sep 14, 2006
Hi;
I have sql 2005 server in my local area and mysql server on internet..
How can replicate Ms SQL 2005 to MYSQL ? is that possible ? or any possible version this server ?
I try sql 2000 server for replication; publishing starting but then ı take "invalid cursor state " message. ı delete tables msrep7 in mysql then replication starts but if replication stop for any reason , ı must delete table again again...
is this bug in sql 2000 ? how can fix that ?
Thanks...
Execute Store Procedure In Informix From Sql Task Integration Services 2005
Dec 21, 2007
hi,
i need execute a store procedure of Informix from sql server integration services.
i use driver IBM informix provider 3.2 and have linked server Informix and use sql task for execute the procedure
it's posible??
Replicate Schema/Replicate Data Only
Sep 7, 1999Using SQL 7.0 I'd like to replicate just schema from DB on server A to DB on server B, then be able to replicate data only form DB on server B to DB on server A. I need help!!
Thanks for ANY information you can give me...
~Jepadria
Replicate Data From DB2/AS400 To SQL Server 2005
Sep 11, 2007Hi Guys
I am trying to replicate data from DB2/AS400 to SQL Server2005 (ENT edition) currently we use 3rd party tool to replicate data from DB2 to SQL Server2000 (ENT edition) and like to get rid of this 3rd party tool. I am searching for the last 3 weeks but didn€™t get a good starting point. I have linked DB2 to SQL Server2005 and can run queries against DB2/AS400 box. Now I want to set up transactional replication from DB2 to SQL Server 2005. I have read about peer to peer topologies but I don€™t know if that€™s the route I have to take?
So can someone please help me? I really appreciate your help.
Thanks
Tariq
Cannot Replicate Between SQL Server 2005 And Compact Edition On (XP 64-bit Version)
Nov 2, 2007Hello,
I have a computer thats running XP 64 bit version. I want to replicate between SQL server 2005 and SQL server 2005 compact edition. But it doesn't works. So i looked for a solution and i came to:
http://support.microsoft.com/kb/912430
This page is telling me:
You cannot replicate data from SQL Server 2005 to SQL Server Compact Edition by using the 64-bit version of IIS
Is that a problem that can be solved by not using a other Operating System?
Or can you maybe install a 32-bit IIS on XP 64 bit?
Informix
Sep 2, 2004Any SQL Server people out there with Informix experience?
View 7 Replies View RelatedINFORMIX TO SQL
May 16, 2008Please help. I am trying to translate this to SQL 2005. This language is in Informix SQl. I do not know anything about informix. I am especaially confused with the "JOINS". Any help would be appreciated. THANKS.
SELECT ppi.id,
ppi.property_id,
ppi.party_id,
ppi.address_id,
ppi.eff_from_date,
ppi.eff_to_date,
address.line_1,
address.line_2,
address.line_3,
address.city,
state.code_table_cd,
address.zip_postal_code,
country.code_description,
address.line_care_of,
prop_role.code_table_cd
FROM property,
address,
ppi,
outer code_table state,
outer code_table country,
code_table prop_role
WHERE property.id = ppi.property_id
AND ppi.address_id = address.id
{AND (property.eff_to_date IS NULL OR property.eff_to_date >= TODAY)
AND (ppi.eff_to_date IS NULL OR ppi.eff_to_date >= TODAY)
AND ppi.eff_from_date <= TODAY}
AND state.id = address.province_state_cd
AND country.id = address.country_cd
AND prop_role.id = ppi.prop_role_cd
AND prop_role.code_table_cd = "OWNER"
AND property.pact_code <> 'PERS'
ORDER BY ppi.id
Informix OLE DB Provider
Jul 14, 1999I have downloaded the datadirect ole db provider for informix 7.x and am need the correct sp_addlinkedserver syntax to get my sql server 7 and informix hooked up. Can anyone help?
Thanks!
Dean
Informix To SQL 2000
Apr 8, 2004Does anyone have any pointers on how i may import an Informix database into my SQL 2000 server?
What ODBC driver would i need?
Can i connect via DTS to import the data?
The application is not going to be moved, i am only interested in getting the data into a SQL2000 environment.
TIA
OLE DB / ODBC For Informix
Oct 16, 2001Hey everyone,
I'm trying to hit an informix box... I've found two software packages (both priced in the THOUSANDS of dollars)... Looking for a cheap...er, a FREE way to hit this informix box via DTS.
Thank you!
DTS From Informix Database
Jan 14, 2004Hi,
I want to transfer data from an Informix database using DTS. What driver do I need to use for that? What are the settings for the Data Source Name? Has anyone of you accomplished DTS from Informix to SQL Server?
Let me know if you have any ideas that you can share.
Thank you.
Vivek
IBM Informix Ole Db Provider
Apr 4, 2006Hello,
I'm getting the below errors when using sql server's data import wizard. Please Note: My test connection was successful and the error occurs when I click the "Next" button after closing the properties window. For Security reasons I've filled the User Id and DataSource with a bogus account, database, and server i.e. xxxx. Notice the password is blank?... Is that normal? I'm in a jam and appreciate your help.
Thanks,
Matt
===================================
Cannot get the supported data types from the database connection "Provider=Ifxoledbc;Password=;Persist Security Info=True;User ID=xxx;Data Source=xxx@xxxx". (SQL Server Import and Export Wizard)
===================================
IErrorInfo.GetDescription failed with E_NOINTERFACE(0x80004002).
IErrorInfo.GetDescription failed with E_NOINTERFACE(0x80004002). (System.Data)
------------------------------
Program Location:
at System.Data.OleDb.OleDbConnectionInternal.GetSchemaRowset(Guid schema, Object[] restrictions)
at System.Data.OleDb.OleDbConnection.GetOleDbSchemaTable(Guid schema, Object[] restrictions)
at Microsoft.SqlServer.Dts.DtsWizard.DataSourceInfo.LoadTypeData(OleDbConnection myDestConnection)
at Microsoft.SqlServer.Dts.DtsWizard.DataSourceInfo.CacheDataSourceInfo(IDbConnection myConnection)
SSIS And Informix
Oct 8, 2007We are using Informx for our transactional DB and want to be using reporting services to provide reports. We have some using ODBC directly to Informix, but need to start extracting data from Infomix
and aggregating it in SS 2005.
Is anybody else doing this?
Where can I find information of how to do this? We are totally new to SSIS.
Thanks
JPS
Connect To Informix DB
Oct 12, 2007
I need to create packages that connects to a client's Informix DB server. When I tried to create a new OLEDB datasource from configuration manager, I could not find any Informix driver option. Can someone shed some light as to what I'm missing and the steps I need to take to be able to source data from Informix? Any drivers that needs to be installed and configured on the server and the developer's machine?
Thanks in advance.
PS. I discovered from the link below that IBM's Informix OLEDB driver does not support SSIS. Can someone validate this claim and what alternatives I have?
http://ssis.wik.is/Data_Sources
Informix OLE DB Trouble
Nov 2, 2007
I am having trouble using an OLE-DB source in my data flow task. I am using Informix. In the OLE DB source editor I get the following message:
Warning at {4f24a418-f95e-4185-8989-4f960aaabd68} [OLE DB Source [1]]: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used.
Using the preview button in the OLE DB source editor, it maps the integers to DT_I4 so most of the numbers in the preview convert as null and that is how they end up in the target. I added a data conversion component and they still end up in the target as null.
SQL 2000 V 2005 - URGENT, PLEASE HELP!
Oct 26, 2007Hi, I have recently qualified as a MCITP - DBA with SQL 2005, but as I have no commercial experience, have been strugglling to get into the industry. However, I have finally been offered an interview on Monday. The problem is that the company use 2000, not 2005. I think I am pretty much up to speed on the differences, but was wondering (nay, pleading) if anybody could let me know the main commands for analysing query performance and index statistics etc, with a reference to thier equivalent DMV in 2005 (which I am totaly familiar with) This is something I could easily pick up whilst doing the job, but I am aware that there will be an SQL test to asses my knowledge during the interview and I am desperate not to get caught out. Please help!
View 2 Replies View RelatedNeed A Way To Port From Informix To Sql Server
Jan 5, 2001Hi,
Could anyone tell me how the data can be ported from informix to sql server ?
Is there a way to run the informix query from sql server ?
Thanks,
Vijay.
SQL Server Versus Informix
Oct 25, 2000Hi all,
Anyone here ever used the Informix database and can give me some differences between Informix and SQL.
One of our users is thinking about purchasing a COTS product that only supports an Informix database. I need to convince the user to evaluate other rival applications that can support SQL and need some arguments in favor of not going with Informix.
Any ideas appreciated,
Faustina
Link Informix To SQL Server
Oct 6, 2006Hi,
I am considdering to link a Informix database (running on SCO Unix) to a SQL Server 2005. Only problem is ... I have no idea how to do this! The reason I'm attempring this is to try and see if it would fix a problem I'm experiencing when using Reporting Services to generate reports from a Informix data source. I've been told that setting up a linked server might fix the problem. If anyone could perhabs guide me through setting up the linked server I would be very grateful! The ODBC credentials for setting up a connection to the Informix DB as follows:
Servername : pal_tli
Hostname : server_name
Service : pal_ser
Protocal : sesoctcp
Database : db_name
Username : user_name
Password : pword
:confused:
Migrate Informix Table
Dec 19, 2013Migrate an Informix table (and eventually an entire database) to MS SQL Server 2012. This is my first experience using SSIS. I started off using the SSIS Import/Export Wizard to create a package. I was actually able to successfully copy a table, but it just didn't copy all the data. It skipped all the data that was in string columns. It created the columns with the proper datatype in the destination table, it just didn't copy the data. The other columns all copied properly. I need to do to get the string column data to copy?
View 7 Replies View RelatedCalling All SQL And Informix Experts!
Jan 15, 2004Our Informix server is struggling with all the reports we run and so we are thinking of making a dedicated server for reporting.
SQL is an obvious choice because we have it already for our retail system.
However, the challenge is how to download the data we need each night. DTS works a treat but it is the volume of data that is the problem.
We are a retail operation and we need to download the transactions from our Informix server into SQL. This data gets into Informix from the EPOS system in our stores.
What we don't want to do is download everynight the entire back history of transactions. We could do this by using the date of the transactions but we discovered it wont work.
The problem is that if a store doesn't post their transactions e.g. because of a system failure then these will get missed.
What we need to do is record which transactions are downloaded into SQL and then compare this against what is on the Informix server and then download the difference each night.
We thought of adding a flag onto the Informix server but we are not able to make any modifications to it.
I think we could log the downloaded transactions in a SQL table and then use this as a record of what has been downloaded. We could then run a query that compares this to what is on the Informix server.
With the right indexes I think this could work really well. Any thoughts? Incidently the two servers are separated by a 512Kbps wan link......
Driver To Connect To Informix Via DTS??
Mar 1, 2004Hi, folks!
I want to pump data from Informix to SQL Server using DTS to fill / fresh up my SQL-Server data warehouse every day.
In the SQL documentation I found "Don't use the ODBC driver from Informix"
Which is a good choice of ODBC/OLE-DB drivers to deal with Informix via SQL servers DTS?
Regards from Berlin!
SeBaFlu
Error While Doing DTS From INFORMIX To MSSQL
Apr 13, 2004Dear All,
I'm using the DTS to transfer data from Informix 7.30 UC9 to MS SQL 2000 Enterprise. The tables I'm transferring contains data for BaaN ERP.
While transferring certain tables, I am successful. On some, I get an error that says "Data overflow". It was caused by "DBTYPE_DBTIMESTAMP".
Any idea why this happens?
Thanks!
Equivalent To Informix/DB2 Synonym
Apr 28, 2004Hi all. Informix and DB2 support something called synonyms that allow you to basically create sort of an alias for a table at the database level. Think of it sort of as a shortcut or link to a table. Does SQL Server 2000 have a similar ability and if so how?
I know someone will ask why you want to do this, so heres a quick example:
If you have one legacy application that expects to write to one particualr table, but you wish to partition that table across several tables, you can break table1 up into tablea,tableb,tablec and then create a synonym called table1 that would point to only the appropriate table at the appropriate time. This way you can break a huge HUGE table up into logically discreet smaller tables and manage the creation of the appropriate synonym in some wrapper that sits in front of the legacy application...thus allowing you to retool a table that has outgrown its original design without having to crack open dreaded legacy code.
So, anyone?
Connect To Informix Database
Apr 9, 2008Hi everyone. I'm trying to switch from using Access, to using Sql Server to create my databases. The first thing I'd like to do, is connect to our CMS (Call Management System) to start creating reports on some of our data. I can't seem to figure out how to connect to it though. In Access, I use an ODBC connection. I installed a "Generic 32 Bit Driver" and I created a .dsn file called Lucent.dsn that Access uses to connect to the Informix database. I guess my question is, what is the connection string and where does it go? I've searched on this forum and on a few others and I can't seem to find help for someone as new as me!
Thanks for any help!
Dave
Windows XP, Office XP
Trouble With Informix Datatypes
Nov 2, 2006Hi everybody!I'm working on a migration from Informix to SQL Server... I'm doing itthrough DTS and ODBC.What I'm doing is using the DTS, my data origin is tha Informixdatabase and mi target is the SQL Server database that I just created,this is via IBM Informix ODBC and I copy the tables... but the resultsare something like this:--INFORMIX--create table r_cap_dbt_uni(num_db smallint ,cve_uni char (8) ,fecha_mens datetime YEAR to MONTH ,valor float ,primary key ( num_db, cve_uni, fecha_mens ) ,foreign key ( num_db )references cat_db_tec ( num_db ));-- SQL SERVER --create table r_cap_dbt_uni(num_db smallint ,cve_uni char (8) ,***********************************************fecha_mens smalldatetime ,valor float ,***********************************************primary key ( num_db, cve_uni, fecha_mens ) ,foreign key ( num_db )references cat_db_tec ( num_db ));as you can see the float and datetime year to month data types changelike the example before.... I changed the "float" datatype manually to"decimal" datatype... but I don't know what to do with the "datetimeyear to month" Informix datatype, I mean, I dn't know why the DTSchanges this datatype to "smalldatetime"... how can I map this? what'sthe process?Thank you very much!Rodolfo
View 3 Replies View Related