Copying users from one database to another
I am using SQLAnywhere and PB 6.0. Each quarter we plan on distributing the
latest and great version of our database to our customers. The dilema I am
having is that each customers verison has unique users. I am dont want to
make them re enter thier users every quarter. But I cant think of a good way
to copy all the users AND their passwords from one version of database to
One option would be that I could store the users password in my own tables,
but I would prefer not having to do that.
Does anyone know of a way to copy users intact from one database to another?
Bob ...Copying a Remote Database from One User to Another
I have a need to pass a remote database from one user to
another. If I just copy the .db and the .log files from
user A to B, then during merge, the Mobilink server will
think that user A and B performed the same changes (because
they have the same entries in the transaction log) and it
will treat these changes as conflicts.
So I was thinking, perhaps if I copy the .db and .log file
from A to B, then truncate the transaction log of user B,
Mobilink will not treat the same changes as conflicts. As
far as Mobilink is concerned, user B has not performed any
changes on the database.
...Need to copy users and groups from one database to another
I am trying to copy the users and groups that are set up in one ASA 7
database to another one using command line.
I would like to find a way such a running a dbunload to get this information
out in such a way that I can easily get it into another database. I am able
to move most the information with command like
dbunload -c "..." -ac "..." -d
(No -d and I get conflicts with things already existing.)
But I cannot seem to get the user information to go across. I even tried
specify what I thought was the underlying table (could be wrong). Any
Thanks...copying tables from one database to another database
i am using visual web developer 2005 and SQL Express 2005 with VB as the code behindi have two databases . i want to copy all the tables with all the contents from one database to another database programaticallyhow to achieve this ?please help me
easiest way is to use the detach - attach method or backup and restoreKH...How to copy a table from one database to another database ?
Hello to you,
I'm newbie using pb8.02
I'm uisng ms-access 2000
I'd database abc & xyz
that contains customer table
I want to copy some record on abc.customer to xyz.customer
What is the easy way ? should I using datawindow ? (i meant should I always
had dw to got this purpose ? )
DataWindow purists will flinch, but I think an embedded SQL INSERT INTO
xyz.customer (SELECT ... FROM abc.customer) is the clearest way to do that.
Two datawindows/datastores, retrieve the first, RowsCopy, Update on the
second will also work.
Pi...how to copy one database entries to another database
hi i have a windows based application and a web based application. the database of windows based application and web based application are same but located on different machiene. like windows based application is located on local machiene and web based databased is located on another machiene. Now my prob is that after inserting all the entries in local database i want to copy these entries to web database using my windows application on single click of the button. but i have no idea about it. how could i do this. Thanks in adwance.
well you have to create a DTS id ur using sql 2000 or SSI...How to copy table from one database to another database ?
Hello to you,
I'm uisng pb8
How to copy some rows from customer table in (ABC database) to customer
table in (XYZ databases)
the selection row is :
select * from customer where startdate = 2002-06-15
Please show me the code, step by step
On Sun, 16 Jun 2002 22:30:37 -0400, steven wrote:
>Hello to you,
>I'm uisng pb8
>How to copy some rows from customer table in (ABC database) to customer
>table in (XYZ databases)
>the selection row is :
>select * from customer where startdate = 2002-06-15
>Please show me the code...Transfer och Copy roles from one user to another user.
I would like to see two more methods to the Role feature in Whidbey, one that apply user's roles to another user and one that merge a user's roles with another user. This will be very useful in a Business Portal where employees (users) belong to several roles, and one of the employees quits and a new person will take the other person's roles.
I have added those methods to the Permission manager I'm working on. The company I work for has several customers that have requested this kind of feature, because ...how to copy one table from one database to another on different servers?
Hello. I need to copy all of the rows in a table from a database on one server, to another existing table of the same name in a different database on a different server. I'm trying to use a SELECT INTO statement. Any idea how to do this?I've tried SELECT * INTO DestinationServer.dbo.DestinationDB.DestinationTableFROM &nb...How to write a stored procedure to copy the data from one database to another database
I want to copy the data from one database to another database every 12 hrs.(This is variable). Say for example I have 3 applications and I want to copy the data from Parentdatabase1 and insert into CopyofParentdatabase1 for every 6 hrsParentdatabase2 and insert into CopyofParentdatabase2 for every 8 hrsParentdatabase3 and insert into CopyofParentdatabase3 for every 12 hrsI have heard that we can do this by using SQL Server Integration Services but as of now we cannot use SSIS. So I want to do this using Stored procedures. Is there a way to schedule the batch job for to run all these stored procedures at the specified time. The above mentioned times may change. So this should pull up these duration hrs from some place.If there is a way to copy all these data using stored procedures and can schedule these batch jobs using Sql Server management studio, then any one help me or guide to write storeprocedure and creating that batch job Thanks
You should Creat A DTS or SSIs Packages to do this its faster A fine is a tax for doing wrong. A tax is a fine for doing well.__________________________________________________Please remember to click “Mark as Answer” on the post that helps you.
HI, You can create a DTS package for copy the database to another db. You can also schedule these DTS package for regular intervals.Both steps you can do it using Enterprise Manager itself. -Sri-------------------------------------------------If this post...Copying information from One table to Another from 2 different databases on one server
Can I copy accross databases e.g.:
In MS SQL I can:
Insert into Database2..customer
select * from Database1..customer
Thanks in Advance
Yes you can. The syntax in Sybase is same.
The syntax is the same if you are on ASE. ASA does not support that
syntax. You need to use a Proxy table instead.
Jim Egan [TeamSybase]
Sybase Developers Network
...Copy one database to another
I want to Copy one database to another in MSAcess i am using asp.net, C# and copy all tables from one database to another.
Probably the easiest way is to simply use the classes in the System.IO namespace to copy the mdb file. If you only want the structure, and not the data, iterate the tables in the copy database and DELETE * from them. Have a look at Jet Replication Objects for compacting and repairing the copy database afterwards: http://www.codeproject.com/KB/database/mdbcompact_latebind.aspx Regards Mi...import one table from one database to another database
if i have one table from database A, and i want to copy the table to database B, then how to do it in SQL server management studio express? is it i have to make sql query?Taj FreewarezNo limitations...It is not a shareware...It is simply free :)http://tajfreeware.blogspot.com
select * into databaseB.dbo.TableA from databaseA.dbo.TableA
or go to database B and run
select * into TableA from databaseA.dbo.TableA...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...Copy tables from one database to another?
Is there an easy way to copy alle tables from one database to another?I have not really tried to create tables or copy or something like that, so i dont even know if its possible?Hope some of you can help me, ----------------Regards,Jeppe Richardt
Hey you could use SQL Bulkcopy:http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlbulkcopy(VS.80).aspx Please: Don't forget to click "Mark as Answer" on the post that helped you. That way future readers will know which post solved your issue....Copy table from one database to another
Hi, I need to create a exe, that will copy some columns from one table (present in DB1) to another table (present in DB2). I need to do in C#. I got no idea from where to start. Can someone please help me out. Thanks in advance.
I'm missing how this is Web related (Asp.Net)?
You can execute this sql: SELECT * INTO TableTemp FROM Table
Thanks,Qin Dian TangMicrosoft Online Community SupportPlease remember to mark the replies as answers if they help and unmark them if they ...Copying records from one database to another
I know I've seen this before, but can't seem to find it now that I need
it. How can I use ISQL or Sybase Central to copy records from one
database to another one. I accidentally deleted a bunch of records from
my database, and want to re-insert the deleted records them from my
backup copy, which I have started on my local computer.
An optimist says "Good morning, Lord." While a pessimist says "Good
Lord, it's morning".
Remove the ns_ from the address before e-mailing.
In article <MPG.email@example.com...Copying the permissions of one user to another
Is there a way to copy all the permissions of one user to another ?
We tried to create groups, but with that, a user can only belong to one
group (plus the public group)
Thanks in advance.
> Is there a way to copy all the permissions of one user to another ?
> We tried to create groups, but with that, a user can only belong to one
> group (plus the public group)
You might want to look into the user-defined roles feature introduced in
ASE 11.5. These work very much like groups, but are much more flexible...How to copy data from one database to another
I am using Interbase XE. I am trying to copy the data from the tables from
Database1 to Database2.
In IBConssole, the «Copy Data» option is not working certainly because the
character set in Database1 is «NONE» and the one in Database2 is «UTF8».
I tried to backup and restore but I realized that there' no option in
IBConsole to backup and restore only the data (without the Metadata).
Is it possible to use for example a SQL SELECT by specifying the origin and
Which option can I use to copy the data from the tables from Database1 to
...Copying data from one database to another
I'm looking for the way to copy data from one database to another.
Both databases are SQL Anywhere.
Destination database = source database + new tables + new columns.
Destination database has different structure then the source one. It can
have new tables, new columns.
For copying data I must use RTDSK50.EXE (SQL Anywhere).
Mechanism of copying data must be integrated with our program. When user
upgrades our program (he does it by Internet) he also must upgrade
database. We must copy his data to a new upgraded database.
Have you looked at using a pipeline obj...Copying users from another SQL database
I have DNN 2.x running with its database on the same SQL server that has another database which contains the names, username, password, e-mail information for about 400 users that I need to add to the DNN user table. I would like to automate adding all of these 400 users and giving them the same role.
Is there a way to do this in a fairly straightforward way using SQL procedures, programs or scripts. I searched this form and found one example using a SQL stored procedure that I can probably adapt, if necessary.
I am just wondering if anyone knows of other ways to accomplish this that...Copy a table from a one database to another
I need to copy a table from one database to another with all the
records the first has, but when I use the pipeline in the powerbuilder
enviroment it only copy the table with no records. Is there any way to
use the pipeline to append the records from a table that is in a
Any help would be apreciated.
AFAIK, you can use the pipeline object to do this. One of the options of the
pipeline object is 'Append'.
- Met vriendelijke groet,
Eric Aling [TeamPS], Cypres Informatisering bv, The Netherlands
http://ourworld.compuserve...copying users from one server to another?
I've just moved one of our apps onto another server and I've run into
difficulty transferring over login names and passwords. I've tried to bcp
out/in from syslogins and sysloginroles but while I get the login names into
the new server, no permissions follow them over?
I've had to recreate the logins, passwords and groups by hand! There HAS to
be a better way? Can anyone share it with me please?
Well, probably your logins do have roles as well, so
you need to bcp out/in syssrvroles and sysloginroles.
Also check the master..s...How to copy data from one database to another
I want to update the data from one sqlanywhere database to another sql
I know we can do this in other databases like Oracle and Sybase. How I can
do this in
SQLANYWHERE version 5.5.04 build 1867.
Any help would highly appreciated.
You can use the
statements that are part of ISQL.
For better raw performance you can use
which are server commands (sent to the server
'via' isql but there server does all the reading
&q...copying a table from one database to another
in query analyzer, how do you copy a table form one db to another db
i thort it was something like
select * into dbo.databaseA.tableNew from dbo.databaseB.tableOld
insert into databaseA..tableNew
select * From databaseb..tableOld
The difference between SELECT INTO and INSERT INTO is that with INSERT the table must already exist. SELECT INTO creates a new table. Your original query looked okay, assuming that you wanted a new table tableNew. What error were you getting? You might also have a permissions problem since you are going from one database to a...