Favorite Sql Server Db Compare/diff Tools

Dec 15, 2003

guys...do you have any recommendations for a tool that compares specific MS sql databases including data comparisons?





I typically develop locally, then deploy remotely.





it's getting to be quite a pain to not only remember which schema objects to update on the remote host, but the data elements that need to be keyed in as well.





are there any shareware tools out there you'd recommend? (I don't have a great budget as this is coming out of MY pocket and not my companies.)





THanks!

View 1 Replies


ADVERTISEMENT

Favorite Monitoring (Performance) Tools?

Apr 25, 2007

I'm fairly new to the DBA thing.
I've been doing quite a bit of research on monitoring MSSQL performance.

What tools are you guys using?
PerfMon, Dbartisan, Spotlight, or what?

I'd like to find some free or affordable way to watch our Servers to check health/performance/etc.

View 2 Replies View Related

Anyone Compare The Differences BTN DIFF SQL

Dec 6, 2005

HEY,
CAN YOU TELL ME THE DIFFERENCES BETWEEN VARIOUS SQL

View 2 Replies View Related

SQL 2012 :: Schema Compare Tools

Jun 30, 2015

Following an upgrade to SQL Server 2012, our shop's Schema Compare tool (Redgate SQL Compare) is no longer supporting our environment.We are starting to evaluate various 3rd party products to find a possible replacement, and would be interested in what products are favored by other IT shops who do a lot of database work.

Our shop is split about 75% SQL Server, 20% Oracle, and 5% I'll call other. Ideally a product would support SQL Server and Oracle, but our focus is on SQL server right now. On that platform we have ~50 servers spread across DevUATProd environments.In basic terms, we need a tool that can identify schema differences between DBs and generate synchronization scripts to support deploys between environments. Real-time synchronization is not a requirement (nor desirable), as deploys are a gated DBA function in our shop.

View 2 Replies View Related

SQL Tools :: Compare Two Text Files?

Mar 13, 2006

What software can compare two text files? They are contains about 100k data generated from Visual Basic 6.0 program and MS SQL 2000. I have many files to compare daily.

View 11 Replies View Related

Select Data From Diff. Tables On Diff. Servers

Feb 12, 1999

I need to write a 'select' statement to fetch data from different tables, which are located on different servers.
Can any one help in writing this 'select' statement with out moving the tables on to same server.


Thanks in Advance.

Murali Raparla.

View 2 Replies View Related

Favorite SQL Forum Sites

Jan 25, 2008

What are your favorite Forum sites?


SQLTeam.com
SQLSERVERCENTRAL.com
TekTips.com
MSDNSQL Forum
forums.sqlmag.com

I hate to ask for information such as this but with the low response to my questions I was wondering anyone knows of a better site for SQL Server database mail issues?

Thanks,
Thom

View 1 Replies View Related

SQL Tools :: How To Disable Customer Improvement Program From Menu For Server MGMT Tools 2012

Mar 25, 2014

Am customizing SQL server MGMT tools 2012 for Mass deployment.Client had asked to remove Customer Feedback option from help menu.how to disable that.

View 6 Replies View Related

Design Tools / Sql Server Mgt Tools Cause Login Fail

Sep 20, 2007

Login failed for user 'TOSHIBA-USERASPNET'
I know that the file persmission for the web application have to include aspnet, so i keep resetting the folder permission for aspnet in file manager, but the login failed keeps coming back every day or two
problem is after working with VS05 Pro, SQL Server Management Studio CTP, somehow the aspnet persmission get changed, use alot of sqldatasource wizards and often there is a conflict/hang between the datasource wizard and the need to have the mdf in a dettached state within VS server explorer,
not sure but the procedure to fix this seems to be to reboot, detach and re-attach the mdf in the Sql server Studio tool, re-apply the aspnet file permission on the web app folders (wonder should i be doing this in IIS instead), make sure the mdf within server explorer is detached, the it works
anyway, getting real tired of the resulting delays and design time derailment, clues greatly appreciated, thanks
 sometimes i can use View in Browser when in VS05 form view and i wont get the aspnet folder permission error and other times i do.
last thing, is it a bad idea to give aspnet full permission for the entire web applicaiton??
 

View 2 Replies View Related

Server Tools Or Client Tools?

Jun 16, 2008

Dear All,
how can we know that wether we had server tools or client tools on my machine?

Arnav
Even you learn 1%, Learn it with 100% confidence.

View 1 Replies View Related

Possible To Move Array To Diff Server?

Jun 11, 2008

My main sql server lost the system board due to overheating. I need to get the (external enclosure scsi attached)array up and running as it has production data as well as SQL backups stored there. My most recent/valid backups are located with the production data. It is possible to connect this array to different server? This is a HP DL380 and all of my other servers are Dell 2900's.

any help is appreciated!

View 1 Replies View Related

Copy Latest Diff Backup From One Server To Another

Oct 9, 2014

SQL Server 2012-SP2 and Windows 2008R2

I need to copy the last differential backup file from the production server directory to a data warehouse server directory. There are 3 differential backup files on the directory and I need to grab the latest one. I have the following syntax which work from a batch file but it does not work when I put it into a job step as a cmd even though I remove the double %% to only one %.

echo @off
set path1="192.29.305.213$SqlserverProductionBa ckupsKBR_PROD"
set path2=K:SqlserverDatawarehouseBackupPROD
for /f "tokens=*" %%a in ('dir /b /a-d /o-d "%path1%DIFF*.bak"') do copy "%path1%\%%~a" "%path2%" & goto nextstep
:nextstep
Echo File Copied.

Even when I change it to (only one % for the variable),

for /f "tokens=*" %a in ('dir /b /a-d /o-d "%path1%DIFF*.bak"') do copy "%path1%\%~a" "%path2%"

It does not work..........It runs successfully but no file is copied or I get

Message
Executed as user: PROD23Sqladm024. The process could not be created for step 1 of job 0xEAAF943771FF304A9E7AD8ADAC24F96C (reason: The system cannot find the file specified). The step failed.

I know that the file is there. It works with batch file. Poweshell script can be OK. No SSIS - Not installed

View 6 Replies View Related

SQL Tools :: R2 Management Tools Install Fails - Specified Account Already Exists

Oct 20, 2014

The installation SQL 2008 R2 Management Tools on a Windows 7 workstation fails with the error, The specified account already exists.

Final result: SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.

  Exit code (Decimal):           -2068052700
  Exit facility code:            1212
  Exit error code:               1316
 
[code]...

View 10 Replies View Related

Backup Strategy - SQL2005 Tools Versus 3rd Party Tools

Jun 1, 2007

I am running SQL Server 2005 x64 Enterprise under Windows 2003 x64 Enterprise. My current backup strategy uses T-SQL jobs run by SQL Agent (writes out *.bak files) and then I have an Integration Services job that copies the *.bak files to our NAS device. I have performed a restore without issue. The jobs are all automated every four hours via SQL Agent. Is this a sound strategy or are there additional benefits to using 3rd party tools? If so, what are the advantages and which tool provides them?

View 3 Replies View Related

Routing To Diff Instance Of SQL Server On Same Server

Aug 4, 2006

Remus,

thank you for your reply on (microsoft.public.sqlserver.notificationsvcs).

one more question :

Server_2 == Server_3

so I set up a route for db2:

CREATE ROUTE [rem_s2_route] AUTHORIZATION [dbo] WITH SERVICE_NAME = N'rem_s2' , ADDRESS = N'TCP://192.168.0.2:4022'

to create route for db3 (sql express) I tried

CREATE ROUTE [rem_s3_route] AUTHORIZATION [dbo] WITH SERVICE_NAME = N'rem_s3' , ADDRESS = N'TCP://192.168.0.2sqlexpress:4022'

this failed, what am I doing wrong or did I lost the plot? How do I diff beteen more than one instance of sql server on the same server? And can the port be the same on each instance of SQL Server?

thank you in advance

View 1 Replies View Related

Diff Datatypes Used Doubt Int And Bigint ........SQL SERVER 2005......Any Useful Links ??

Jun 12, 2007

 Hello Frdz,                I have doubt regarding the datatypes fields used in  SQL SERVER 2005.The value for bigint Int64 is 18The value of int Int32 is 9/10Now,if in int i write : 1234567890 (accepted)This gives error     :  9874565656 (not accepted..........why is it so      ???     )Why is it so ??I want to know the perfect size of all the datatypes used in SQLSERVER 2005.There are also smallint,tinyint.....What's the main difference with all of them ??Can anyone provide me the nice links which can explain me what m i asking in this post...Please help me....I want to know all the datatypes used differences...   

View 6 Replies View Related

SQL Server 2012 :: Stored Proc Execution Time Diff Between Environments

Jul 3, 2015

I have a stored proc that is executing in 2 sec on production and test database. It is taking more than a min on dev environment.

I have verified sqlserver version is same on both of the server.Prod is running on 2012Sp1 however dev don't have sp1. I am downloading it.

Both are 64bit, has same collation and compatibility level.I have confirmed that sp on both servers has same execution plan. I have reset and import stats from prod too.

View 8 Replies View Related

SQL Tools :: Tools To Determine Version From BAK File

Apr 24, 2014

Is there - apart from the notorious RESTORE HEADERONLY - an tool which is able to tell which SQL Server version created a specific BAK file? I'm looking for a tool that can be used w/o an available/running SQL Server installation.

Alternatively, is there any documentation about what is read with RESTORE HEADERONLY so I could write a tool myself?

Where would I find the version "bytes" in a BAK file?

View 4 Replies View Related

Tools Tools Tools For Performance ???

May 16, 2002

Know any good performance monitoring and analysis tools for SQL server.

View 1 Replies View Related

Tools For SQL Server

Dec 14, 2005

I'm a newbie in working with SQL Server. Can anybody prompt me some good tools for SQL Server administration and other useful tools for Microsoft SQL Server???

View 5 Replies View Related

SQL Server Compact Edition Server Tools Setup Error On Vista

Oct 21, 2007

SQL Server 2005 SP2 Replication


I am having problems installing the SQL Server Compact Server Tools on my
Vista laptop to allow me to connect my Mobile Device running SQL Server
Compact directly to my SQL Server 2005 database through IIS.


I have done this successfully with an XP machine so I'm not sure if it is
Vista problem or not.


I have installed SQL Server 2005 SP2. When I try to install the replication
server tools (Sqlce30setupen.msi), in "System Configuration Check" window I get a failure on "SQL Server requirement" that says: "You must first install the Replication Components for SQL Server 2000 SP 3a
or higher or the SQL Server 2005 Replication Components" and the client components are full instaled in my computer.



I need help for detect and correct the problem.


Sincereously,
Alonso Junior

View 4 Replies View Related

Using SQL Server Management Studio Tools To Manage Dbs On SQL Server Express Edition

Apr 25, 2008

Hopefully a simple question: Is it possible to use Maintenance Plans created on SQL Server Management Studio (installed as part of an instance of SQL Server 2005 Standard Ed.) to back up databases running on an instance of SQL Server Express Edition with Advanced Services? I don't need directions, just whether or not it is permitted.

I've been able to create the plans including establishing connections to from SSMS to the the SQL Express instance, but they keep erroring out. I just need to know if this is actually permitted since Maintenance Plans are not available on Management Studio Express Edition.

Thank you in advance for your help.

View 7 Replies View Related

Which SQL Server 2005 Compact Edition Server Tools Installation Package Do I Use?

May 26, 2007

Hi,



I am using SQL Express 2005 server and sql compact edition for my PDA. For synchronization, which SQL Server 2005 Compact Edition Server Tools installation package do I use?



Is it Sqlce30setupen.msi or sql2kensp4.msi or sql2kensp3a.msi? I know for sql server 2005 its Sqlce30setupen.msi. Is it the same for the SQL Express 2005?



Thanks

View 4 Replies View Related

SQL Server 2005 Client Tools Not Shown Up In Start Menu On Windows 2003 Server

Jul 18, 2007

Hello,



I have installed SQL server 2005 enterprise edition on Windows 2003 virtual PC (full installation). The installation went through successfully. However, after install completed, I cannot find any of the client tools under the start menu -> all programs -> Microsoft SQL server 2005 menu. The only item listed under the SQL server 2005 is Configuration Tools, which is used to configure the database server.



I have tried to install the client component again (in case I didn't install them at the first place) but the installation process cannot be started since it detected that the client components have been installed already. I can also see the sql server native client running in the services.



The server engine is working fine since I can connect to that sql server using another machine where I have the client tool (SQL server management studio).



One of my friends has exactly the same problem. He installed the sql server 2005 Standard edition on windows 2003 server (full installation), but the client tools are not showing up in the start menu either.



I also checked the location for the SQL server management studio (Microsoft SQL server/90/Tools/Binn/VSShell/Common7/IDE), there is only one folder called publicAssemblies listed under. Is this correct or something is missing?



Thanks

View 11 Replies View Related

MSDE && SQL Server 2005 Mobile Server Tools Problem

Jan 24, 2006

After installing MSDE(with SP4) and SQL Server 2000 SP4 Replication Components, the SQL Server 2005 Mobile Server Tools installation fails when running the System Configuration Check with a SQL Server requirement Error.

"You must first install the Replication Components for SQL Server 2000 SP 3a or higher or the SQL Server 2005 Replication Components"

Am I getting this error because I'm using the Desktop Engine version of the SQL Server 2000??

View 7 Replies View Related

Server Monitoring Tools

Jun 14, 2000

I want to know if there are any tools that will allow
a DBA to monitor changes that occur on SQL databases
(deletion, addittion or modifications) on any objects,
and Sql security.

I have looked at Profiler in SQL and it is very limited
and plus it is huge memory hog and causes degradation on
your servers.

View 2 Replies View Related

MS SQL Server Monitoring Tools

Feb 19, 2004

We've got about fifty MSSQL Servers (7.0 and 2000) in our shop.
Can anybody recommend a good tool to monitor all kind of activities and conditions on those servers?

View 1 Replies View Related

SQL Server Tools Information

May 29, 2005

Hi to all Friends,
Now a days i have a query regarding SQL Server deployment.Is it possible that on our client side we not install enterprise manager due to some managerial problems.Because we are feeling that using enterprise manager our database design is not save and somebody can copy it.Please help me on this issue.
Thanks

View 4 Replies View Related

What Tools Should Developers Use For SQL Server?

Jun 13, 2007

This may be an intuitively obvious question, and if so, I apologize.

Speaking in terms of best practices here, what is the preferred method for allowing developers to work with databases in SQL Server? If they use Management Studio, then they have access to tools for perhaps messing with other databases, etc. that they should not (assuming it is not correctly secured). Likewise with Enterprise Manager. I can see where they would use Query Analyzer, but these two are now combined in Management Studio.

I'm just inquiring into how other DBA's do this. I realize there are DBA's that are developers and vice-versa, but what if there is a clear line of distinction and you want to keep the tools used in these roles separate?

Thanks in advance.

Kevin

View 3 Replies View Related

Idera SQL Server Tools

Jan 11, 2008

Opinions on Idera??

A rep from Idera came to pitch Idera SQL Server tools.
My boss is mostly interested in SOX compliance auditing for
relatively few servers.

We have some interest in performance monitoring.

I am mostly interested in a centralized configuration database
to manage 50 or so instances of SQL Server, both SQL 2000 and 2005.

Have you tried Idera?
Like?
Like something else better?

View 1 Replies View Related

SQL Server 2000/05 Tools??

Mar 18, 2008

I am looking for best blogs/articles on Debugging, performance for SQL server 2000/2005.

Please provide me links

View 1 Replies View Related

SQL Server Client Tools

Jan 28, 2006

HiHow network administartor can find , who has AQL server client tools onhis system?Thanks

View 2 Replies View Related

Preferred SQL Tools For Sql*server?

Jul 20, 2005

Hi All,I am new this week to sql*server / query analyzer, coming from yearsof an oracle / TOAD background. Does anyone have any tools theyprefer for writing and executing sql code other than query analyzer?Thanks!Mike

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved