I'm doing a migration from Sybase SQL Anywhere to SQL Server 2005. This is one of the query that doesn't work:
select card_nr as cCard,
card_type as cType,
tab_cards_profile.profile_name as cProfile_name,
dbo.fn_name_pdcode( cCard, cType, tab_history.system_code ) as cCard_name,
dbo.fn_card_date_entry(cExit, cCard, cType, tab_history.system_code ) as cEntry,
evn_date+evn_time as cExit,
tab_history.profile_id,
payment_type,
dbo.fn_name_pdcode( param1, payment_type, tab_history.system_code ) as cPay_name,
param1,
datediff(minute, cEntry, cExit) as durata,
amount
from tab_history
LEFT OUTER JOIN tab_cards_profile ON ( tab_history.profile_id = tab_cards_profile.profile_id AND tab_history.card_type = tab_cards_profile.profile_type)
LEFT OUTER JOIN tab_personal_data ON tab_personal_data.name = cCard_name
Both the functions called
dbo.fn_name_pdcode( cCard, cType, tab_history.system_code ) as cCard_name,
dbo.fn_card_date_entry(cExit, cCard, cType, tab_history.system_code ) as cEntry
seems that can't work if I use as parameters alias of columns... This could be a problem; in sybase ASA that query can be executed. there is any work around to help this query runs?
Here i had a task to migrate sybase 8.0 database to mssqlserver 2005 .how can i migrate this using INTEGRATED SERVICES (SSIS) or any other options. .Please try to provide some basical info because i am new to sybase versions.
I know that there are tools like Lumigent, but an wondering about theinternal facilities to track events such as table creation, securityoperations (add login, add role), and such.Under Sybase, there is a set of procedures that permit you to settheses events and to record the results for later extraction andanalysis.The Profiler seems to have a lot of the same functionality but thisappears to be more along the lines of running a monitor.Can the events be tracked without Profiler running?Can the events being tracked be recorded in the system of SQLServerlogs?
Hi all, I am Migrating a database from sybase to sql server 2000. I Have already created objects in sql server 2000. I have to only populate it with the data. I have decided to genrate insert script from the aquadata tool and run the script againgt sql server database. It works fine except for few table which have 1,50,000 and 9,00,000 rows. It shows insufficent memory error when i try to run the script with 1,50,000 and the script with 9,00,000 doesn't open in management studio. Please help.
Here i had a task to migrate sybase 8.0 database to mssqlserver 2005 .how can i migrate this using INTEGRATED SERVICES (SSIS) or any other options. .Please try to provide some basical info because i am new to sybase versions.
I have used SSIS successfully to copy Oracle tables using Microsoft OLE DB provider for Oracle but I do not see any direct driver references to Sybase in the drop-down list. How do I use the ODBC driver (from Oracle or from Microsoft) I have available on the same computer? Thank you.
We have been accessing databases on ASE 12.5 (on HPUX) from MS SQL Server 2000 (x32) successfully for years. We do this via linked servers we create on MS SQL Server. When creating the linked server, we would specify the Microsoft OLE Provider for ODBC as the provider, and the data source is the name of a DSN created with the Sybase ASE ODBC driver (4.20.00.67) that points the the HPUX box on which are the Sybase databases.
We have also gotten this to work just fine on MS SQL Server 2005 (x32) Standard Edition SP1. However, we cannot seem to get this to work on MS SQL Server 2005 (x64) Enterprise Edition SP1. The Microsoft OLE DB Provider is not available as an option when creating the linked server on MS SQL Server 2005 (x64). We have tried specifying the SQL Native Client as the provider, but this results in no connection being made and reports the following error:
OLE DB provider "SQLNCLI" for linked server "GCMTESTSQLNATIVE" returned message "Login timeout expired".
OLE DB provider "SQLNCLI" for linked server "GCMTESTSQLNATIVE" returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.".
Msg 53, Level 16, State 1, Line 0
Named Pipes Provider: Could not open a connection to SQL Server [53].
Do we need to use a different ASE driver when accessing Sybase databases fom the MS SQL Server (x64) platform? Or is there a way to successfully create a linked server on MS SQL Server 2005 (x64) that can communicate with the 32-bit ASE ODBC driver?
I have a master database (sybase) that is in place as a company legacy server -
I am setting up a web server to act as an intranet and data entry terminal system.
I want to ultimately remove sybase from the picture, but for now, i need to grab information from the sybase server and populate the MSSQL database with the values from the sybase database.
So my question is this -
Is there a way to setup a "auto polling" or synching between the MSSQL and the sybase system.
If there isn't then i will need to do a DTS job to grab the values from the sybase ODBC connection, and populate my database that way - but there must be another way to accomplish this task.
A question that may have been asked on many occasions, but what can be advised as the best way to migrate a Sybase 11.x DB to SQL 7.0, (without using BCP). Does DTS support such migrations and if so, where in DTS can this be done? I'd appreciate any basic help here to get me started on this exercise. MAny thanks
We plan to convert our current OLTP intensive application from Sybase on NT to SQL 2000. Which one is the winner in terms of performance. I was told that SQL Server has less tools to tune the database especially for OLTP intensive database.
Have you done any test comparing the performance between Sybase and SQL server? What is your opinion on this? Do you know any good third party tools to tune SQL 2000?
We have Trading Applications (Equities & Portfolio written on C++) on MS SQL Server 2000. Now the management is deciding to move it on Sybase 12.5. We currently don't have any issues on any matter, but because everyone is SYbase fan here, thinks applications are critical and we need to move to Sybase. Can anyone who has worked on both knows the major pros & cons of both the system. Actually I wanted these systems to be on MS SQL Server. I need solid reasons except being cheaper than Sybase to show why we should use MS SQL Server
If anyone can share their experiences, it would be really great.
I have the following SQL statement from a Sybase 5 database and I don't know how to get it to work in a SQL 7 database. Any help much appreciated.
TIA, DBA without the PAY
SELECT firms.id, firms.description, firm_mailing_addresses.firm, firm_mailing_addresses.address1, firm_mailing_addresses.address2, zip_codes_a.city as mailing_city, zip_codes_a.state as mailing_state, firm_mailing_addresses.zip_code as mailing_zip, firm_mailing_addresses.zip_plus4 as mailing_zip_plus4, firm_physical_addresses.firm, firm_physical_addresses.directory_phone, firm_physical_addresses.address1, zip_codes_b.city as physical_city, zip_codes_b.state as physical_state, firm_physical_addresses.zip_code as physical_zip, firm_physical_addresses.zip_plus4 as physical_zip_plus4 FROM {oj {oj firms LEFT OUTER JOIN firm_physical_addresses ON firms.id = firm_physical_addresses.firm} LEFT OUTER JOIN firm_mailing_addresses ON firms.id = firm_mailing_addresses.firm}, {oj firm_physical_addresses LEFT OUTER JOIN zip_codes zip_codes_b ON firm_physical_addresses.zip_code = zip_codes_b.zip_code AND firm_physical_addresses.zip_plus4 = zip_codes_b.zip_plus4}, {oj firm_mailing_addresses LEFT OUTER JOIN zip_codes zip_codes_a ON firm_mailing_addresses.zip_code = zip_codes_a.zip_code AND firm_mailing_addresses.zip_plus4 = zip_codes_a.zip_plus4} WHERE firms.id = 120
I will be migrating Sybase Databases (and Centura) to MS SQL Server Databases. While I have administered MS SQL Server for many years, I have never administrated or even saw a Sybase database. My question, can anyone suggest any books to get me up to speed on Sybase, so I can transfer all databases, including tables, procs, etc... to MS Sql Server?
Good day.I have dts running every 10 minutes in a server of slqserver 2000 who is in a country and that it sends data to another country which has a data base sybase12.5.The problem is when by reasons for the WAN the connection fails from a country to another one the dts or job fails executing its processes and I must soon give click to stop and start so that it continues. That I can do so that when the connection is lost and i need to dts reconected automatically and is continued its processing? thanks and sorry my english :)
If I need to have SQL Server be able to query a Sybase database on another machine (Adaptive Server anywhere 7.0.2 with an ODBC connection), what is the simplest, least expensive way to do this ? Thanks
Coming from Sybase env. I would like to know the equivalent of sp_showplan. What it does is, it shows the showplan for the query being run by spid, which is passed as a parameter to sp_showplan.
Has anyone ever experienced compatibility and/or performance issues when SQL 2K and Sybase are run concurrently on the same server? I believe the server is using Windows 2K3.
My tribe is creating a central database, running Sybase 5 and Eaglesun. I’m curies if anyone has worked with Eaglesun and if you had any issues with the software or with data conversion??
Thanks for the input
US Navy - We are fueled, armed, and go for launch.
I am not sure is this the right forum to get solution to my question.
From where i can get sysbase basics. I am posting this query in this forum coz this forum and gurus in this forum had helped me in lot critical situtions.
I know sql and Dataware housing.I got a job offering for sybase sql but I don't anything about sybase.Will it be in programming in Actually what we will do in sybase? What will be the nature of work? and I just want to know what type of question will be asked ? Please do reply.
I am assuming someone has had success connecting to Sybase from SSIS. I am having trouble. And I freely admit naivety when it comes to something like this. :-)
I installed dbConnector 6.01 which has a Sybase connector as a part of the package. I then tried to create a connection manager for Sybase using OleDb, but it was not an option in the list of OleDb connections. So, am I correct in assuming that I need to use ODBC? If so, is there an OleDb Sybase driver that can be used with SSIS?
Any help in using SSIS to connect to Sybase would be appreciated.
It's all well and good that Microsoft has finally entered the well-established mobile database market (the market that iAnywhere Solution's SQL Anywhere product current *owns* by a wide margin). However, it should be noted that "SQL Everywhere" is a Sybase trademark. For confirmation of this fact, see http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.mro12.6.mro126ig/html/mro126ig/legal.htm
For confirmation of the fact that SQL Anywhere owns the mobile database market, note that it is the database of choice for the 500,000 mobile devices that will be used in the 2010 US Census; see http://www.internetadsales.com/modules/news/article.php?storyid=7347
How connect Microsoft Visual Studio BI with Sybase ASE 12.0 (not 12.5.x) database via OLE DB?
I try with "Srvr=,[PORT];Catalog=[DBNAME];User Id=[USER];Password=[PASSWORD];" but error
"Error en la conexión de prueba debido a un error al inicializar el proveedor. El proveedor 'Sybase.ASEOLEDBProvider.2' no está registrado en el equipo local."
I found a post from over a year ago saying that Sybase IQ as a DB Destination is not supported by SSIS (there was a hack, but not something for a strategic solution).
Has there been any change to this in the mean time?
A partner company unfortunately chose Sybase SQL Anywhere v5 as their database and I have to return data from the tables for a web service that I am writing - YUCK !
The ODBC driver is riddled with errors and has no support. Third party .NET providers do not seem to support v5, so I have resorted to playing with DTS in Enterprise Manager.
After fumbling around for a while, I managed to get an "Execute SQL Task" to return data and saved the package in both SQL and VB.
Now, before I waste any more time heading in this direction, can anybody advise if DTS is supported by MSDE as the full blown SQL Server will not be an option ?
If it is supported - is this a good way to go, or is there a better solution ?
Hi, I have a situation where in I need to insert a record in sybase database table whenever there is an update on a table in my sql server database. Can any one suggesst me hoe can I do it? thanks In advance Mohan
We have created linked servers that connect to Sybase databases using the Sybase OLE DB provider and the Sybase ODBC provider.
The OLE DB provider does not allow the execution of a stored procedure. The message sounds like a permissions issue, but the id specified in the linked server has execute priv. for the stored procedure. It also does not allow the fully qualified name <server>.<db>.<owner>.<obj> to be used.
There are other issues with OLD DB and ODBC.
Anyone have any experiences making MS SQL to Sybase work smoothly?
