|
was the link I posted any good ?
|
|
|
|
|
yes but I cannot do that or I cannot find mysql directory as I am using xampp server(phpmyadmin) and mysql workbench
|
|
|
|
|
hello, i m at just start to learn SQL..
plz give me guidance from which references i should proceeed!
|
|
|
|
|
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
|
|
|
|
|
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?
|
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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'
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
Mycroft Holmes wrote: However I would shoot the person who suggested you automate this, I want someone
hand holding the processes at every step
really ? thats a bit drastic isnt it .. if you cant afford a decent replication scheme, do you want to be a slave to manual methods ? different strokes for different folks I guess
We use disk level mirroring between prod and d/r - an initial mirror is replicated to our d/r site over dark fibre - that has its issues as well - if the prod mirror is corrupted, then, so is the d/r mirror (thats a basic level explanation, its a bit more complicated) .. my point is, not everyone has the $$ for big buck solutions, or the need, but I would automate a 'simpler' process as much as possible (caveat) with the appropriate checks and balances and control-points, and, everything has different 'angles'/pitfalls ..so know the weak points of a solution
'g'
|
|
|
|
|
Actually I was talking about the automated deployment TO production, that is something I would not want to do, the process yes but not the initiation of that process.
Replication and backup distribution of the production database is something I would highly approve of if I could get it, policy, the f***ing god POLICY will not allow production data in dev. Ah well you work in finance you have to abide by their rules .
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
sorry - my fault
production data in dev - yeah, a tricky one - we have a process that 'washes the data'/ anonymizes it
'g'
|
|
|
|
|
Garth J Lancaster wrote: we have a process that 'washes the data'/ anonymizes it
And I still need a dispensation from the god Policy to get the data!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
You are going to be doing structure and data changes to a production database on a weekly basis?
And I can only suppose that there is other software that uses it which will also need to be updated.
Certainly not something I would want to see.
Better make sure that you have complete automated unit and system testing.
And have a lot of time to dedicate to implementing the automated deployment and providing for a rollback for ALL systems.
I doubt you will find a tool that does it all. And every database change will need to be evaluated for rollback impact.
|
|
|
|
|
Hello!
We are trying to refresh our development environment with data from QA server. Our QA server is located outside our network in a remote location.
What is the easiest way to copy over data from QA server to our development server?
Currently, following the back up database, and trying to copy over that file to restore it.
any other way?
Many thanks!!
|
|
|
|
|
It has been my experience that, although painful, doing a backup and then a copy or FTP is the best solution available.
I have previously been required to back up the production database and sent it via FTP to the vendor to reproduce a given problem.
|
|
|
|
|
Yep.
I agree with Tim.
1) backup the database
2) FTP it to the desired location
3) restore database
You may want to perform a data compression on the backup, but sometimes it doesn't really compress.
|
|
|
|
|
Perfect, i also follow that
|
|
|
|
|
Agree.
Zip/compress it before send also.
|
|
|
|
|
7-zip usually seems to produce smaller results than regular zip files. On one server, it compressed a 1.3Gb backup file to 55Mb, which took the nightly FTP transfer down from 7 hours to around 15 minutes.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Yes, once zipped - the file size from 2 GB has come down to 850MB.
I am trying to do a copy of the file from remote server, literal right click copy, and right click paste on to my laptop. I keep losing the connection.
If we use a FTP tool, would this be the same issue, of losing the file transfer connection?
Thanks for all the ideas and suggestions.
|
|
|
|
|
FTP tends to be more robust than copy+paste in Explorer. However, if you have underlying network problems, you'll still have problems with FTP transfers.
I'd be inclined to give 7zip[^] a go - the maximum compression settings will take a bit longer, but they should be able to get the file size down a lot further.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
vkEmerson wrote: I keep losing the connection.
With a one-shot you just keep trying.
But if this needs to happen on a frequent basis then you should look into getting a restartable transfer mechanism in place.
|
|
|
|
|