|
Hello experts,
I have build C++/MFC windows desktop applications which using MS-Access databases with ADO.
The MS-Access databases which containing data are easy to include in the setup executable.
My applications also have access to a MS-SQLServer database in a cloud location.
Now I like to replace the MS-Access databases with local MS-SQLServer database.
I only have to change the connection-strings for ADO in the applications.
The only problem I think I have:
1. How to setup a local MS-SQLServer from my setup application.
2. How to deploy a not empty MS-SQLServer database.
I don't know where to start, will you hint me in the right direction?
|
|
|
|
|
|
What is the best replacement for the MS-Access database:
SQL Server Compact or SQL Server Express?
I want a silent setup easy to do by users.
|
|
|
|
|
That is not a good reason for choice of database, you should choose whichever one fits the business requirements.
|
|
|
|
|
I need this database to contain meta-data for a language parser.
With a lexicon with 8000 words, 8000 embeded MP3 and 60 video-files.
|
|
|
|
|
Greetings experts,
when I run the following query, it correctly gives me all the records from tableA but all NULL values from tableB even though there are records in tableB.
Any ideas what I am doing wrong?
SELECT DISTINCT isnull(a.district_combo,'Not available'),
a.voter_fname,
a.voter_mname,
a.voter_lname,
a.voter_suffix,
COALESCE(a.str_number,'')+' '+COALESCE(a.str_name,'')+' '+COALESCE(a.str_suffix,'')+' '+COALESCE(a.str_apt,'') AS res_addr,
a.str_city,
a.state,
a.str_zip,
COALESCE(a.mail_str_num,'')+' '+COALESCE(a.mail_str_name,'')+' '+COALESCE(a.mail_srt_suff,'')+' '+COALESCE(a.mail_apt,'')+' '+COALESCE(a.mail_city,'')+' '+COALESCE(a.mail_state,'')+' '+COALESCE(a.mail_zip,'') AS mail_address,
a.dob,
b.* FROM dbo.tableA a LEFT OUTER JOIN dbo.tableB b ON a.record_id=b.record_id
|
|
|
|
|
If it's giving you null values from tableB, then there aren't any records in tableB which match a record in tableA using the join condition you've supplied.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
As Richard mentioned, your join is dropping them out. Which means that there is no record_id in tableB that matches record_id in tableA.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
i need a simple data warehouse for hospital
|
|
|
|
|
|
Appropriate response
|
|
|
|
|
That is pretty cool. I saved that one.
|
|
|
|
|
You'd always want in in a different language and with some additional fields, but a good starting point for a good model
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Eddy Vluggen wrote: You'd always want in in a different language
With decades of experience with munging data from one format to another using perl that is never a problem.
Especially versus trying to get any actual business requirements out of anyone which is much harder.
|
|
|
|
|
No such thing as simple for modeling a hospital. I suggest you design out what you need and then perhaps look at examples, as posted in the first answer.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
|
Richard Deeming wrote: nobody here is going to do your work for you
Per the link above somebody did do the work although not specifically for him.
|
|
|
|
|
Hi,
I would like to ask how can I encrypt a datatype in MySQL?
I have an employees database and need to encrypt the salary field?
Thanks,
Jassim[^]
Technology News @ www.JassimRahma.com
|
|
|
|
|
Encrypt inside the database? Why?
Skipper: We'll fix it.
Alex: Fix it? How you gonna fix this?
Skipper: Grit, spit and a whole lotta duct tape.
|
|
|
|
|
because it's auditor requirement to have the salary field encrypted
Technology News @ www.JassimRahma.com
|
|
|
|
|
Jassim Rahma wrote: because it's auditor requirement to have the salary field encrypted
Certainly not the stupidest thing I have heard but it certainly ranks up there
|
|
|
|
|
|
Hi All,
I have a database in Prod as DbX, and its a live database each time we deploy some schema changes on the Database we Post fix the date, which is working good so far. Its good so far, but to not to change the Connection Strings can I alias database with a particular name to keep the Connection String same but inside database they point to the different times different databases according to the newest version.
Why we are keeping different versions every time is, if we keep the same name and restore multiple times from local backup then the Server backup we do, the local backup restore is influencing on the Server backup with SQL Safe Backup.
So the question is can we have an Alias of the database which points to the different active database for every new release and still can be access from UI with the same Alias name so that UI team doesn't have to change their connection strings for every new release of the database?
Any help, a link, a code snippet or even a suggestion would be very very helpful.
Thanks in advance.
Thanks,
Abdul Aleem
"There is already enough hatred in the world lets spread love, compassion and affection."
|
|
|
|
|
You are doing this completely wrong, do it the same as you would do a branch, leave your latest version with the original name and change your archive database name before deploy a new version.
Your production database should never change its connection string.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Makes sense thanks man.
Thanks,
Abdul Aleem
"There is already enough hatred in the world lets spread love, compassion and affection."
|
|
|
|