I would need it to allow me to host subdomains and multiple domains is a huge plus.
Required:
ASP.NET 2.0, 3.0, 3.5
Subdomain Hosting
MS-SQL & MySQL Databases
Want
Multiple Domain Hosting
ASP.NET 4.0
Ability to directly connect to MS SQL using SQL SMS
I want to setup 2 MySQL databases which differ in schema in that, one is normalized and the other is flat for quicker reads and writes. The information being stored in both DBs is the same, but the representation is obviously different owing to the different design approaches.
I need to find a robust solution to sync information in real time from my normalized version to my flatter version.
Say that I have a query of the form
SELECT * FROM MYTABLE WHERE MYCOL in (?)
And I want to parameterize the arguments to in.
Is there a straightforward way to do this in Java with JDBC, in a way that could work on multiple databases without modifying the SQL itself?
The closest question I've found had to do with C#, I'm wondering if there is something different for Java/JDBC.
Transactional Replication on SQL Server 2005 Enterprise x64 (SP3).
I need to add check constraints to a databases that is the target for a replication, but I cannot add the check constraints to the publishing database. The Problem is that the replication process keeps removing my constraints. How do I prevent this?
This is a simple database security & performance question, but I've always used either a special user (eg. mydbuser), or Windows' built-in NETWORK SECURITY account as the owner when attaching databases to my SQL Server instances.
When deploying my database to a production server, is there a specific user I should stick to or avoid? I would think that using an account with a set password could open the database up to a potential security issue.
I have an archive system that had to be on two sql databases for simplicity
one is
Archive2009
and the other Archive2010
they are both on the same sql server and instance and have identical structures
however I have a page that needs to view the old one and the new one (I can make two seperate pages)
How best would I go about doing this? Dynamically changing the connection string etc?
I am building a django based application and its time to add the DHTML stuff.
One of my fields represent a database field with this format databaseName.tableName.fieldName
I would like to have javascript autocompletion in three levels, say once I type part of the database names I get a list of all matching databases, one that is selected I get a list of all tables, and once that is selected I get a list of all fields in that table, all in the same textfield.
Any help would be appreciated.
Thanks
M
I am attempting to make a program that will pull data such as OS, IP, Server Name, Websites, Databases, etc. in a server farm. Is there a .Net library that allows you to connect to servers and get information such as this with the proper authentication? I do not really know where to start, thank you.
Most of the servers are 2003 standard/enterprise both x86 and x64.
Good Morning,
I have connected to my SQL 2005 server - and have managed to list all of the databases on that server. Now I would like to run a check on each database to see if I have permission to view that database..
How would I go about this?
Many Thanks,
Joel
I wrote a WinForms app using .Net and C#. The app accesses DirectoryServices and SQL databases.
The new Win7 workplaces are not allowed to have local admin users and this app will not run.
How can I identify the actions in the app which need local admin rights?
Hi,
My application uses its own file format (compressed SQLite databases) to store user created data.
1) I would like to know how to provide keywords, tags to Windows so that Vista search function can include my file format when indexing.
2) I would like to provide a properties page like you see when you right click a Microsoft Word document and select properties.
Kindly point me in the right direction.
Thank you.
So I want to make a program that allows you to store and search for user names/passwords for online sites there signed up to.
I know C# has some database options but I don't know much about it. I also heard that it can read/write excel files.
Whats do you think is best for storing the data?
ALSO do databases need to be stored online on a sever, or can they reside in the program
files?
I don't know how to copy table data from
one server - database - table
TO
other sever - database - table.
If it is with in the same server and different databases, i have used the following
SELECT * INTO DB1..TBL1 FROM DB2..TBL1 (to copy with table structure and data)
INSERT INTO DB1..TBL1(F1, F2) SELECT F1, F2 FROM DB2..TBL1 (copy only data)
Now my question is copy the data from SERVER1 -- DB1-- TBL1 to SERVER2 -- DB2 --TBL2
11g and 10g both have the all_queue_subscribers (and user_, dba_) dictionary tables for listing the subscribers to queues, but this doesn't exist on 9i. Does the same concept of queue subscribers exist on 9i databases, and where can I get this information from?
When setting up foreign keys in SQL Server, under what circumstances should you have it cascade on delete or update, and what is the reasoning behind it?
This probably applies to other databases as well.
I'm looking most of all for concrete examples of each scenario, preferably from someone who has used them successfully.
Does anyone know of a good online resource which gives a clear reference on the SQL syntax supported by HTML 5 client-side databases? I've looked about and cannot seem to locate one.
Thanks
I have 2 tables in 2 different databases, one is in a mysql server and one is in an informix server.
Using .net and odbc, is there a way to identify the differences of both tables and merge them?
so that both informix database and mysql database have the same data.
thanks.
I'm running on an OS X environment and would like to create a flexible web development environment locally... including the option to run on an Nginx server for my PHP-based application.
At the end of the day (or, development cycle), I'd like to be able to hit a switch and have it all sync over to Amazon AWS hosting (EC2, S3) - instances, databases, files, configurations, and all.
Are there any simple ways to do this?
I currently have a SQL Server 2008 database in which I am planning to separate out some tables to other databases. I want to be able to replace all references to the separated tables from the original database using views. Is there a better way (other than manually changing all FK and SProc references) to switch all the dependencies to reference the view instead of the table?
It should be a tool to enable versioning of a database schema and efficiently updating databases with older versions of the schema:
robustness, does it handle all edge cases
support for data migration
command line execution
flexibility, can some data be compared as well
In the answers a breakdown on support for these points (and anything I may have missed) would be appreciated.
I have 2 databases on SQL (identical). I want a table from one database to be copied to the other database. They are both the same name and the original table can be overeritten.
Cheers