[SQL 2012] Single Data Base with Multiple Schemas |
- Single Data Base with Multiple Schemas
- SQL server cluster Failover installation
- SSIS Package created in SQL 2008
- LABEL ON COLUMN
| Single Data Base with Multiple Schemas Posted: 09 Sep 2013 11:48 AM PDT Hi, my name is Carlos, I'm using SQL Server 2012, and I have a situation, my boss wants to integrate every Data Base in one single, but I'm not sure 'cause maintenance will become hard. By example, One of those DBs, belongs to a real-state sales management (17 GB), another DB to a judicial processes management (5 GB), the backup time will increase, if something goes wrong with files or schemas, every Application will be afected. Well, my questions are:In which cases is recommended doing this centralization? What are the best practicess recommended? thanks for comments, regards. |
| SQL server cluster Failover installation Posted: 30 Jul 2013 01:16 AM PDT Hi guys i am supposed to do a failover installation on Windows server.I have to create a cluster group, Do any one know any site or video or notes which guides me to get prepared.Rookie here :hehe: |
| SSIS Package created in SQL 2008 Posted: 09 Sep 2013 08:33 AM PDT Hello EveryoneI have some SSIS packages that were created in SQL 2008, I am moving all the packages to SQL 2012. What should I look for, or be aware of when I create the SQL jobs in SQL 2012 for the 2008 packages? I have already found the Provider=SQLNCLI10.1 to Provider=SQLNCLI11.1Does anyone have a sample of the command line? The one that SQL Job creates is giving me a warning.Here is what SQL generated:[quote]/DTS "\"\MSDB\TestAndDev\Andrew\"" /SERVER Mistress /CONFIGFILE "\"D:\TestAndDev\SSIS Packages\Andrew\XMLConfig\TestAndDev_XMLConfig.dtsConfig\"" /WARNASERROR /VALIDATE /REPORTING E[/quote]But the Pre Execute validation is giving an error in the command line. When I execute the package, it indicates a Success, but does not get past the second step, which is a ScriptTaskThanks in advanceAndrew SQLDBA |
| Posted: 09 Sep 2013 09:21 AM PDT I use SQL to create tables. In DB2 on IBM iSeries I use:LABEL ON COLUMN IS and TEXT IS ?example:LABEL ON COLUMN JMALIBX.FDKEYS ( APRCEN IS 'Retrieval Century' , APRCEN TEXT IS 'Retrieval century: 0=19xx, 1=20xx' , what is the difference between these for other databases like MySQL etc.. |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2012 / SQL 2012 - General To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment