Any Good Third Party Replication Tool For Sql Server ?
Feb 7, 2001Hi folks
wld really appreciate it if anyone could guide me to a good third party tool for replication on sql server.
thanks in advance
achal
ADVERTISEMENT
Using Third-party Report Tool To Work Against SQL Server
May 29, 2008Hi,
I'm using one report tool by 'AriaCom' and have got such problems with FREE SQL in that tool. Pls advise!
Message:
SQLExecDirect>[ODBC 195][37000][Microsoft][ODBC SQL Server Driver][SQL Server]'instr' is not a recognized built-in function name.
Message:
SQLExecDirect>[ODBC 195][37000][Microsoft][ODBC SQL Server Driver][SQL Server]'mid' is not a recognized built-in function name.
What Is A Good Tool For Modeling A SQL Server 2005 Database?
Nov 20, 2006Hello,
I need a tool that will let me model a SQL Server 2005 database and then generate the tables, constraints, etc. from the model. I've never used a modeling tool so my knowledge is quite limited. I don't need to model or reverse engineer an application - my sole concern is on the SQL Server database side. I'm not concerned if the tool integrates with Visual Studio. And, of course, price is one consideration.
Are there any good tools that I should look at?
Thanks,
BCB
Third Party Tool
May 1, 2001Hi All,
I have to load data from from a text file ( approx 3-5 million rows) into a table .
I can use straight bcp with the format file , but the loading of data has to follow some business logic
Let me know if there are any third party tool to load the data instead of regular bcp
I have SqlServer 7.0 on Windows NT 4.0
Thanks in advance
Third Party Sql Tool
Jul 20, 2005I prefer to write SQL code, without graphical tools.Have third party Query Analyzer that has filter and sort abilities?Also I looking for SQL editor with Completion ability (like we know forprogramming lang),for assist me write more quickly.
View 1 Replies View RelatedLine Tool (UHH - What Is It Good For? - Sing It Again.)
Mar 6, 2008I'm trying to create custom borders. I can't use the line tool in a text box nor can I add text to a rectangle. Any ideas how to draw a border that isn't the standard 4 lines around the edges king of thing?
View 2 Replies View RelatedGood And Cost Effective Ms Sql Monitoring Tool
Aug 6, 2007Hi everyone,
I am looking for sql monitoring tool. I have found tools from Idera and Quest but the price is a bit expensive.
The tool I am lloking for is able to show historical information such as CPU/memory/disk usage.
Any good suggestion? Thank you in advance.
A Resourse Good For Problems Replication In Sql Server 2000
Jul 20, 2005i want a good resourse for to learn replication in sql 2000 inoder topractical learn and implemetion replicat
View 1 Replies View RelatedReporting Services ReportServer DB Reporting - 3rd Party Tool ?
Jan 15, 2007HI There
We are required to gather certain information regarding reporting services.
Which reports were requested, by whom , how long did they run for, what parameters were passed etc etc.
I see that the system tables do provide some of this information, is there a 3rd party tool or something we can use to gather all this type of information for us?
This is for reporting services 2000 and 2005.
Thanx
Must You Use 3rd Party Certs For Mobile Ssl Replication?
May 25, 2006Hello,
We are trying to setup ssl for a merge replication mobile application. We use our own internal certificate authority to generate ssl certs, but cannot seem to get the one for our mobile merge replication to work. I see some other post about using third party vendors but is this a must? We are using .NETCF 2.0 WM 5.0. Thanks in advance.
John
Need A Good Book On Replication????
Jul 31, 2000Anyone has a suggestion on a good book on Replication. How to set it up.. I am looking for a good detailed book on this subject.
View 2 Replies View RelatedGood Book About MS-SQL Replication...
Jul 20, 2005Hi,Does anyone know any good book(s) about MS-SQL, especially aboutReplication - basically, I need in-depth explanation about how tosetup/maintain Snap Shot, Transactional, Merge Replication anddifferent agents - with good examples? Hopefully, the book(s) isrecent enough to cover SQLCE merge replication as well. In-depthinformation about DTS is a plus ^_^Just tired of print hundreds of pages from MSDN site.Thanks,Charlie Chang
View 1 Replies View RelatedLooking For Db Replication Tool
Jul 20, 2005I'd like to use log shipping to provide warm backup to some productionMSFT SQL 2000 servers. I know that I can write something to ship logsbut I'm looking for a complete solution that would take a while towrite. Prefer not to upgrade to SQL enterprise (too costly). Isthere a tool that provides a robust solution? ... deletes old logfiles, logs events, does backups, failure notification, recreatesschemas, etc.
View 2 Replies View RelatedReplication, Is That The Correct Tool For The Job?
Jul 10, 2007Hello, coming back to SQL Server after working with Oracle for a while.
I am currently using SQL Server 2005, and have an issue I am not exactly sure how to solve.
Let's say I have two instances of a database (A & B), the schema of both instances is exactly the same. If I perform an insert on instance A table A how can I automatically have that insert reflected on instance B table A? Both instance are on the same machine. Also I do not want to reflect all the data just one table across multiple instances.
I thought replication might be the answer but typically that is used across multiple machines, no?
Any help would be greatly appreciated. Thanks
CONNECTING TO SQL SERVER FROM A 3RD PARTY SOFTWARE
May 17, 2008I am trying to use NConstruct to generate my Nhibernate files. i can't connect to the sql server. In the past I have ran into similar problems with MyGeneration and other 3rd party tools. In those cases If I ran the tool as an administrator, it worked out ok. For NConstruct there is no option to run as administrator. I ran the SQL Server Surface Configuration tool to allow local and remote connections for named pipes and tcp already. I read all the blogs written for asp.net, and people often complain about the learning curve for Nhibernate or lack of Tutorials for Nhibernate. What I found in my case is that the steepest learning curve is to get the Microsoft Products Configured and Working Correctly! If anyone can be of any assistance, I would deeply appreciate it
View 1 Replies View RelatedUsing 3rd Party Software For SQL Server Backups
Apr 12, 2004Has anyone had experience using ‘VERITAS Backup Exec For Windows Servers Agent for MS SQL Server’ to run backup jobs? If so, what are the pros and cons?
I have always preferred using SQL Server Agent (not the maintenance plans) to run backup jobs and don’t know why anyone would want to use 3rd party software to do something SQL Server Agent does perfectly. Any advice?
Best 3rd Party Backup Software For SQL Server.
Apr 15, 2008In your own opinions, what is the best backup tool for SQL Server, taking value for money into account where possible.
I am looking to purchase 3rd party software for my company and would greatly appreciate your suggestions.
Thanks.
Linked Server To Third Party LDAP
Apr 14, 2006I thought I was successful in linking SQL to a Third Party LDAP in the past, but I cannot get it to work now. It has been about 2 years ago I played with this. The LDAP does require authentication and I think that is where the problem lies, but if anyone can tell me if there is a way to do this and what the steps are I would greatly appreciate it.
View 2 Replies View RelatedWhich Party Manages The Timeout Of Class SqlCommand? .Net Or SQL Server?
Mar 6, 2008Dear all,
Our system is using .Net 1.1 and SQL Server 2000.
In our system, the timeout of SqlCommand is set to 300 seconds (~5 mins). However, there was a case that exception 'ThreadAbortException' was thrown in .Net (IIS Server), with its corresponding query was blocked over 11 minutes.
The case raised a question: 'Which party manages the timeout after the sql command is sent to DB? .Net, IIS Server or SQL Server?' If the timeout is managed by .Net or IIS, is there any setting making SQL Server 2000 possible to kill the aborted process earlier?
Thanks for helps.
Gabriel
SQL Server 2005 Log Shipping And 3rd Party Tape Backups
May 27, 2008Hello,
I would like to know if anyone has a recommended method for having backups to tape while running log shipping. For example, is it possible to copy the transaction log backups used for log shipping to tape and apply them to a Full Database Restore from a 3rd Party Backup tool such as Veritas?
My goal is to be able to do a point-in-time restore from tape and still be able to use SQL Server 2005 Log Shipping.
Thanks,
Erik
Connecting To Local SQL Server With Third Party Software (EMS Data Export)
Jun 19, 2006Hi all,
I'm currently running a SQL Server 2005 setup (or so I believe) to use Windows Authentication. When I load Management Studio, the following popup box appears:
Server Type (greyed out): Database Engine
Server Name: Thor
Authentication: Wndows Authentication
U/N and P/W: greyed out
I can connect to my databases using PHP by specifying 'Thor' as my DB host, the DB name and then the username and password of a user I created.
The problem is that I cannot connect to my local server using EMS Data Export 2005 for SQL Server. I can use it to connect to a remote SQL DB on our web server but if I try to connect locally, it generates an error saying that the 'SQL Server does not exist or access denied'.
Does anyone have any experience with connecting to a local SQL server? I'm assuming that I need to setup my server to allow for external connections or something but I'm in the dark on the matter.
Any help would be very appreciated!
Thanks.
Transact SQL :: How To Display Data Party Name And Time Interval Wise In Server
Sep 9, 2015i want to show data Party Name and Time interval wise. here is my table from where i will fetch data. so pasting table data here.
Call start Call duration Ring duration Direction Is_Internal Continuation Party1Name Park_Time
------------------------- ---------------- ------------- --------- ----------- ------------ --------------- -----------
2015/06/08 08:06:08 00:02:28 2 I 0 0 Emily 0
2015/06/08 08:16:38 00:00:21 0 I 0 1 Line 2.0 0
2015/06/08 08:16:38 00:04:13 5 I 0 0 Jen 0
[code]...
now i am not being able to cross join this CTE with my table to get data party name wise and time interval wise. say for if no data exist for a specific time interval then it will show 0 but each party name should repeat for time interval 9:00:00 - 9:30:00 upto 17:30:00. i like to add what filter need to apply to get data for incoming, outgoing, call transfer and miss call.
For Incoming data calculation
where direction='I' and
Is_Internal=0 and continuation=0 and
RIGHT(convert(varchar,[call duration]),8)<> '00:00:00'
For outgoing data calculation
[code]...
MS SQL Server Is Good With ...?
Feb 13, 2004Hi,
I'm about 6 weeks into SQL and SQL Server (7) - I was wondering whether you could share your opinions about which language to use as a programming tool for developing apps for & with SQL Server. I'm choosing between C++ (Visual) or JAVA.
I already know C and the DB-Libe contains a lot of it but I'm kinda trying to expand some horizons. I'm ok with either C++/VC++ or JAVA but I only have time to learn (or be good at) one.
Any suggestions? (I'd like to hear what you think even if you say neither C++ or JAVA - maybe VB? What's easy and marketable is what matters most.)
Thanks.
To Have No FAT Partition - Good Or Bad For Server?
Jan 21, 1999Hi!
I'm installing a new SQL Server machine. During NT Server
installation our NT support guy converted the only 2GB FAT
C: partition to NTFS. So as of right now all my 4 8GB drives are
NTFS. I think it would be better to keep this C: partition in FAT
because, as of my knowledge, having FAT boot partition can help
to boot the machine in case of NT crash.
Is there anything that I'm really losing by this conversion to NTFS or I
should not be worried so much about it? Does it put my SQL Server
databases, database .dat files or NT Server in more danger situation
in case of any crash?
Or it's giving me some advantages?
Thanks
Ninel
Good SQL Server Books
Sep 26, 2006Can anyone make some good book recommendations for SQLServer2000 other than the Microsoft BOL?
Thanks
Which Is A Good SQL Server Editor
Aug 2, 2005Hi,I am looking for a good SQL Server Editor which can be used forwritting stored procedures, doing queries etc. It should have featureslike autocomplete and so on. Any recommendations.Thanks !
View 4 Replies View RelatedGood Ebooks On SQL Server Please
Mar 10, 2007Suggest some beginner books for SQL server.
View 1 Replies View RelatedAsp.net Confgiguration Tool. Tool Keeps Timing Out
Mar 2, 2006is it possible to change the settings on this tool. i want to have it so that it does not time out at all? or is that possible??
View 1 Replies View RelatedGood Books On SQL Server 2005
Feb 22, 2008Can you guys pls suggest Good books on SQL Server 2005 ??
Thx
Sql Server To MSDE - Good Choice?
Jul 20, 2005Hi - I have a rather unreliable host just now - but they offer .net, sqlserver and SSL for a reasonable price.Problem is, the domain is hosted on a shared server - and it keeps goingdown apparantly because of code which is less than clean, on somepeoples sites. (ie. not closing connections etc).I am considering moving to a decicated server - but at this point intime, cannot afford a full SQL Server licence for it - however, thededicated server does offer MSDE. Is it acceptable to go back to usingthis from SQL Server - for a currently low hit site - ie. around 500hits per day.Does MSDE offer stored procedures (I don't use views or triggers)? CanI just take a DTC backup/export of my current SQL Server database, andrestore it to the MSDE one?What would be the cut-off point for using MSDE?Thanks for any info - also, if anyone knows why UK companies charge somuch more dor dedicated servers, than US companies - I'd be interested.Thanks, Mark*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View 2 Replies View RelatedWindows OS Good For SQL Server Performance
Apr 11, 2008
Hello,
I need to choose the OS, for my SQL Server Database where performance is important and will be used on a regular basis of two hours.
Should we go for 32 bit or 64 bit processor?
How much RAM should be used 2 or 4GB ?
Should we use SAN, RAID or local disk , which one of them and why?
I need to tell the owner by Monday.
thanks,
Priyanka
Any Good Books For SQL Server 2000 Administration ???
Jun 5, 2003Hi,
I am an Oracle DBA with over 7 yrs of experience.I am new to sql server 2000 and am given the responsibility of sql server 2000 production databases in a few weeks.I already have the sql server 2000 DBA survival guide.
I would like to know if there are any good books out there for
a)backup and recovery
b)General DBA tasks
c)Performance tuning.
Thanks,
Copernicus
Any Good SQL Server Intermediate Training Courses?
Mar 9, 2004Quick question. I am in the NYC area (Westchester) and I am using Cognos DecisionStream to build my SQL Server 2000 Enterprise Data Warehouse.
I want to learn more about complex SQL, specifically for SQL Server.
What do you reccommend? Should I go for strictly an advanced SQL course, or should I go for SQL Server training.
Does anyone know of a really good site where I can find Advanced SQL training?
Also, I want to learn more about scripting and VB. Can anyone reccommend a place where I can get this beginner training.
Sorry to take up your time, but to sum up:
1. Advanced SQL training in NYC area
2. Beginner VB training in NYC area.
Cost is not necessarily an issue.
Thanks!