Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
NguyenL71
Posting Yak Master
228 Posts |
 Posted - 2012-02-10 : 11:47:06
|
| [code]Hi,I have a project that need to generate all the schemas in SQL Server 2008 which include tables, indexes, Triggers, and functions and run those scripts against Sybase.Do you know such good web sites or have some scripts to do that can share with me. I try to google it found some info but it doesn't give me much what I am looking for.I don't know much about Sybase and I believe there should be some toots out there can do this type of jobs. Any help/suggestions would greatly appreciate.Have a great weekend.[/code] |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-10 : 11:51:41
|
| sorry didnt understand why you need to create scripts against sql server if you're sure you're using it in sybase? anyways one safe way is to write scripts in ANSI standards so that most of them can be used in Sybase without much tweaking------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2012-02-10 : 11:52:29
|
| http://www.sybase.com/content/1047976/MSSQL-ASE-Guide-111006-wp.pdf<><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
|
|
|
NguyenL71
Posting Yak Master
228 Posts |
Posted - 2012-02-10 : 12:18:49
|
[code]Thanks for the info. We are supporting 2 platforms, one for SQL Server and existing customers are Sybase. That's why every new tables, indexes, triggers, etc... create in SQL Server must havethe same in Sybase otherwise, the application is break. We are ina process to convert Sybase folks to SQL Server but that won't happen soon.Thanks.[/code]quote:
Originally posted by yosiasz
http://www.sybase.com/content/1047976/MSSQL-ASE-Guide-111006-wp.pdf<><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion
|
|
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2012-02-10 : 12:45:25
|
| maybe you could create a linkdserver to sybase in sql, put some views that point to the sybase tables and make sybase data 'visible' in sql.<><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
|
|
|
|
|
|
|
|
SQL Server/Sybase questions?