Re: Merging two sql databases


"Rik" <luiheidsgoeroe@xxxxxxxxxxx> wrote in message
news:581e0$45ad2fed$8259c69c$26539@xxxxxxxxxxxxxxxxxxx
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



It is MySql database.
Do you mean that I supposed to install a database I bought than work on
that? I thought that I can merge sqls in a special program.
If so please tell me where I supposed to write the code you posted? (ALTER
TABLE table_name RENAME normal_database_name.table_name)
I am new to sql database so I am not sure what to do?

Andy



.

Relevant Pages

  • Re: Cannot Open SQL Server Table in Access.ADP File.
    ... I dont think that SQL Server will take 'veiw dependencies' into effect; ... Generate Script Wizard did not work on my original database, ... After fixing some of my tables and a few stored procedures and views, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Enterprise Manager Newbie Question
    ... a SQL backup is not a simple copy of the database files. ... Is it possible to write a script that one could run from a workstation and ...
    (microsoft.public.sqlserver.tools)
  • Re: SQL Security
    ... except I'm having problems making it work in a script. ... ;Set properties of DB objects and open connection to database ... > from Books Online (within the SQL Server program group): ... > communicate with SQL Server. ...
    (microsoft.public.sqlserver.server)
  • Re: Vista hosting XPe tools/db
    ... Are you running this script on the machine that actually has the SQL server ... machine hosting the database. ... i don't know if you can install a second instance of SQL ...
    (microsoft.public.windowsxp.embedded)
  • Re: dbdebunk Quote of Week comment
    ... > a lot of really bad SQL programmers. ... But SQL does not have a pointer data type or the ... > being told to design a database. ... But why is little Cindy Lou Who employee ...
    (comp.databases.theory)