Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 CLONING SQL DATABASE

Author  Topic 

ERIKAFF
Starting Member

2 Posts

Posted - 2008-01-28 : 14:05:01
Tengo una aplicacion desarrollada en POWERBUILDER y accede a una base de Datos SQL, deseo utilizar la misma aplicacion para acceder a otra base de Datos SQL en el mismo servidor. La segunda Base de Datos tiene que ser inicialmente un clon del original para hacer pruebas con los mismos usuarios. A nivel de la aplicacion puedo solucionar cambiando los parametros de nombre de base de datos, pero como puedo hacer a nivel del servidor?.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-01-28 : 14:11:32
spanish anyone?

courtesy of Babelfish:

I have an application developed in POWERBUILDER and accedes to a
data base SQL, desire to use the same application to accede to
another data base SQL in the same servant. Second Base de Datos must
be initially a clone of the original one to test with such usuary. At
level of the application I can solve changing the parametros of name
of data base, but since I can do at level of the servant.


so my answer to this would be:
to access another database from your application you have to change the connection string.
again courtesy of babelfish

para tener acceso a otra base de datos de su uso usted tiene que cambiar la secuencia de la conexión.



_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out
Go to Top of Page

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2008-01-28 : 14:38:29
SWEET! Can you please translate that to Yiddish now?

Be One with the Optimizer
TG
Go to Top of Page
   

- Advertisement -