Mapping a sybase db on a MS SQL server

Hi,
I'm looking for an ETL tool to replicate my Sybase database on a MS
SQL server. Any idea on how to proceed?
Thanks,
--Michel
Hi
Look at DTS. It is part of the SQL Server install.
Regards
Mike
"Michel" wrote:

> Hi,
> I'm looking for an ETL tool to replicate my Sybase database on a MS
> SQL server. Any idea on how to proceed?
> Thanks,
> --Michel
>

Mapping a sybase db on a MS SQL server

Hi,
I'm looking for an ETL tool to replicate my Sybase database on a MS
SQL server. Any idea on how to proceed?
Thanks,
--MichelHi
Look at DTS. It is part of the SQL Server install.
Regards
Mike
"Michel" wrote:
> Hi,
> I'm looking for an ETL tool to replicate my Sybase database on a MS
> SQL server. Any idea on how to proceed?
> Thanks,
> --Michel
>

Managing MS SQL on Linux

Hi everyone,

I'm looking into moving my desktop system at work to Linux from Windows
XP, and one tool I've yet to find a suitable replacement for is MS SQL
Enterprise Manager. I mainly need to query MS SQL databases from
Linux, and management tasks (monitor backups, services, etc) can be
done on the MS SQL servers themselves. THere was an application I used
to use on OSX which would connect to a variety of databases, including
MS SQL, and they had a Linux version of the client .. but can't
remember the name. But really any Sybase client that can connect to MS
SQL with some ease will work.

Thanks for any suggestions or ideas ...

AlexAlex wrote:

Quote:

Originally Posted by

Hi everyone,
>
I'm looking into moving my desktop system at work to Linux from Windows
XP, and one tool I've yet to find a suitable replacement for is MS SQL
Enterprise Manager. I mainly need to query MS SQL databases from
Linux, and management tasks (monitor backups, services, etc) can be
done on the MS SQL servers themselves. THere was an application I used
to use on OSX which would connect to a variety of databases, including
MS SQL, and they had a Linux version of the client .. but can't
remember the name. But really any Sybase client that can connect to MS
SQL with some ease will work.
>
Thanks for any suggestions or ideas ...
>
Alex

Using "is" with the -m flag you can query MS SQL Server databases. is
also has a whole bunch of other useful and cool stuff:

<http://gagne.homedns.org/~tgagne/is/>|||ZeldorBlat wrote:

Quote:

Originally Posted by

Alex wrote:

Quote:

Originally Posted by

Hi everyone,

I'm looking into moving my desktop system at work to Linux from Windows
XP, and one tool I've yet to find a suitable replacement for is MS SQL

Use RDP or any method like UltraVNC, TightVNC, etc. etc. that allows
you to log in to the SQL server itself and do your stuff...then you can
use SSMS and all its goodness...I RDP all the time to my servers. No
harm done.

HTH tom|||tlyczko wrote:

Quote:

Originally Posted by

ZeldorBlat wrote:

Quote:

Originally Posted by

>Alex wrote:

Quote:

Originally Posted by

>>Hi everyone,
>>>
>>I'm looking into moving my desktop system at work to Linux from Windows
>>XP, and one tool I've yet to find a suitable replacement for is MS SQL

Why not Oracle Database 10g Express Edition? It is completely free and,
it runs on both Windows and Linux. It is a fully functional Oracle
database engine.

http://www.oracle.com/technology/so...e10g/index.html
--
Daniel Morgan
University of Washington|||Alex wrote:

Quote:

Originally Posted by

Hi everyone,
>
I'm looking into moving my desktop system at work to Linux from Windows
XP, and one tool I've yet to find a suitable replacement for is MS SQL
Enterprise Manager. I mainly need to query MS SQL databases from
Linux, and management tasks (monitor backups, services, etc) can be
done on the MS SQL servers themselves. THere was an application I used
to use on OSX which would connect to a variety of databases, including
MS SQL, and they had a Linux version of the client .. but can't
remember the name. But really any Sybase client that can connect to MS
SQL with some ease will work.

If you are mainly querying SQL you can use FreeTDS which comes with a
command line query tool aka osql IIRC. Other than that there are some
free Java based tools around that can execute SQL on any DB with a JDBC
driver and some of them are even capable of displaying meta data. One
of them is http://www.sql-workbench.net/ - you may find more here:
http://www.databaseanswers.com/modelling_tools.htm
http://www.javaskyline.com/database.html
Kind regards

robert|||I'm looking into moving my desktop system at work to Linux from Windows

Quote:

Originally Posted by

Quote:

Originally Posted by

XP, and one tool I've yet to find a suitable replacement for is MS SQL
Enterprise Manager.

Try Squirrel SQL http://squirrel-sql.sourceforge.net with jtds that
someone else mentioned. It's the best open source database admin tool
I've found so far.

tim

Managing Disk Space

Is there a tool or trick/tip for managing disk space on SQL Server
(database/tran log size vs. free disk space)?
Thanks.
No tricks really. You have to chose the best recovery model for your
database, and an appropriate backup plan, to keep the transaction log files
in check. Also, defragmenting your tables will help avoid disk space
wastage. Please read up on recovery model, BACKUP/RESTORE, DBCC DBREINDEX,
DBCC INDEXDEFRAG.
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"SQL" <nospam@.adfadfadf.com> wrote in message
news:eWiPESrYEHA.3512@.TK2MSFTNGP12.phx.gbl...
> Is there a tool or trick/tip for managing disk space on SQL Server
> (database/tran log size vs. free disk space)?
> Thanks.
>
|||Hi,
For Managing the growth you can use the Performance monitor. You create the
Alerts in performance monitor
which can raise an network message / write in application log based on the
threshold limit set for each counters.
You can also create your own alerts using SQL Agent from SQL Enterprise
manager.
Monitor disk space , see the belew link.
http://www.databasejournal.com/featu...le.php/1475741
Apart from this you can use the 3rd party tool.
http://www.bmcpatrol.com
Thanks
Hari
MCDBA
"SQL" <nospam@.adfadfadf.com> wrote in message
news:eWiPESrYEHA.3512@.TK2MSFTNGP12.phx.gbl...
> Is there a tool or trick/tip for managing disk space on SQL Server
> (database/tran log size vs. free disk space)?
> Thanks.
>

Managing Disk Space

Is there a tool or trick/tip for managing disk space on SQL Server
(database/tran log size vs. free disk space)?
Thanks.No tricks really. You have to chose the best recovery model for your
database, and an appropriate backup plan, to keep the transaction log files
in check. Also, defragmenting your tables will help avoid disk space
wastage. Please read up on recovery model, BACKUP/RESTORE, DBCC DBREINDEX,
DBCC INDEXDEFRAG.
--
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"SQL" <nospam@.adfadfadf.com> wrote in message
news:eWiPESrYEHA.3512@.TK2MSFTNGP12.phx.gbl...
> Is there a tool or trick/tip for managing disk space on SQL Server
> (database/tran log size vs. free disk space)?
> Thanks.
>|||Hi,
For Managing the growth you can use the Performance monitor. You create the
Alerts in performance monitor
which can raise an network message / write in application log based on the
threshold limit set for each counters.
You can also create your own alerts using SQL Agent from SQL Enterprise
manager.
Monitor disk space , see the belew link.
http://www.databasejournal.com/feat...cle.php/1475741
Apart from this you can use the 3rd party tool.
http://www.bmcpatrol.com
Thanks
Hari
MCDBA
"SQL" <nospam@.adfadfadf.com> wrote in message
news:eWiPESrYEHA.3512@.TK2MSFTNGP12.phx.gbl...
> Is there a tool or trick/tip for managing disk space on SQL Server
> (database/tran log size vs. free disk space)?
> Thanks.
>

Managing Disk Space

Is there a tool or trick/tip for managing disk space on SQL Server
(database/tran log size vs. free disk space)?
Thanks.No tricks really. You have to chose the best recovery model for your
database, and an appropriate backup plan, to keep the transaction log files
in check. Also, defragmenting your tables will help avoid disk space
wastage. Please read up on recovery model, BACKUP/RESTORE, DBCC DBREINDEX,
DBCC INDEXDEFRAG.
--
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"SQL" <nospam@.adfadfadf.com> wrote in message
news:eWiPESrYEHA.3512@.TK2MSFTNGP12.phx.gbl...
> Is there a tool or trick/tip for managing disk space on SQL Server
> (database/tran log size vs. free disk space)?
> Thanks.
>|||Hi,
For Managing the growth you can use the Performance monitor. You create the
Alerts in performance monitor
which can raise an network message / write in application log based on the
threshold limit set for each counters.
You can also create your own alerts using SQL Agent from SQL Enterprise
manager.
Monitor disk space , see the belew link.
http://www.databasejournal.com/features/mssql/article.php/1475741
Apart from this you can use the 3rd party tool.
http://www.bmcpatrol.com
Thanks
Hari
MCDBA
"SQL" <nospam@.adfadfadf.com> wrote in message
news:eWiPESrYEHA.3512@.TK2MSFTNGP12.phx.gbl...
> Is there a tool or trick/tip for managing disk space on SQL Server
> (database/tran log size vs. free disk space)?
> Thanks.
>

Management Studio, Save as... dialog before running External Tools

Hi.

In Management Studio I have defined some external tools. When I call my external tool from Tools menu and I have query scripts that are not saved I get "Save File As..." dialog for EVERY not saved script before running my External Tool. This is frustrating because sometimes I have a lot of not saved scripts and my External Tool doesn't need saved script files. How to run External tool in Mangement Studio without this frustrating "Save File As..." dialog box?

Kamil

I get the same thing. I can click cancel and the tool still opens, but it is annoying.