dataset - editing vb.net data connections and data sources -


i've inherited vb.net application developed against production sql-server database. have development sql-server , want make sure development work done against development copy of data. deploy application production , have run against production sql-server.

i've added logic application startup of first form checks see whether should run against development or production server, can set connection string , that's working.

but there several "data sources" defined, , using 2 different "data connections". think i'd have 1 data connection , have point development copy of data.

if database has 50 tables , 5 forms, make sense have 1 "data connection", multiple data sources of data sources have 1 data set , of them have multiple data sets (they nested)? or thinking these objects properly?

you can either way, whatever fancy. depends how want work, system has 3 connections different sources. nice put in 1 place, have hassle of moving around. having split means need know is, , have correct naming conventions can identify connecting onto. datasource = "devserverproduction1" or datasource = "liveserverproduction1". on every table adapter.

i inherited crap system didn't have development environment, made new connection dev server copy of live 1 , changed connection string dev connection, when ready publish changed connection string live connection.

just make sure backup live programming files before publish, encase goes wrong can revert back.


Comments

Popular posts from this blog

ubuntu - PHP script to find files of certain extensions in a directory, returns populated array when run in browser, but empty array when run from terminal -

php - How can i create a user dashboard -

javascript - How to detect toggling of the fullscreen-toolbar in jQuery Mobile? -