» Home » database » Page 1
Deploying azure web site locally, update-database doesn't work: CREATE DATABASE permission denied in database 'master'
Category : Databases

I have done this tutorial:
https://www.windowsazure.com/en-us/develop/net/tutorials/web-site-with-sql-database/?redirectToLocale=false


It works when I publish it on my Azure online account, and the database is running well.
But the problem is that when I followed the tutorial, it asks to do this:
1. enable-migrations
2. add-migrations
3. update-database

<

View Replies


Database syncronization of Remote Database to Local Database and vice versa using Python
Category : Databases

I'd like to ask regarding syncronizing records between remote database and local database using Python program. I am just a newbie on Python Language and would like to seek assistance on these one.


If what's the process, technology and a sample for these kind of problem. I have a Website where in it contains selling products and services. Visitors may sign up in order for them to or


View Replies


Cannot deploy VS 2010 database solution to database if the deployed database was manually deleted
Category : Databases

I am working on creating a visual studio database solution so that i could deploy databases in a more managed manner. Following are the steps that i performed after adding some sample tables and SPs in the solution.


Deploy the database to my local machine (and a new database is created).
Add some mock data to the tables in SSMS.
Add couple of columns to one of the tables in t

View Replies


Create Database in Visual Studio as a new database project and then use it as a test database
Category : Programming Languages

I wish to create a database in Visual Studio as a new database project and then use it as a test database to select/insert/delete/update/etc. Currently I have my program connected to the production database and I only do my testing during downtime or turnarounds. Is there a way I can manually create a similar database or copy a piece of the existing database and use that as the database that m


View Replies


Is it possible to use a database link between an oracle database and a postgresql database on different physical servers
Category : Programming Languages

I've trying to streamline an intranet application where some of the data is stored locally on the postgresql database of the intranet server and other related data is stored in our enterprise oracle 10g2r2 database.


What I would like to do is create a view on either database box wouldn't really matter that combines for simplicity sake one table from each database into a flat view


View Replies


how to select from one database and insert into another Database in a Single query with different Database connections in php
Category : PHP
mysql_connect("localhost","root","");
mysql_select_db("database1");
mysql_query("INSERT INTO database2.categories (category_name,description,group_id,created)
SELECT table1.name, table1.description, 12, UNIX_TIMESTAMP()
FROM GiveArang_categories Where `p_id`= '225' ");

I need to insert data into the second database which is selected from the first


View Replies


PHPMyAdmin and mySQL: Insert into existing database, not create new one. Error “Can't create database; database exists”
Category : Databases

I recently went to backup a database and got the following error "#1007 - Can't create database 'wordpress_8'; database exists".


I have the following line in the beginning of my sql file:


SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: 'wordpress_8'
--
CREATE DATABASE wordpress_8 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE wo

View Replies


(database design,mysql) Is my database design good for basic shopping cart?(I new in database design)
Category : Databases

I new in database design, I want to be sure that i make it well.
Please take a look for part of my database design:


My database design for basic shopping cart:


//table that holds shopping cart items that customer choose(not press checkout and order //them)
**shopping_cart**
{
id (int)
product_id (int) fk
product_quantity (int)
custom

View Replies


Connecting to another mysql database and update database tables when other database is update
Category : Programming Languages

Is it possible to connecting a remote mysql server and auto update another database in the same time?
For example my database:


Database one: user id user name pass

When adding or updating user in database two, user name in database one updates.
How can I do this if possible?
Thanks in advance


View Replies


Export large amounts of binary data from one SQL database and import it into another database of the same schema
Category : Databases

I have one database with an image table that contains just over 37,000 records. Each record contains an image in the form of binary data. I need to get all of those 37,000 records into another database containing the same table and schema that has about 12,500 records. I need to insert these images into the database with an IF NOT EXISTS approach to make sure that there are no duplicates when I


View Replies


Next
2012 / 2017 Copyrights BigHow , All Rights Reserved .