copy database one database to onther database
hii want to copy one database table to onther database table using script?my database is ms-sql server 2000 Nothing is really over,untill the moment stop trying for it...Amitsp(MCTS,MCP)sqlreporting.blogspot.com
You can use import/export task and DTS package created automatically by Enterprise manager or just try
select * INTO [newdatabase].dbo.[newTable] from [sourceDatabase].dbo.[sourcetable]
no dear i want to this programatticallyiusing c #,source is my database in local machine and target is other computer means server Nothing is really...database in database solution
i have a database in the database solution. but i want to add the database from database solution to App_data folder in solution explorer.
how to do this ?Jai Ganesh. J , GSD ,IndiaPlease Mark As Answer If my reply helped you.
i am having visual studio express edition and sql management express.
i have opened solution explorer for a asp.net project. I have the database solution and i have the App_data in the solution Explorer.
I have added a existing sql database in the database solution and wanted the newly added sql database in the App_data of solution...how to access other database in this database ?
Hi,Everyone,I used to use oracle 8i,but now for some reasons,I must change
to ASE11.5,at the beginning,I don't know how to access tables among
databases,in oracle, if I grant "select" to some user,this user will access
other user's table in username.tablename format,I want to know how to
implement this functions,please help me! thanks!
Very similar in sybase ASE.
grant SELECT on <user>.<tbl> to <newuser>
for new user:
select * from <user>.<tbl>
> Hi,Everyone,I used to use oracle 8i,but now for some rea...Database profile and databases
I have installed Syabse on linux and PB 6.5 on windows 2000. I am able to
connect to the sybase server through dsedit utility and I am also able to
connect PB development environment(database profile) to particuler database
on sybase server. But when I want to see all the tables while clicking on
database menu option an error messagebox displayed "Stored procedure
pb60table not found. Specify owner.objectname or use sp_help to check
whether object exist.(sp_help may produce lot of output" . This error
messagebox is displayed. I am not able to make any datawi...How to upgrade database changes in remote databases and consolidated databases
I am Working in a project which uses Sybase Mobilink server as the
replication system. Now I have been given a requirement to automate the
upgrade databases chages in remote databases and consolidated database.
I heard the about "Passthrough" but I don't know how to use it.
I saw below topic in our forum
PASSTHROUGH Question. How do I replicate DML ...
1.- Created a Version_Tracking Table (contains columns
Unique_Record_ID, DB_Remote_ID, DB_Version, DB_Update_Time_Stamp and
2.- The new Version_Tracking table is part of a publication that...Coping Database objects from one database to another blank database.
I want to create a duplicate database in sql 2000 using asp.net from a webform
I created a database using CREATE DATABASE .......
But how to copy tables, views, stored procedures to newly created
database from old using asp.net from webform
Is there any another method to create a duplicate database with another name
from existing database on same server ?
yes you can do have another DB with different name and that has everything the same .....!!!Fadil Alnassar www.fadilalnassar.com | FREE Nodil Tab Controlhttp://www.mefranchising.com
One way it can be done is with...simple database options for my Delphi 2010 application
This is a very general question which I hope will provide me with some guidance on how to proceed with database design for my Delphi 2010 application.
My application is currently used by a few groups of users which range from 4 to 12 users per group. The exe is 8 MB, and it is resident on a server owned by each group. Access is via Remote Desktop from client machines within the group network. Several users can be logged in to concurrent sessions of the application and that has never posed any issue. Each user within a group accesses the same database files.
For my databases, ...which database does the database refer in "Not connected to a database" of the second paragraph
I. 01/01 02:30:40. Synchronization Started
I. 01/01 02:30:40. Adaptive Server Anywhere MobiLink Synchronization Version
I. 01/01 02:30:40.
I. 01/01 02:30:40. Copyright _ 1989-2002 Sybase, Inc.
Portions Copyright _ 2002, iAnywhere Solutions, Inc.
I. 01/01 02:30:40. All rights reserved. All unpublished rights reserved.
I. 01/01 02:30:40.
I. 01/01 02:30:40. This software contains confidential and trade secret
I. 01/01 02:30:40. iAnywhere Solutions, Inc.
Use, duplication or disclosure of the software and
I. ...Error when transferring data from local database to hosted database
I tried to tranfers some database tables from my local SQL Server 2000 database to a hosted database (SQL Server 2005) MSSQL Management Studio 2005. I did the same job successfully before also from my local MSSQL2000 to another hosted MSSQL2005 database. However, this time I encounter the following problem (in red below).
I opened a ticket for support from my service provider but they seemed to have no idea. Therefore, I must seek for help on this forum. Could anyone please give me some advice? Thank you very much in advance.
Messa...Database Workbench, where can I set a Database Restricted so only aliases can use the database?
Now I want a database to be not available unless approached by an alias.
Can't find where I set this, in Database Workbench.
> Now I want a database to be not available unless approached by an alias.
> Can't find where I set this, in Database Workbench.
This is a setting of your Firebird server installation. Check out the
DatabaseAccess configuration parameter in firebird.conf.
Set it to:
DatabaseAccess = None
Professional Tools and Services for Firebird
FB TraceManag...Replication of consolidated database to remote database; for columns added to a table in the consolidated database.
I want to find out if I add columns to a data table in the consolidated
database and then extract it for a remote database. Will the added columns
appear in the remote database automatically? or do I have to deploy the
extracted remote database by copying it to the remote machine.
Currently the consolidated database and the remote database get replicated
nightly and they have connections already established. Due to established
connections, will the extracted database automatically get deployed to the
remote machine with the updated table?
Try it, that is the best way to check ...Database Roles in Session database
We have two websites developed in VS2005 beta 2 in our project.
I am creating the Session state database(for session state management) for those websites in a separate database server using the aspnet_regsql tool .
The issue is I run my websites under a account which has minimal permissions . For our project databases we create database roles with required permissions and assign the portal user to those roles .So there is no problem accessing the databases we create .
Now how do I give the portal user rights to the Session state database . .There are no prede...1 Database or 2 Databases?
I was just wondering which way is better... Having my membership profile Database that asp.net configuration creates for me as it's own database and creating a seporate DB for the rest of my tables, or combining all of my tables into the ASPNETDB?Failure is the opportunity to begin again more intelligently.Mickey Elliott
Using separate DBs for your app and user memberhip will allow you to implement a single login for multiple apps if you desire. So, from scalibility point of view, separate DBs is the way to go here.NAbeel--*Please mark as answer if you find this post ...How to convert the database in a mysql database ???
I need help,
i want to put asp.net portal to a mysql data base
Since the Data MAnipulation Layer is written in Stored Procedures, you will have to rewrite all of it. It probably would not be very time effective in my opinion.
Well, maybe it won't be that bad. Looks like someone is already doing it. Check out their forum for more upates.