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.
| Author |
Topic |
|
knajafi
Starting Member
4 Posts |
 Posted - 2012-02-27 : 11:04:47
|
I have a SQL express database in two stores which is using 3rd part software but a sql express database holds all the patient information.I would like to merge the data from one database to another but keep the existing information in the database its going to so not a backup and restore but a migration.Sorry am new to database admin  Any help would be appreciated. |
|
|
knajafi
Starting Member
4 Posts |
Posted - 2012-02-27 : 11:06:09
|
| Sorry the version is 2005 -please tell me what info you need and I can get this |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-02-28 : 01:44:12
|
| If you have 2 databases , are the various data sets in their own tables? Is it just a case of migrating some tables - and then changeing your connection strings?Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
knajafi
Starting Member
4 Posts |
Posted - 2012-02-28 : 12:40:23
|
| HiThe databases have the exact same name and same tables setup in the databases just the ifnormation is different. Some of the information held is patients first and surname, reference to a jpeg image, sorage path. I dont know which tables are currently being used as there are a lot of tables setup in the database but not all fields are used.Sorry i am a complete novice to this so please excuse my ignorance |
|
|
|
zazaza006
Starting Member
1 Post |
Posted - 2012-02-28 : 21:04:12
|
| Lately, instructor has introduced the instructor Factory Outlet Keep [url=http://www.coachfactoryoutletonline-s.com/]Coach factory outlet online[/url], a choice of storefronts spanning the planet that provide precisely exactly the very same instructor Coach Factory on the internet purses which you just would typically acquire within of the normal keep, at a fraction even although in the cost. Supplied theirlarge specifications in workmanship [url=http://www.coachfactoryoutletonline-s.com/]Coach factory outlet[/url], the exceptional of the instructor purse is unrivaled – even when in comparison to other mainstream purse designers. possessing stated that, using the mass amount of purses that instructor manufactures calendar yr in and yr out [url=http://www.coachfactoryoutletonline-s.com/]Coach outlet online[/url], it goes without any saying that some typically do not satisfy their specifications of perfection. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-03-01 : 14:00:05
|
| You'll need to go through a data cleaning exercising and merge the dataJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
knajafi
Starting Member
4 Posts |
Posted - 2012-03-07 : 05:36:10
|
| Jack,That sounds like a good plan but is there any instructions on how to do the cleansing and merging data?Complete novice to this. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-03-08 : 01:41:56
|
| This will depend on certain factors , such as : amount of data , missing information, etcOne method is to load everything into one staging table and proceed to manually validate all data . Use t-sql to create a statement tp indentify disparities.Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
|
|
SQL Express