Re: Merging two sql databases

Andy wrote:
Please tell me how to merge two sql databases.

Huh? Sql databases? What kind?

Do you know any tutorial about it?
What I want, is to insert data from sql I bought into sql which came
with a website's script. Sql I bought has only one table containing 4
fields: id, name, ingredients, procedure.
Thank you in advance.


Hoepfully you have a user with permission on both databases. If so, choose
to work on the 'extra' database and:

ALTER TABLE table_name RENAME normal_database_name.table_name
--
Rik Wasmus


.

Relevant Pages

  • Re: Recovery Model Question.
    ... Take the result of the script, paste in into a query window and execute it. ... I run this sql script through Query Analyzer: ... to any databases!I check the recovery model and remains unfortunately full in all databases.. ...
    (microsoft.public.sqlserver.tools)
  • Script log-shipping configuration and steps for disaster recovery
    ... I am making the disaster recovery plan for the sql 2005 databases at ... of script this so I just run the script for the rest of the databases ... instead of going through the wizard 40 times. ...
    (microsoft.public.sqlserver.replication)
  • Re: BizTalk eating up SQL Server (Virii Behaviour)
    ... Yes, one gig is the least to run sql & bts in the same box, ... uninstall procedure, i manually deleted all databases, and run the ... and it was leaving like 20 mbs free memory, ... BizTalk Solution Developer ...
    (microsoft.public.biztalk.general)
  • Re: Dont understand what version of SQL to install
    ... I'm talking about developing and testing databases for my client and ... To my XP, I can add SQL Developer 2008 to develop (I guess I should say, ... So I can use SQL Developer 2008 to create a database in standard 2005, ... installed on Client OSs such as Windows Vista. ...
    (microsoft.public.sqlserver.setup)
  • Re: Relational-to-OOP Tax
    ... Many SQL vendors has text mining features. ... Tutorial D isn't availible in production databases. ... The Third Manifesto,2 object functionality and the relational model are ...
    (comp.object)