Latest developer linksBookmark and Share
 
HomeThis WeekTop MonthTop AlltimeSearchRegisterFAQ
  
 
Submit Your Link
Please login to submit your Link
 

Making sqlcmdvars language(German and English) and architecture(32 and 64 bit) independent

Posted: Jan/22/2011   By: nikhil   Points:15   Category: .NET  - ASP.Net    Views:195   Vote Up (0)   Vote Down (0)    

I have a Database project which uses a SQL Server Express 2008 database.

I am installing the database using sqlcmd and using the SQL Script generated as an output from the database project.

There is a snippet below from the SQL Script generated. This sqlcmdvars are language and architecture specific.

How do I make a generic set of sqlcmdvars which will work for "Program Files" or "Programme" or "Program Files(x86)" or "Programme(x86)"?

Snippet from SQL Script used by SQLCMD:

:setvar DatabaseName "TestDatabase"

:setvar DefaultDataPath "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\"

:setvar DefaultLogPath "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\"

View Complete Post


Comments:
Be the first to comment this post.
 
Post Comment
Please login to post your comment
More Related Resources

Dynamic Binding in a Static Language, Part 1

  
This article is taken from the book C# in Depth, Second Edition. This segment looks at what it means for code to be dynamic, and the syntax involved in using dynamic typing in C# 4

Opinion on Architecture approach

  

Ijust started a new job as Software Architect. I would really appreciate if somone can share their opinions regarding architecture of the following project that I can implement. I was planning to utilize MVP, DDD, TDD, IOC, Dependency Injection, Repository , StructureMap etc. I am not sure about how to achieve the portal aspect and value added services.

Technology:

  • Client Web Portal
  • ASP.Net /C#/SQL Server

Project Specification:

  • 5 types of customers
  • Template of service
  • Dynamic Content Driven portal
  • Modules can be activated/deactivated through management console
  • Branding and customization
  • Rapid deployment portals of future clients as well
  • Portals will allow for customization
  • Data reporting services
  • Value- Add services to the clients portal
  • Each Clients welcome page can be customized by client as well
  • Mobile Application services
  • Localization

I would really appreciate if someone can point out the following:

  • Best Architecture for this project
  • Patterns to use
  • How the data layer should be layed out?
  • How to achieve portal technology
  • Value add services
  • Any open source existing resources which can be utilized
  • Any books which will put me in the right direction

Architecture Question - When and Where to Build Cache for Site Search Index

  

I have an MVC3 web app that represents about a dozen different entities, but I have built a common search function so that the user can do a single search and get results from the various entities. It works fine, but as I suspected, the performance is slow because the search is occurring live and there's a lot to search. A cache would be fine even if it was a long one (daily even), but I don't know where and when to actually refresh the cache. If a person uses the search when it's been longer than the cache timeout then it will be really slow for them that one time and that's not acceptable. I'm thinking that I have to have a Windows service in place or something that builds the cache, but perhaps there's a better way that I don't know about. I can't do it entirely in the database because some of the entities don't exist in the database (one entity list is composed by searching through some files on the system for instance). Any help is appreciated.


3D architecture drawing

  

 Hi,

Is there any tools out there which I can use to produced diagrams like the following

 

http://www.wisedimensions.com/screenshots/intro1.jpg (I am referring to the 3D appearance).  I tried the tool shown in the diagram 3D Visioner, but this does not provide a clear image which I can use on any document.

 

Thanks

Arjuna.



Making Sharepoint Portal DDA compliant

  
My Requirement is ,

I need to have my sharepoint portal DDA compliant .. any thoughts ?? any reference i can take up ???


any assistance would be appreciated !!!

Regards

Issue with language of Discussion board list?

  

Hi All,

In bilingual portal (English/Arabic), whenever I try to create discussion board, it gets created in Arabic (All list columns and messages are in Arabic) even if I create it in Englsih site. Few days back, same thing was working fine but suddenly the discusion board list columns and messages started displaying in Arabic. Please guide me on this issue. 

Thanks,

Rahul Babar


Dot Net, Sharepoint, Infopath Developer

How to change the language based on log in user programmatically in SharePoint

  

Hi,

I created SharePoint site using MOSS 2007.I need to support Spanish(Spain) language in my site. To achieve this I have installed Spanish service pack.Now I can create site in Spanish.

I am aware that the Site Language is stored in ”Webs” table of “Content” database and the language changes from English to Spanish, If I change the language from 1033 to 3082.

What I would want to know is, how do I change the language based on log in  user(user has locale ID),  programmatically?

Please assist me, how do I change language dynamically?

Regards,

Vidya Jeerahalli


Powershell NavigationCmdletProvider architecture

  
Hello everyone, I have a question regarding powershell provider architecture. I have a datastore that is both heirarchical and heterogeneous in nature. I.e. there is no single node or leaf type. I would like to navigate and manipulate this data store contextually while providing appropriate actions for each data type encountered. What is the proper way to approach this? Must I create multiple providers that work in concert with each other? Or is the proper approach to have a single provider that checks each type and alters the behavior of each cmdlet override as necessary. I hope I explained this properly. I also hope I placed this in the correct forum :) Thanks for your input.

Change the Language of the SSAS server

  

Hi all,

I have hit the 'The LocaleIdentifier property is not overwritable and cannot be assigned a new value' problem with SSAS.

Reading up on the web the fix seems to be either change my settings to match the server ( server is English United States) which i do not want to do.

The other solution seems to be change the server language to UK English.

If I change this on the server what repucussions can I expect  in terms of cube access for users etc.

Any help appreciated.

TIA

 


Failed to initialize the Common Language Runtime (CLR) v2.0.50727 due to memory pressure.-Please restart SQL server in Address Windowing Extensions (AWE) mode to use CLR integration features.

  

I have getting following error…    

 

Failed to initialize the Common Language Runtime (CLR) v2.0.50727 due to memory pressure.

 Please restart SQL server in Address Windowing Extensions (AWE) mode to use CLR integration features.

 

 

If I Restart the SQL server… it will work fine. Again after some time I getting same error.

 

 

Can any one help me on this?


 
Categories:
.NET
Java
PHP
C/C++/VC++
HTML/XML
SAP
MainFrames
Data Warehousing
Testing
MySQL
SQL Server
Oracle
Javascript/VB Script
Others
Login
 
 
 
 
 Forgot password
 Contact Us   Terms Of use   Share your knowledge