Migration of Sybase ASE to SQL Server

Hi I have been working with MSSQL for over 17 years. I am fully experienced as a developer and a DBA. Currently I am working at big financial organization in which I am responsible for the BI department. I have designed and the Developed the Organization’s Reporting Database which has been constructed with SQL Server 2008 R2 Enterprise Edition. The database is being updated daily from the core system with txt or excel files via SSIS or with direct connection at mainframe’s DB2 and a numerous of KPIS are being daily updated during the ETL. For isolation reasons the KPIS are replicated to another DB (with transactional replication) which exploits the reports via SSRS to the consumers. Some KPIS are being replicated with merged (bidirectional) replication. Also, 10 Cubes in SSAS are being daily automatically processed and the end of the ETL. Several other reports are daily automatically produced and sent via email to the recipients. Finally I have designed and developed the bank’s crm DB which is published on the intranet. The DB holds full information about the customers (Customers,Addresses , Financial Data , Contacts , campaigns , etc) and covers 4 countries. To achieve this i have made partitions over the country code. The size of the Reporting DB, is about 4TB and consists of about 4.000 objects and the replicated KPI DB is 350GB. Best Regards mpalgeo

Hello, I'm expert in ETL and have lot of work done of this type and expert in sql server . please share the source of your sybase ase data so that i could start work. thanks,

Hi, I am database developer with data migration/ETL experience I worked with variety of Relational databases I propose to work with you. From the proposal, it is not clear any stored procedures are involved. if yes how many? (or how many lines of code) My proposal is to convert tables/views and data only (not involves any stored procedures conversion) I will be using open source data migration tool (like Pentaho data integration) for the migration You have any queries or specific requirements, Please let me know. Regards Sankar

Hi, I have experience in both MSSQL and Sybase ASE with combined experience of 15+ years. I assume that it is a one time migration exercise. is this understanding correct? also assume that only schema and data are to be migrated and scope does not include stored procedures/functions. not clear on what you mean by 'migration of adhoc statements' and 'synchronize with database' will you be providing access to your system or will you be just providing backup of the database and we migrate in our system and share the mssql db backup hope to hear from you regards Babu

Hi, We can migrate SybaseASE project to SQL for you! Please initiate a discussion with us, so we can proceed further. ABOUT ME: ========= I represent Infodart India Limited(IT vertical of Videocon Telecom Private Limited), We have a pool of 250+ talented software developers, in Android, IOS, .Net, SAP, PHP, JAVA, Oracle, each within an experience rage of 8-30 years. With a wide chain of satisfied clients globally, we now plan to get involved in more business partnerships through freelancer! Looking forward to your valuable response! Regards, Nidhi, Infodart India Limited

I can help you with this

Hi , I am a Sybase and SQL developer and DBA. Not only would i migrate the data but i would also help you in scheduling maintenance jobs which would optimize the performance in the long run. Thanks and Best Regards Gangashankar Singh Sybase/SQL DBA and Developer