Database Discussion Boards

Re: Export data in SQL 2008

Richard Deeming11-Jul-13 10:40

11-Jul-13 10:40

Is there a carriage-return or line break embedded in the field?

If you can isolate one of the affected rows, try dumping the characters from the affected field:

SQL

DECLARE @FieldValue varchar(100);
SELECT @FieldValue = AffectedField FROM AffectedTable WHERE Key = @AffectedKey;

WITH E1(N) AS
(
    SELECT 1 
    UNION ALL SELECT 1 
    UNION ALL SELECT 1 
    UNION ALL SELECT 1
    UNION ALL SELECT 1 
    UNION ALL SELECT 1
    UNION ALL SELECT 1 
    UNION ALL SELECT 1 
    UNION ALL SELECT 1
    UNION ALL SELECT 1
),
cteNumbers (N) As
(
    SELECT
        ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) 
    FROM 
        E1 a, E1 b -- Cross-join = 100 rows
)
SELECT TOP(LEN(@FieldValue))
    N,
    Ascii(Substring(@FieldValue, N, 1)) As AsciiCode,
    Substring(@FieldValue, N, 1) As Character
FROM
    cteNumbers
ORDER BY
    N
;

You're looking for either a 10 or a 13 in the AsciiCode column.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

bcp command in sql 2008

vkEE11-Jul-13 6:45

vkEE

11-Jul-13 6:45

Hi,

What is wrong with this syntax?

I have used this so many times in sql 2005. Kind of new to sql 2008.
===
bcp "Select * From Webs.About" queryout mytest.dat -T -c
===

the error message is
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'queryout'.

Re: bcp command in sql 2008

NickPace11-Jul-13 7:10

NickPace

11-Jul-13 7:10

Not sure if this is it, but try enclosing mytest.dat in quotation marks. Otherwise, it looks like it should work to me.

-NP

Never underestimate the creativity of the end-user.

Re: bcp command in sql 2008

NickPace11-Jul-13 7:24

NickPace

11-Jul-13 7:24

Also, make sure you are running the bcp utility from the command prompt. I think if you try running it from a new query window within SMS that is exactly the error you will get. I'm pretty sure the quotation marks I mentioned in my previous post won't help unless the file name has a space in it.

-NP

Never underestimate the creativity of the end-user.

Re: bcp command in sql 2008

vkEE11-Jul-13 8:07

vkEE

11-Jul-13 8:07

How can I ran this through a new query window in SQL?

Using xp_cmdshell?

Thanks!!

Re: bcp command in sql 2008

NickPace11-Jul-13 9:23

NickPace

11-Jul-13 9:23

Sure, you can use xp_cmdshell to run a bcp command from a query window. You might have to first turn on the ability for SSMS to use a Windows command shell as it is usually off by default. If needed, run the following commands first:

EXEC sp_configure 'show advanced options', 1
RECONFIGURE
EXEC sp_configure 'xp_cmdshell', 1
RECONFIGURE

Then run your xp_cmdshell using: EXEC xp_cmdshell '(your bcp command here)'

If needed, turn back off the ability to use Windows command shell with:

EXEC sp_configure 'xp_cmdshell', 0
RECONFIGURE
EXEC sp_configure 'show advanced options', 0
RECONFIGURE

-NP

Never underestimate the creativity of the end-user.

What will be the connection string --- Please read the entire question first

Biplob Singha Shee11-Jul-13 3:04

Biplob Singha Shee

11-Jul-13 3:04

Hi all,

I have posted the same question some time ago... but I didn't get any solution. Please read below first...

I want to connect a MySql Database.

Suppose.....

Database Name is mydb
Database located on PC-1 (IP- 192.168.0.10)
PC-1 user id = abc
PC-1 password= 123
MySQL Server user ID = root
MySQL Server password= mypassword

now what will be the connection string for PC-1 to connect to the database ?

now I want to connect the database(mydb) from another pc (suppose this pc name is PC-2 and the IP is 192.168.0.11)

what will be the connection string for PC-2 to connect the PC-1 database ?

I searched connectionstrings.com[^] and found ...
Standard

SQL

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

and
Specifying TCP port

SQL

Server=myServerAddress;Port=1234;Database=myDataBase;Uid=myUsername;
Pwd=myPassword;

but nowhere found if the server pc (PC-1) is protected by user id and password. In this case what should I do ?

I Tried both the above connection string. They are Ok for PC-1 to connect its own database (localhost) but when I tried to connect the database from PC-2, I got the error

Quote:
Host '192.168.0.11' is not allowed to
connect to this server

<big>Can anybody help me ?</big>

Re: What will be the connection string --- Please read the entire question first

Eddy Vluggen11-Jul-13 5:02

Eddy Vluggen

11-Jul-13 5:02

Biplob Singha Shee wrote:
Can anybody help me ?

Reposting your question isn't going to help.

Biplob Singha Shee wrote:
Please read the entire question first

I did. Twice. The answer "I cannot do that" doesn't mean that the answer you have been given was incorrect. You could have asked how to find the path. I'd answer that you can search your entire HD. By hand.

Most (professional) databases do not allow making remote connections in a default install. It's a security-thing. You cannot change that using a connection-string.

The fact that you're using XAMP simply means that the config-files are in another location than the default MySQL path. You'd have to find the file yourself, make the change to allow remote connections, and restart the server.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Re: What will be the connection string --- Please read the entire question first

jschell11-Jul-13 9:08

jschell

11-Jul-13 9:08

Open a command window on the CLIENT machine - NOT the database machine.

Verify that you have telnet.
Run telnet use the following command.

telnet 192.168.0.11 1234

There are two results to the above. First it succeeds which means it presents a blank screen (command window) or it returns an error message either quickly or after a couple of minutes.

Note carefully unless the above succeeds NOTHING you do with a connection string will EVER succeed at working.

If the above fails then you must look to something besides your application for a solution. Some POSSIBLE but not a complete list are the following
- The database is not set up to accept remote connections.
- The database is using a different port.
- The host name\ip address is wrong.
- there is a firewall that is preventing the connection.
- There is no possible network path from the client machine to the database machine.

Connection String of a MySql Database from another computer via LAN

Biplob Singha Shee11-Jul-13 0:53

Biplob Singha Shee

11-Jul-13 0:53

Hi all,

I want to connect a MySql Database.

Suppose.....

Database Name is mydb
Database located on PC-1 (IP- 192.168.0.10)
PC-1 user id = abc
PC-1 password= 123
MySQL Server user ID = root
MySQL Server password= mypassword

now what will be the connection string for PC-1 to connect to the database ?

now I want to connect the database(mydb) from another pc (suppose this pc name is PC-2 and the IP is 192.168.0.11)

what will be the connection string for PC-2 to connect the PC-1 database ?

I searched connectionstrings.com[^] and found ...
Standard

SQL

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

and
Specifying TCP port

SQL

Server=myServerAddress;Port=1234;Database=myDataBase;Uid=myUsername;
Pwd=myPassword;

modified 11-Jul-13 7:12am.

Re: Connection String of a MySql Database from another computer via LAN

Garth J Lancaster11-Jul-13 1:13

Garth J Lancaster

11-Jul-13 1:13

well, you dont say what platform you're running MySQL on, but this would be a start

http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html[^]

'g'

Re: Connection String of a MySql Database from another computer via LAN

Biplob Singha Shee11-Jul-13 1:29

Biplob Singha Shee

11-Jul-13 1:29

Hi, thank you for your reply.

For your information I am using Windows 7 Ultimate and I am coding in VB.NET 2010.

I checked the link but I can not understand what they are saying... maybe it is because for other platform they are saying about...

Re: Connection String of a MySql Database from another computer via LAN

Garth J Lancaster11-Jul-13 1:44

Garth J Lancaster

11-Jul-13 1:44

well, Im pretty sure you're a smart guy and you can google for

MYSQL Windows Connection

for example, and get a result .. this came up pretty quickly for example >> http://richbui.com/2009/03/06/how-to-enable-remote-access-to-mysql-server-on-windows-server/[^]

Re: Connection String of a MySql Database from another computer via LAN

Biplob Singha Shee11-Jul-13 1:51

Biplob Singha Shee

11-Jul-13 1:51

I tried on google but found many results except mine.

Re: Connection String of a MySql Database from another computer via LAN

Garth J Lancaster11-Jul-13 1:55

Garth J Lancaster

11-Jul-13 1:55

was the link I posted any good ?

Re: Connection String of a MySql Database from another computer via LAN

Biplob Singha Shee11-Jul-13 2:01

Biplob Singha Shee

11-Jul-13 2:01

yes but I cannot do that or I cannot find mysql directory as I am using xampp server(phpmyadmin) and mysql workbench

database

Member 1015018110-Jul-13 18:13

Member 10150181

10-Jul-13 18:13

hello, i m at just start to learn SQL..
plz give me guidance from which references i should proceeed! Smile | :)

Re: database

Mycroft Holmes10-Jul-13 18:25

Mycroft Holmes

10-Jul-13 18:25

Are you learning it fomr a development POV or as a potential DBA, they are 2 VERY different things.

For development I would.
Buy a beginner book on database design and work through the examples and then

Do a search here and on SQLSErverCentral.com for articles on TSQL.

Never underestimate the power of human stupidity
RAH

Re: database

RedDk12-Jul-13 11:40

RedDk

12-Jul-13 11:40

Here's what I did to learn TSQL. I first downloaded and installed SQL Server 2008 Express R2 with Advanced Services. At that time I also downloaded the "Books-on-Line" help volume for that inastallation; typically available on the same webpage as the SQL Server Express Edition mentioned above, here-after refered to as the "BOL".

Then, I went to codeplex and searched on the term "Adventure Works". The return was a dozen or so flavors of downloadable material available right there at codeplex. Downloading ALL of them, and then installing them on top of the new Express installation you've successfully just gone through results in only a few mixups when referenceing example code from within the BOL. And that's the key.

The BOL maintains verbose example for practically everything you can do with SQL Server. Including codeplex's Adventure Works examples.

The whole process, downloading, making sure you've got ALL the databases, then installing everything (loads of fun itself), is SO easy that not doing this and instead refering to some hardcopy volume by some third-party entrepreneur shipped with a dinky little disc of samples makes little sense.

I guarantee you'll be TSQL coding in no time!

And by the way, this BOL IS a HELP FACILILTY OF THE OLD KIND ... Guaranteed to be able to find what you're looking for because there's a list of everything in the left-hand margin. You do know A comes before B which comes before C ... in the alphabet, correct?

Re: database

berrymaria16-Jul-13 16:33

berrymaria

16-Jul-13 16:33

Read this articles:

http://www.tutorialspoint.com/sql/sql_tutorial.pdf
http://www.epa.gov/ttn/airs/airsaqs/training/SQL%20Basics.pdf
http://web.ing.puc.cl/~jlortiz/Teach_Yourself_SQL_in_21_days_FULL.pdf

SSDT Install fail

dharmaa.m10-Jul-13 2:41

dharmaa.m

10-Jul-13 2:41

hi ,My Friends.

I have a Problem.

I want use SqlLocalDb in visual studio 2010.

so ,First I've installed Service Pack 1

But, in the installation error will SSDT.

Please Help To Me...

Thank You

log file:

[0968:172C][2013-07-10T16:13:46]: Burn v3.6.3102.0, Windows v6.1 (Build 7601: Service Pack 1), path: F:\Program\Requir LocalDB for vs2010 sqlserver 2008\SSDTSetup.exe, cmdline: '-burn.unelevated BurnPipe.{0B1A00CA-5F8B-4CAD-A9EA-6EF11980E132} {BCC4059B-8D8F-4329-AB4D-0F7610119BAF} 2512'
[0968:172C][2013-07-10T16:13:46]: Initializing numeric variable 'InstallLanguage' to value '1033'
[0968:172C][2013-07-10T16:13:46]: Setting string variable 'WixBundleLog' to value 'C:\Users\Pars\AppData\Local\Temp\sql_SSDT_1000_20130710161346.log'
[0968:172C][2013-07-10T16:13:46]: Setting string variable 'WixBundleOriginalSource' to value 'F:\Program\Requir LocalDB for vs2010 sqlserver 2008\SSDTSetup.exe'
[0968:172C][2013-07-10T16:13:46]: Setting string variable 'WixBundleName' to value 'Microsoft SQL Server Data Tools 2010'
[0968:172C][2013-07-10T16:13:46]: Detect 21 packages
[0968:172C][2013-07-10T16:13:46]: Setting string variable 'dotnetfx4setupexe_x64_DetectKey' to value '4.0.30319'
[0968:172C][2013-07-10T16:13:46]: Setting numeric variable 'dotnetfx4setupexe_x64_DetectKeyExists' to value 1
[0968:172C][2013-07-10T16:13:46]: Setting string variable 'dotnetfx4setupexe_x86_DetectKey' to value '4.0.30319'
[0968:172C][2013-07-10T16:13:46]: Setting numeric variable 'dotnetfx4setupexe_x86_DetectKeyExists' to value 1
[0968:172C][2013-07-10T16:13:46]: Registry key not found. Key = 'SOFTWARE\Microsoft\DevDiv\VS\Servicing\10.0\IntShell\1033'
[0968:172C][2013-07-10T16:13:46]: Setting numeric variable 'KB2468871V2_DetectKeyExists' to value 1
[0968:172C][2013-07-10T16:13:46]: Setting numeric variable 'KB2544514_DetectKeyExists' to value 1
[0968:172C][2013-07-10T16:13:46]: Setting numeric variable 'localDBInstall_x64_DetectKeyExists' to value 1
[0968:172C][2013-07-10T16:13:46]: Registry key not found. Key = 'SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11E.LOCALDB'
[0968:172C][2013-07-10T16:13:46]: Setting numeric variable 'localDBInstall_x86_DetectKeyExists' to value 0
[0968:172C][2013-07-10T16:13:46]: Registry key not found. Key = 'SOFTWARE\Microsoft\DevDiv\vs\Servicing\10.0\procore\'
[0968:172C][2013-07-10T16:13:46]: Registry key not found. Key = 'SOFTWARE\Microsoft\DevDiv\vs\Servicing\10.0\procore\1033'
[0968:172C][2013-07-10T16:13:46]: Registry key not found. Key = 'SOFTWARE\Microsoft\SSDT\1.0\'
[0968:172C][2013-07-10T16:13:46]: Setting numeric variable 'vs2010sp1Install_DetectKeyExists' to value 1
[0968:172C][2013-07-10T16:13:46]: Registry key not found. Key = 'SOFTWARE\Microsoft\DevDiv\vs\Servicing\10.0\vstdcore\'
[0968:172C][2013-07-10T16:13:46]: Registry key not found. Key = 'SOFTWARE\Microsoft\DevDiv\vs\Servicing\10.0\vstdcore\1033'
[0968:172C][2013-07-10T16:13:46]: Setting string variable 'vstscore_DetectKey' to value '1'
[0968:172C][2013-07-10T16:13:46]: Setting string variable 'vstscore1033_DetectKey' to value '1'
[0968:172C][2013-07-10T16:13:46]: Setting numeric variable 'BootstrapperAction' to value 4
[0968:172C][2013-07-10T16:13:46]: Condition '((1 <> 1) OR ((vstscore1033_DetectKey = 1)) OR ((vstdcore1033_DetectKey = 1)) OR ((procore1033_DetectKey = 1)) OR ((NOT((1 <> 1) OR ( (vstscore_DetectKey = 1)) OR ( (vstdcore_DetectKey = 1)) OR ( (procore_DetectKey = 1))))))' evaluates to true.
[0968:172C][2013-07-10T16:13:46]: Condition '(NOT(RegSearch_SSDTCTP3Exists = v10.1.10712.0))' evaluates to true.
[0968:172C][2013-07-10T16:13:46]: Condition '((VersionNT = v6.0 AND ServicePackLevel >= 2) OR (VersionNT = v6.1 AND ServicePackLevel >= 1) OR (VersionNT > v6.1))' evaluates to true.
[0968:172C][2013-07-10T16:13:46]: Condition '(dotnetfx4setupexe_x86_DetectKeyExists AND dotnetfx4setupexe_x86_DetectKey >= v4.0.30319) AND (NOT ((VersionNT64 AND ((VersionNT = v6.0 AND ServicePackLevel >= 2) OR (VersionNT = v6.1 AND ServicePackLevel >= 1) OR (VersionNT > v6.1)))) OR (dotnetfx4setupexe_x64_DetectKeyExists AND dotnetfx4setupexe_x64_DetectKey >= v4.0.30319))' evaluates to true.
[0968:172C][2013-07-10T16:13:46]: Condition '((NOT VersionNT64) AND ((VersionNT = v6.0 AND ServicePackLevel >= 2) OR (VersionNT = v6.1 AND ServicePackLevel >= 1) OR (VersionNT > v6.1))) AND (KB2468871V2_DetectKeyExists)' evaluates to false.
[0968:172C][2013-07-10T16:13:46]: Condition '(VersionNT64 AND ((VersionNT = v6.0 AND ServicePackLevel >= 2) OR (VersionNT = v6.1 AND ServicePackLevel >= 1) OR (VersionNT > v6.1))) AND (KB2468871V2_DetectKeyExists)' evaluates to true.
[0968:172C][2013-07-10T16:13:46]: Condition '(intShellInstall_DetectKey = 1)' evaluates to false.
[0968:172C][2013-07-10T16:13:46]: Condition '(vs2010sp1Install_DetectKeyExists) AND ((intShellInstall_DetectKey = 1) OR (1 <> 1) OR ( (vstscore_DetectKey = 1)) OR ( (vstdcore_DetectKey = 1)) OR ( (procore_DetectKey = 1)))' evaluates to true.
[0968:172C][2013-07-10T16:13:46]: Condition '(KB2544514_DetectKeyExists)' evaluates to true.
[0968:172C][2013-07-10T16:13:46]: Detected package: NETFX4, state: Present, cached: None
[0968:172C][2013-07-10T16:13:46]: Detected package: KB2468871V2_x86, state: Absent, cached: None
[0968:172C][2013-07-10T16:13:46]: Detected package: KB2468871V2_x64, state: Present, cached: None
[0968:172C][2013-07-10T16:13:46]: Detected package: VISUALSTUDIO2010INTEGRATEDRTM, state: Absent, cached: None
[0968:172C][2013-07-10T16:13:46]: Detected package: VISUALSTUDIO2010SP1PATCH, state: Present, cached: None
[0968:172C][2013-07-10T16:13:46]: Detected package: KB2544514, state: Present, cached: None
[0968:172C][2013-07-10T16:13:46]: Detected package: SQLDOM11X86, state: Absent, cached: None
[0968:172C][2013-07-10T16:13:46]: Detected package: SQLDOM11X64, state: Absent, cached: None
[0968:172C][2013-07-10T16:13:46]: Detected package: TSQLLANGSVC11X86, state: Absent, cached: None
[0968:172C][2013-07-10T16:13:46]: Detected package: TSQLLANGSVC11X64, state: Absent, cached: None
[0968:172C][2013-07-10T16:13:46]: Detected package: DACFX11X86, state: Absent, cached: None
[0968:172C][2013-07-10T16:13:46]: Detected package: DACFX11X64, state: Absent, cached: None
[0968:172C][2013-07-10T16:13:46]: Detected package: SQLLOCALDBX86, state: Absent, cached: None
[0968:172C][2013-07-10T16:13:46]: Detected package: SQLLOCALDBX64, state: Present, cached: None
[0968:172C][2013-07-10T16:13:46]: Detected package: SQLCLRTYPES11X86, state: Absent, cached: None
[0968:172C][2013-07-10T16:13:46]: Detected package: SQLCLRTYPES11X64, state: Absent, cached: None
[0968:172C][2013-07-10T16:13:46]: Detected package: SQLSMO11X86, state: Absent, cached: None
[0968:172C][2013-07-10T16:13:46]: Detected package: SQLSMO11X64, state: Absent, cached: None
[0968:172C][2013-07-10T16:13:46]: Detected package: SSDTEXTERNALS10, state: Absent, cached: None
[0968:172C][2013-07-10T16:13:46]: Detected package: SSDTBUILDUTILITIES10, state: Absent, cached: None
[0968:172C][2013-07-10T16:13:46]: Detected package: SSDT10, state: Absent, cached: None
[0968:172C][2013-07-10T16:13:46]: Detect complete, result: 0x0
[0968:172C][2013-07-10T16:20:04]: Plan 21 packages, action: Install
[0968:172C][2013-07-10T16:20:04]: Skipping dependency registration on package with no dependency providers: NETFX4
[0968:172C][2013-07-10T16:20:04]: Condition '((NOT VersionNT64) AND ((VersionNT = v6.0 AND ServicePackLevel >= 2) OR (VersionNT = v6.1 AND ServicePackLevel >= 1) OR (VersionNT > v6.1)))' evaluates to false.
[0968:172C][2013-07-10T16:20:04]: Skipping dependency registration on package with no dependency providers: KB2468871V2_x86
[0968:172C][2013-07-10T16:20:04]: Condition '(VersionNT64 AND ((VersionNT = v6.0 AND ServicePackLevel >= 2) OR (VersionNT = v6.1 AND ServicePackLevel >= 1) OR (VersionNT > v6.1)))' evaluates to true.
[0968:172C][2013-07-10T16:20:04]: Skipping dependency registration on package with no dependency providers: KB2468871V2_x64
[0968:172C][2013-07-10T16:20:04]: Condition '(NOT((1 <> 1) OR ((vstscore1033_DetectKey = 1)) OR ((vstdcore1033_DetectKey = 1)) OR ((procore1033_DetectKey = 1))))' evaluates to false.
[0968:172C][2013-07-10T16:20:04]: Skipping dependency registration on package with no dependency providers: VISUALSTUDIO2010INTEGRATEDRTM
[0968:172C][2013-07-10T16:20:04]: Skipping dependency registration on package with no dependency providers: VISUALSTUDIO2010SP1PATCH
[0968:172C][2013-07-10T16:20:04]: Skipping dependency registration on package with no dependency providers: KB2544514
[0968:172C][2013-07-10T16:20:04]: Condition '((NOT VersionNT64) AND ((VersionNT = v6.0 AND ServicePackLevel >= 2) OR (VersionNT = v6.1 AND ServicePackLevel >= 1) OR (VersionNT > v6.1)))' evaluates to false.
[0968:172C][2013-07-10T16:20:04]: Condition '(VersionNT64 AND ((VersionNT = v6.0 AND ServicePackLevel >= 2) OR (VersionNT = v6.1 AND ServicePackLevel >= 1) OR (VersionNT > v6.1)))' evaluates to true.
[0968:172C][2013-07-10T16:20:04]: Setting string variable 'WixBundleLog_SQLDOM11X64' to value 'C:\Users\Pars\AppData\Local\Temp\sql_SSDT_1000_20130710161346_0_SQLDOM11X64.log'
[0968:172C][2013-07-10T16:20:04]: Condition '((NOT VersionNT64) AND ((VersionNT = v6.0 AND ServicePackLevel >= 2) OR (VersionNT = v6.1 AND ServicePackLevel >= 1) OR (VersionNT > v6.1)))' evaluates to false.
[0968:172C][2013-07-10T16:20:04]: Condition '(VersionNT64 AND ((VersionNT = v6.0 AND ServicePackLevel >= 2) OR (VersionNT = v6.1 AND ServicePackLevel >= 1) OR (VersionNT > v6.1)))' evaluates to true.
[0968:172C][2013-07-10T16:20:04]: Setting string variable 'WixBundleLog_TSQLLANGSVC11X64' to value 'C:\Users\Pars\AppData\Local\Temp\sql_SSDT_1000_20130710161346_1_TSQLLANGSVC11X64.log'
[0968:172C][2013-07-10T16:20:04]: Condition '((VersionNT = v6.0 AND ServicePackLevel >= 2) OR (VersionNT = v6.1 AND ServicePackLevel >= 1) OR (VersionNT > v6.1))' evaluates to true.
[0968:172C][2013-07-10T16:20:04]: Setting string variable 'WixBundleLog_DACFX11X86' to value 'C:\Users\Pars\AppData\Local\Temp\sql_SSDT_1000_20130710161346_2_DACFX11X86.log'
[0968:172C][2013-07-10T16:20:04]: Condition '(VersionNT64 AND ((VersionNT = v6.0 AND ServicePackLevel >= 2) OR (VersionNT = v6.1 AND ServicePackLevel >= 1) OR (VersionNT > v6.1)))' evaluates to true.
[0968:172C][2013-07-10T16:20:04]: Setting string variable 'WixBundleLog_DACFX11X64' to value 'C:\Users\Pars\AppData\Local\Temp\sql_SSDT_1000_20130710161346_3_DACFX11X64.log'
[0968:172C][2013-07-10T16:20:04]: Condition '((NOT VersionNT64) AND ((VersionNT = v6.0 AND ServicePackLevel >= 2) OR (VersionNT = v6.1 AND ServicePackLevel >= 1) OR (VersionNT > v6.1)))' evaluates to false.
[0968:172C][2013-07-10T16:20:04]: Condition '(VersionNT64 AND ((VersionNT = v6.0 AND ServicePackLevel >= 2) OR (VersionNT = v6.1 AND ServicePackLevel >= 1) OR (VersionNT > v6.1)))' evaluates to true.
[0968:172C][2013-07-10T16:20:04]: Condition '((VersionNT = v6.0 AND ServicePackLevel >= 2) OR (VersionNT = v6.1 AND ServicePackLevel >= 1) OR (VersionNT > v6.1))' evaluates to true.
[0968:172C][2013-07-10T16:20:04]: Setting string variable 'WixBundleLog_SQLCLRTYPES11X86' to value 'C:\Users\Pars\AppData\Local\Temp\sql_SSDT_1000_20130710161346_4_SQLCLRTYPES11X86.log'
[0968:172C][2013-07-10T16:20:04]: Condition '(VersionNT64 AND ((VersionNT = v6.0 AND ServicePackLevel >= 2) OR (VersionNT = v6.1 AND ServicePackLevel >= 1) OR (VersionNT > v6.1)))' evaluates to true.
[0968:172C][2013-07-10T16:20:04]: Setting string variable 'WixBundleLog_SQLCLRTYPES11X64' to value 'C:\Users\Pars\AppData\Local\Temp\sql_SSDT_1000_20130710161346_5_SQLCLRTYPES11X64.log'
[0968:172C][2013-07-10T16:20:04]: Condition '((VersionNT = v6.0 AND ServicePackLevel >= 2) OR (VersionNT = v6.1 AND ServicePackLevel >= 1) OR (VersionNT > v6.1))' evaluates to true.
[0968:172C][2013-07-10T16:20:04]: Setting string variable 'WixBundleLog_SQLSMO11X86' to value 'C:\Users\Pars\AppData\Local\Temp\sql_SSDT_1000_20130710161346_6_SQLSMO11X86.log'
[0968:172C][2013-07-10T16:20:04]: Condition '(VersionNT64 AND ((VersionNT = v6.0 AND ServicePackLevel >= 2) OR (VersionNT = v6.1 AND ServicePackLevel >= 1) OR (VersionNT > v6.1)))' evaluates to true.
[0968:172C][2013-07-10T16:20:04]: Setting string variable 'WixBundleLog_SQLSMO11X64' to value 'C:\Users\Pars\AppData\Local\Temp\sql_SSDT_1000_20130710161346_7_SQLSMO11X64.log'
[0968:172C][2013-07-10T16:20:04]: Setting string variable 'WixBundleLog_SSDTEXTERNALS10' to value 'C:\Users\Pars\AppData\Local\Temp\sql_SSDT_1000_20130710161346_8_SSDTEXTERNALS10.log'
[0968:172C][2013-07-10T16:20:04]: Setting string variable 'WixBundleRollbackLog_SSDTBUILDUTILITIES10' to value 'C:\Users\Pars\AppData\Local\Temp\sql_SSDT_1000_20130710161346_9_SSDTBUILDUTILITIES10_rollback.log'
[0968:172C][2013-07-10T16:20:04]: Setting string variable 'WixBundleLog_SSDTBUILDUTILITIES10' to value 'C:\Users\Pars\AppData\Local\Temp\sql_SSDT_1000_20130710161346_9_SSDTBUILDUTILITIES10.log'
[0968:172C][2013-07-10T16:20:04]: Setting string variable 'WixBundleRollbackLog_SSDT10' to value 'C:\Users\Pars\AppData\Local\Temp\sql_SSDT_1000_20130710161346_10_SSDT10_rollback.log'
[0968:172C][2013-07-10T16:20:04]: Setting string variable 'WixBundleLog_SSDT10' to value 'C:\Users\Pars\AppData\Local\Temp\sql_SSDT_1000_20130710161346_10_SSDT10.log'
[0968:172C][2013-07-10T16:20:04]: Planned package: NETFX4, state: Present, default requested: Present, ba requested: None, execute: None, rollback: None, cache: No, uncache: No, dependency: None
[0968:172C][2013-07-10T16:20:04]: Planned package: KB2468871V2_x86, state: Absent, default requested: Absent, ba requested: Absent, execute: None, rollback: None, cache: No, uncache: No, dependency: None
[0968:172C][2013-07-10T16:20:04]: Planned package: KB2468871V2_x64, state: Present, default requested: Present, ba requested: None, execute: None, rollback: None, cache: No, uncache: No, dependency: None
[0968:172C][2013-07-10T16:20:04]: Planned package: VISUALSTUDIO2010INTEGRATEDRTM, state: Absent, default requested: Absent, ba requested: Absent, execute: None, rollback: None, cache: No, uncache: No, dependency: None
[0968:172C][2013-07-10T16:20:04]: Planned package: VISUALSTUDIO2010SP1PATCH, state: Present, default requested: Present, ba requested: None, execute: None, rollback: None, cache: No, uncache: No, dependency: None
[0968:172C][2013-07-10T16:20:04]: Planned package: KB2544514, state: Present, default requested: Present, ba requested: None, execute: None, rollback: None, cache: No, uncache: No, dependency: None
[0968:172C][2013-07-10T16:20:04]: Planned package: SQLDOM11X86, state: Absent, default requested: Absent, ba requested: Absent, execute: None, rollback: None, cache: No, uncache: No, dependency: None
[0968:172C][2013-07-10T16:20:04]: Planned package: SQLDOM11X64, state: Absent, default requested: Present, ba requested: Present, execute: Install, rollback: None, cache: Yes, uncache: No, dependency: Register
[0968:172C][2013-07-10T16:20:04]: Planned package: TSQLLANGSVC11X86, state: Absent, default requested: Absent, ba requested: Absent, execute: None, rollback: None, cache: No, uncache: No, dependency: None
[0968:172C][2013-07-10T16:20:04]: Planned package: TSQLLANGSVC11X64, state: Absent, default requested: Present, ba requested: Present, execute: Install, rollback: None, cache: Yes, uncache: No, dependency: Register
[0968:172C][2013-07-10T16:20:04]: Planned package: DACFX11X86, state: Absent, default requested: Present, ba requested: Present, execute: Install, rollback: None, cache: Yes, uncache: No, dependency: Register
[0968:172C][2013-07-10T16:20:04]: Planned package: DACFX11X64, state: Absent, default requested: Present, ba requested: Present, execute: Install, rollback: None, cache: Yes, uncache: No, dependency: Register
[0968:172C][2013-07-10T16:20:04]: Planned package: SQLLOCALDBX86, state: Absent, default requested: Absent, ba requested: Absent, execute: None, rollback: None, cache: No, uncache: No, dependency: None
[0968:172C][2013-07-10T16:20:04]: Planned package: SQLLOCALDBX64, state: Present, default requested: Present, ba requested: None, execute: None, rollback: None, cache: No, uncache: No, dependency: None
[0968:172C][2013-07-10T16:20:04]: Planned package: SQLCLRTYPES11X86, state: Absent, default requested: Present, ba requested: Present, execute: Install, rollback: None, cache: Yes, uncache: No, dependency: Register
[0968:172C][2013-07-10T16:20:04]: Planned package: SQLCLRTYPES11X64, state: Absent, default requested: Present, ba requested: Present, execute: Install, rollback: None, cache: Yes, uncache: No, dependency: Register
[0968:172C][2013-07-10T16:20:04]: Planned package: SQLSMO11X86, state: Absent, default requested: Present, ba requested: Present, execute: Install, rollback: None, cache: Yes, uncache: No, dependency: Register
[0968:172C][2013-07-10T16:20:04]: Planned package: SQLSMO11X64, state: Absent, default requested: Present, ba requested: Present, execute: Install, rollback: None, cache: Yes, uncache: No, dependency: Register
[0968:172C][2013-07-10T16:20:04]: Planned package: SSDTEXTERNALS10, state: Absent, default requested: Present, ba requested: Present, execute: Install, rollback: None, cache: Yes, uncache: No, dependency: Register
[0968:172C][2013-07-10T16:20:04]: Planned package: SSDTBUILDUTILITIES10, state: Absent, default requested: Present, ba requested: Present, execute: Install, rollback: Uninstall, cache: Yes, uncache: No, dependency: Register
[0968:172C][2013-07-10T16:20:04]: Planned package: SSDT10, state: Absent, default requested: Present, ba requested: Present, execute: Install, rollback: Uninstall, cache: Yes, uncache: No, dependency: Register
[0968:172C][2013-07-10T16:20:04]: Plan complete, result: 0x0
[0968:172C][2013-07-10T16:20:04]: Apply begin
[09D0:1744][2013-07-10T16:20:04]: Creating a system restore point.
[09D0:1744][2013-07-10T16:20:16]: Created a system restore point.
[09D0:1744][2013-07-10T16:20:16]: Caching bundle from: 'C:\Users\Pars\AppData\Local\Temp\{ef0a087a-7567-4ff8-975e-9902ed3e8c56}\.be\SSDTSetup.exe' to: 'C:\ProgramData\Package Cache\{ef0a087a-7567-4ff8-975e-9902ed3e8c56}\SSDTSetup.exe'
[09D0:1744][2013-07-10T16:20:16]: Registering bundle dependency provider: {ef0a087a-7567-4ff8-975e-9902ed3e8c56}, version: 10.3.30618.1
[0968:04C8][2013-07-10T16:20:16]: Prompt for source of package: SQLDOM11X64, payload: SQLDOM11X64, path: F:\Program\Requir LocalDB for vs2010 sqlserver 2008\payload\x64\SQLDom.msi
[0968:04C8][2013-07-10T16:20:16]: Acquiring package: SQLDOM11X64, payload: SQLDOM11X64, download from: http://go.microsoft.com/fwlink/?LinkId=269945&clcid=0x409
[0968:04C8][2013-07-10T16:20:16]: Error 0x80072efd: Failed to send request to URL: http://go.microsoft.com/fwlink/?LinkId=269945&clcid=0x409
[0968:04C8][2013-07-10T16:20:16]: Error 0x80072efd: Failed to send request to URL: http://go.microsoft.com/fwlink/?LinkId=269945&clcid=0x409
[0968:04C8][2013-07-10T16:20:16]: Error 0x80072efd: Failed to connect to URL: http://go.microsoft.com/fwlink/?LinkId=269945&clcid=0x409
[0968:04C8][2013-07-10T16:20:16]: Error 0x80072efd: Failed to get size and time for URL: http://go.microsoft.com/fwlink/?LinkId=269945&clcid=0x409
[0968:04C8][2013-07-10T16:20:16]: Error 0x80072efd: Failed attempt to download URL: 'http://go.microsoft.com/fwlink/?LinkId=269945&clcid=0x409' to: 'C:\Users\Pars\AppData\Local\Temp\{ef0a087a-7567-4ff8-975e-9902ed3e8c56}\SQLDOM11X64'
[0968:04C8][2013-07-10T16:20:16]: Prompt for source of package: SQLDOM11X64, payload: SQLDOM11X64, path: F:\Program\Requir LocalDB for vs2010 sqlserver 2008\payload\x64\SQLDom.msi
[0968:04C8][2013-07-10T16:20:19]: Acquiring package: SQLDOM11X64, payload: SQLDOM11X64, download from: http://go.microsoft.com/fwlink/?LinkId=269945&clcid=0x409
[0968:04C8][2013-07-10T16:20:19]: Error 0x80072efd: Failed to send request to URL: http://go.microsoft.com/fwlink/?LinkId=269945&clcid=0x409
[0968:04C8][2013-07-10T16:20:19]: Error 0x80072efd: Failed to send request to URL: http://go.microsoft.com/fwlink/?LinkId=269945&clcid=0x409
[0968:04C8][2013-07-10T16:20:19]: Error 0x80072efd: Failed to connect to URL: http://go.microsoft.com/fwlink/?LinkId=269945&clcid=0x409
[0968:04C8][2013-07-10T16:20:19]: Error 0x80072efd: Failed to get size and time for URL: http://go.microsoft.com/fwlink/?LinkId=269945&clcid=0x409
[0968:04C8][2013-07-10T16:20:19]: Error 0x80072efd: Failed attempt to download URL: 'http://go.microsoft.com/fwlink/?LinkId=269945&clcid=0x409' to: 'C:\Users\Pars\AppData\Local\Temp\{ef0a087a-7567-4ff8-975e-9902ed3e8c56}\SQLDOM11X64'
[0968:04C8][2013-07-10T16:20:19]: Prompt for source of package: SQLDOM11X64, payload: SQLDOM11X64, path: F:\Program\Requir LocalDB for vs2010 sqlserver 2008\payload\x64\SQLDom.msi
[0968:04C8][2013-07-10T16:20:22]: Acquiring package: SQLDOM11X64, payload: SQLDOM11X64, download from: http://go.microsoft.com/fwlink/?LinkId=269945&clcid=0x409
[0968:04C8][2013-07-10T16:20:22]: Error 0x80072efd: Failed to send request to URL: http://go.microsoft.com/fwlink/?LinkId=269945&clcid=0x409
[0968:04C8][2013-07-10T16:20:22]: Error 0x80072efd: Failed to send request to URL: http://go.microsoft.com/fwlink/?LinkId=269945&clcid=0x409
[0968:04C8][2013-07-10T16:20:22]: Error 0x80072efd: Failed to connect to URL: http://go.microsoft.com/fwlink/?LinkId=269945&clcid=0x409
[0968:04C8][2013-07-10T16:20:22]: Error 0x80072efd: Failed to get size and time for URL: http://go.microsoft.com/fwlink/?LinkId=269945&clcid=0x409
[0968:04C8][2013-07-10T16:20:22]: Error 0x80072efd: Failed attempt to download URL: 'http://go.microsoft.com/fwlink/?LinkId=269945&clcid=0x409' to: 'C:\Users\Pars\AppData\Local\Temp\{ef0a087a-7567-4ff8-975e-9902ed3e8c56}\SQLDOM11X64'
[0968:04C8][2013-07-10T16:20:22]: Prompt for source of package: SQLDOM11X64, payload: SQLDOM11X64, path: F:\Program\Requir LocalDB for vs2010 sqlserver 2008\payload\x64\SQLDom.msi
[0968:04C8][2013-07-10T16:20:25]: Acquiring package: SQLDOM11X64, payload: SQLDOM11X64, download from: http://go.microsoft.com/fwlink/?LinkId=269945&clcid=0x409
[0968:04C8][2013-07-10T16:20:25]: Error 0x80072efd: Failed to send request to URL: http://go.microsoft.com/fwlink/?LinkId=269945&clcid=0x409
[0968:04C8][2013-07-10T16:20:25]: Error 0x80072efd: Failed to send request to URL: http://go.microsoft.com/fwlink/?LinkId=269945&clcid=0x409
[0968:04C8][2013-07-10T16:20:25]: Error 0x80072efd: Failed to connect to URL: http://go.microsoft.com/fwlink/?LinkId=269945&clcid=0x409
[0968:04C8][2013-07-10T16:20:25]: Error 0x80072efd: Failed to get size and time for URL: http://go.microsoft.com/fwlink/?LinkId=269945&clcid=0x409
[0968:04C8][2013-07-10T16:20:25]: Error 0x80072efd: Failed attempt to download URL: 'http://go.microsoft.com/fwlink/?LinkId=269945&clcid=0x409' to: 'C:\Users\Pars\AppData\Local\Temp\{ef0a087a-7567-4ff8-975e-9902ed3e8c56}\SQLDOM11X64'
[0968:04C8][2013-07-10T16:20:25]: Error 0x80072efd: Failed to acquire payload from: 'http://go.microsoft.com/fwlink/?LinkId=269945&clcid=0x409' to working path: 'C:\Users\Pars\AppData\Local\Temp\{ef0a087a-7567-4ff8-975e-9902ed3e8c56}\SQLDOM11X64'
[0968:04C8][2013-07-10T16:20:25]: Failed to acquire payload: SQLDOM11X64 to working path: C:\Users\Pars\AppData\Local\Temp\{ef0a087a-7567-4ff8-975e-9902ed3e8c56}\SQLDOM11X64, error: 0x80072efd.
[0968:172C][2013-07-10T16:20:25]: Error 0x80072efd: Failed while caching, aborting execution.
[09D0:1744][2013-07-10T16:20:25]: Removed bundle dependency provider: {ef0a087a-7567-4ff8-975e-9902ed3e8c56}
[09D0:1744][2013-07-10T16:20:25]: Removing cached bundle: {ef0a087a-7567-4ff8-975e-9902ed3e8c56}, from path: C:\ProgramData\Package Cache\{ef0a087a-7567-4ff8-975e-9902ed3e8c56}\
[0968:172C][2013-07-10T16:20:25]: Apply complete, result: 0x80072efd, restart: None, ba requested restart: No

Keeping Production DB Up To Date

Kevin Marois9-Jul-13 12:55

Kevin Marois

9-Jul-13 12:55

I am working on an app where I now need to keep the production DB up to date with the changes we're making in development. In addition, there is another team that needs to work with this DB.

Can anyone recommend tools for keeping Production and Development DB's in sync.

Requirements include

1) Structure changes.

2) Data cannot be lost.

Thanks

If it's not broken, fix it until it is

Re: Keeping Production DB Up To Date

Garth J Lancaster9-Jul-13 13:25

Garth J Lancaster

9-Jul-13 13:25

Kevin - might also help if you mention

a) 'which' db eg SQL Server, Oracle, {other}
b) how fast/how many updates occur in a unit of time
c) what sort of distance is between prod and dev db's - eg, are they separated into 2 different data centres, 1000 km apart for example
d) how fast do you expect the data to be avail on the dev db - is it 'real time transactional' for example, or 'batch with a 24 hour window'

(because the answers to those questions could really shape someones response)

Let me give an example

if you said a) = Oracle, b) = < 1000 transactions an hour, c) = 1000km, and you had a reliable pipe between Data Centres, then I might respond 'oracle log shipping', which is fairly low-tech, cheap, but meets those requirements

[edit] included a 'd' [/edit]

'g'

Re: Keeping Production DB Up To Date

Kevin Marois9-Jul-13 13:32

Kevin Marois

9-Jul-13 13:32

Fair enough....

a) SQL 2008 R2.

b) Updates probably will be weekly, but could be more often.

c) Production DB is in Winnipeg Canada. I am in development in Southern California.

d) Data will be in use immediatley in Canada.

If it's not broken, fix it until it is

Re: Keeping Production DB Up To Date

Mycroft Holmes9-Jul-13 16:11

Mycroft Holmes

9-Jul-13 16:11

We use Red-Gate SQL compare for deployment of scripts (schema changes). If we have to move any data into production it is a 3 week process with multiple sign offs and blood on the table.

You could set up and automated deployment process that would:
take a backup of the production
script the changes (Red-Gate)
copy the scripts to the production server
run the scripts on production
take a backup of the production
FTP it to the dev server
restore the production backup to the dev server.

However I would shoot the person who suggested you automate this, I want someone hand holding the processes at every step, oversight and someones balls at risk if production goes down.

Never underestimate the power of human stupidity
RAH

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.