Is it possible to define the database connection at the time of publishing a service definition? Here is the desired workflow:
1. Create a service definition through ArcGIS Desktop with 'feature access' capability.
2. Select 'no available connection', 'include data in service definition when publishing'
3. Move the service definition to another environment
4. Publish the service definition AND specify the database connection.
What is happening is that the data is being copied into the managed database. The ideal scenario is that it is copied into another referenced SQL Server database. Is this possible?