Search Results

Search found 87891 results on 3516 pages for 'server migration'.

Page 526/3516 | < Previous Page | 522 523 524 525 526 527 528 529 530 531 532 533  | Next Page >

• How to execute big SQL files on SQL Server?

  - by Alon

  I have about 50 T-SQL files, some of them are 30MB but some of them are 700MB. I thought on executing them manually, but if the file is bigger than 10MB it throws an out of memory exception on the SQL Server Management Studio. Any ideas?

  Read the article

• how to show only even or odd rows in sql server 2008 ?

  - by Gold

  hi i have a table MEN in sql server 2008 that contain 150 rows. how i can show only the even or only the odd rows ? thank's in advance

  Read the article

• extract transform load

  - by mitch

  Wikipedia defines a 'typical' ETL cycle as : Cycle initiation Build reference data Extract (from sources) Validate Transform (clean, apply business rules, check for data integrity, create aggregates or disaggregates) Stage (load into staging tables, if used) Audit reports (for example, on compliance with business rules. Also, in case of failure, helps to diagnose/repair) Publish (to target tables) Archive Clean up ..What is meant by 'Build reference data'?

  Read the article

• In SQL Server, how do I know what transaction mode I'm currently using?

  - by Yousui

  Hi guys, In SQL Server, how do I know what transaction mode I'm currently using? Such as autocommit, explicit, or implicit. And how can I change one mode to another using tsql? Great thanks.

  Read the article

• How do I add a record only if it doesn't already exist in SQL Server?

  - by menacheb

  Hi, I have a project in C# with a Sql-server Database. In that database I have a table named 'Process' and columns named 'process_name', 'Full_Name' and 'Version' (all of the type:nvarchar(50)). I want to write a query wich will add the new process, only if it doesn't exist in the table yet. How can I do that? Many thanks,

  Read the article

• Has anyone tried vss2git?

  - by Radicalise

  OK, so I have started a contract where they are using (gulp) Visual SourceSafe and are looking to move to something better. I have recommended Git. I stumbled across vss2git, which looks useful for migrating from VSS. Has anyone used it? Many thanks!

  Read the article

• Do I need to translate (local) in a sql server connection string?

  - by DanDan

  When connecting to sql server, I have the hardcoded string "(local)". Is this a string I need to make available for localisation? ie, does (local) always work no matter the current language settings?

  Read the article

• In SQL Server, how can I execute a piece of tsql against all databases in an instance?

  - by Yousui

  Hi guys, In SQL Server, how can I execute a piece of tsql against all databases in an instance? Great thanks.

  Read the article

• Git svn - no changes, no branches (except master), rebase/info is not working

  - by ex3v

  I know that similar questions were asked before, but I think my is a little bit different, so please don't point me to existing threads. I'm migrating our old svn repo to git. I did git svn clone path --authors-file abc.txt and everything seemend legit to me. Then I did git remote add origin xyz and git push --all origin and it also worked. I created this repo as test one, with only me having access to both local repo and origin. No changes were made in project held on this repo, nothing to commit, no pushing and so on. There is also only one branch, because someone initialized svn years ago without creating proper folder structure (branches, trunk, tags). Meanwhile someone pushed their work to svn, so I tried to git svn fetch (which worked), and git svn rebase which didn't, giving me error: Unable to determine upstream SVN information from working tree history Is there any reason why git svn decided to stop working?

  Read the article

• migrate/ update core data app without erasing user data!

  - by treasure

  hello, i have a very complicated problem that i would like to share with you and maybe someone can answer it for me. before i start i have to say that i am very new in this. So, i have a coredata iphone app (much like the recipes app) that uses a pre-populated sql database. The user can add/edit his own data but the default data cannot be deleted. the useres data are ALL saved in the same sql database. QUESTION: what do i have to do in order to: - update some (not all) of the default data that are stored in the sql database without "touching" the user's data? (the model will stay the same - no new entities etc-) (if the user uninstall the app and then reinstall the new version everything will be ok but i dont want to do this, obviously). can someone PLEASE help in coding level?

  Read the article

• Looking for a tool that can return SPs doing a DML on a table in SQL Server 2008

  - by Kiran

  I am working on a big application on SQL Server 2008 with 60 000 stored procedures and over 10 000 tables. Is there a tool through which I can do impact analysis to find out all SPs doing a DML on a table?

  Read the article

• Can i make SQl Server 2005 Table Column accept only letter and numbers ?

  - by Space Cracker

  When we have a column that will store a username that will only accept letters and numbers we always do validation on this input field using javascript or even server validation from code .. but i want to know if is there any way that can allow me make this validation on the Table column itself even some one try to enter data from any place it don't accept and throw exception ?

  Read the article

• How to migrate Django models from mysql to sqlite (or between any two database systems)?

  - by Daphna Shezaf

  I have a Django deployment in production that uses MySQL. I would like to do further development with SQLite, so I would like to import my existing data to an SQLite database. I There is a shell script here to convert a general MySQL dump to SQLite, but it didn't work for me (apparently the general problem isn't easy). I figured doing this using the Django models must be much easier. How would you do this? Does anyone have any script to do this?

  Read the article

• Is there any reasonable way to migrate from subversion to cvs?

  - by stu

  My company unwittingly switched from cvs to subversion and now we're all wishing we had cvs back. I know there's tools to migrate history and changes from cvs to svn and there's no equivalent to do the reverse. Any suggestions or ideas on how to do this?

  Read the article

• In SQL Server 2008 is there a way to generate a report as to how much space on disk each table takes

  - by Matt

  IN SQL Server 2008 is there a way to generate a report as to how much space on disk each table takes? I can do it one by one by checking the storage properties, but I was wondering if there was a way, maybe even a query to generate such a report.

  Read the article

• How to set user environment variables in Windows Server 2008 R2 as a normal user?

  - by likm

  In older versions of Windows, it was just open the Control Panel, select the System applet, select the Advanced tab, and then hit the Environment variables button. As a normal user, you could edit the "User variables" but not the "System variables". In Windows Server 2008 R2, if I try to hit the Advanced System settings option in the System applet, it prompts for the Administrator password.

  Read the article

• run threads on server side & show progress on client side possible???

  - by Aizaz

  I want to run a thread pool on server side & want to show threads work progress on client side. Is this possible. If so kindly guide me. thanx in advance

  Read the article

• Should I use "User Defined Functions" in SQL server, or C#?

  - by sanity

  I have a fairly complicated mathematical function that I've been advised should be implemented as a User Defined Function in SQL Server so that it can be used efficiently from within a SQL query. The problem is that it must be very efficient as it may be executed thousands of times per second, and I subsequently heard that UDFs are very inefficient. Someone suggested that I could implement the function in C# instead, and that this would be much more efficient. What should I do?

  Read the article

• How can I estimate server costs for creating an app?

  - by G Dottin

  Im writing up a business plan and im having some trouble with the finance part. I put an estimate on the cost of developers, web designers and everything but server costs. Im not a programmer so I dont know all the details. But how much would you think servers are going to cost for a complex app. I cant get into too many details but it keeps track of user preferences, stores data about the user and there is quite alot of back-end to it.

  Read the article

• Migrating from Subversion to Git how can I find a commit given a revision number?

  - by Patrick Allaert

  Migrating from Subversion to Git using svn2git (which internally uses git-svn) I'd like to know how I can find a specific revision commit. It is quite common to have issues tracker to have comments like: "Fixed in r12345". Given this, I'd like to be able, for example, to extract the diff corresponding to r12345. Thanks in advance. Regards

  Read the article

• Is there any SQL Server database designer software like MySQL workbench?

  - by newbie

  I need to design database for SQL Server, is there any MySQL workbench like software for that? I have access to MSDN, so it can also be commercial product that can be found form MSDN.

  Read the article

• In SQL Server, how can I separate a large number of tsql statement into batches?

  - by Yousui

  Hi guys, In SQL Server, how can I separate a large number of tsql statement into batches? Should I use the GO statement in stored procedures or functions? Should I use the GO statement in explicit transaction management situation(between BEGIN TRANSACTION and ROLLBACK TRANSACTION or COMMIT TRANSACTION)? Are there some best practice about this topic? Great thanks in advance.

  Read the article

• How can upload image URL in SQL server and retrieve in grid view using ASP.NET?

  - by kalaiselvi

  How to upload image URL in SQL server and retrieve in grid view using ASP.NET? Can you point me to any tutorials and/or sample code?

  Read the article

• Is there a way to have SQL server validate object references in Stored Procs?

  - by Scott Weinstein

  The following code executes fine in SQL Server create proc IamBrokenAndDontKnowIt as select * from tablewhichdoesnotexist Of course if I try to run it, it fails with Invalid object name 'tablewhichdoesnotexist'. Is there any way to compile or verify that Stored Proc are valid?

  Read the article

• Can anyone recommend a java FOSS server that does all the typical protocols (ssh etc).

  - by mP

  I would like to add the ability for users to telnet into my app where by they can type in commands etc. I would like a simple Java Telnet server whereby i can provide the authentication strategy.

  Read the article

< Previous Page | 522 523 524 525 526 527 528 529 530 531 532 533  | Next Page >