Refreshing Test Database To Live Database
So I have two identical SQL Server databases, one is for testing, one is for Live Production. The table and fields are the same so I thought of just changing the Database Setup to point to a different database. However what I end up having to do is refresh the drop down properties on each object that links to a field.
Is there an easier way to refresh the fields so they update from a test database to live? Is there another intended method for testing Bartender on a SQL Server?
Thank you in advance.
radvin
-
Shotaro Ito
★ BarTender Hero ★
For OLEDB Connection to SQL Server,
When database name and table name is the same, you should be able to use the same document by..
- Database connection setup > Options > Setup, specify server and database.
or
- Re-create database connection. Remove current database connection then create new connection.
In case database name and/or table name has changed, you can modify database / table alias to match original name to keep current field definition on label objects.
On Database connection setup, left tree, right click database name or table name then Edit Alias..
0 -
Thank you Shotaro, this will really help us!
Arigatou Gozaimasu!
0 -
Shotaro,
Is there a way to change the Alias using VBA code from Excel ? I want to try to avoid two sets of templates but they would by default be attached to the same database which wouldn't be good int he test environment. I tried looking thru the forums and Google but no one seems to talk about the database setup using VBA.
Thanks,
radvin
0 -
Shotaro Ito
★ BarTender Hero ★
Unfortunately, there's no way you can modify alias from VBA.
Pehaps you can use ODBC connection and modify some parameter in ODBC data source.
0 -
Shotaro,
So instead of the ODBC changes I will be doing the Export Image as you talked a lot about on other posts. The only thing I can't get to work is setting the Logo images on the template.
Using btFormat.ExportToFile (I only have Automation), I can set the value from my Excel tool using SetNamedSubStringValue for each field, but I also have an image that needs to be 'previewed' in the export. Is there something that can be done with this for ExportToFile ? Just checking before I have Excel do that part. Thank you.
0 -
Shotaro Ito
★ BarTender Hero ★
Radvin,
When you need to change logo image from code, create a datasource picture on template, then give name to its data source. Then you can give path of the image file by SetNamedSubStringValue.
it would work with ExportToFile too.
0
Vous devez vous connecter pour laisser un commentaire.
Commentaires
6 commentaires