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
Post a Comment