Don't take over the Clipboard

While migrating data anything put in the "Results" tab gets put into the clipboard. This doesn't seem like it should be doing that without me doing anything. Makes the clipboard unusable during mi...

Id #7878 | Release: None | Updated: Sep 4 at 2:22 PM by ghuey | Created: Sep 4 at 1:19 AM by dkarzon

No its not wroking for large database

After checking "sorting object by dependency" its stopped working. Giving below error or message in "Result Summary" Process started at 6/13/2014 2:01:17 PM -- UTC -> 6/13/2014 8:31:17 AM ... Logi...

Id #7835 | Release: None | Updated: Jun 19 at 5:17 AM by bsukhwal | Created: Jun 13 at 8:48 AM by bsukhwal

Trying to download v4

It would help a bit if the main project page could indicate that the v4 download is NOT available on the nice big purple button! Either a link in the text under the button to the latest v4 download...

Id #7789 | Release: None | Updated: Mar 20 at 11:44 AM by ghytred | Created: Mar 17 at 2:57 PM by ghytred

SQLAzureMWBatchBackup: SourceServerType vs TargetServerType mismatch in application config

Hello, I noticed that latest version (4.0.17.1) of SQLAzureMWBatchBackup has invalid data in app.config. SMOScriptOptions.cs uses configuration key TargetServerType while app.config provides key S...

Id #7786 | Release: None | Updated: Mar 12 at 2:09 PM by ghuey | Created: Mar 12 at 9:29 AM by jarete

Error reference ExceptionMessageBox

Hello, there are some issues about the reference "Microsoft.ExceptionMessageBox". I try run the binary in Windows 8.1 but I can't. Where I can find this component? To resolve, I did this change...

Id #7785 | Release: None | Updated: Sep 5 at 9:14 PM by brianunikey | Created: Mar 11 at 2:08 PM by educoutinho

SqlMW throws exception

Great tool, mostly works nicely, however when downloading a database from Azure, it completes the scripting and bcp out, the next step is to connect to a local Sql Server - at that point it throws ...

Id #7773 | Release: None | Updated: Feb 25 at 9:04 PM by ghuey | Created: Feb 24 at 10:02 AM by LegacyOfHerot

Umlauts and Accentchars not shown correctly

As source database server we use SQL Server 2012, the destination database is Microsoft Azure SQL server. In Version v3.9.14.1 all Chars are shown correctly after migration, now we used the v4.0....

Id #7769 | Release: None | Updated: Mar 14 at 8:38 PM by raphaelsamy | Created: Feb 18 at 12:53 PM by srakel

v4.0.17.1 hangs? Accented characters?

Hi, Your app has gotten me the closet to getting my two troublesome DBs converted over the SQL Azure, but I am running into 2 issues: 1) The app deploys all of my table to SQL Azure very quickly,...

Id #7754 | Release: None | Updated: Feb 10 at 2:53 AM by ghuey | Created: Feb 9 at 12:57 AM by wcwilson

BatchBackup ignores ScriptDropCreate config key

The app.config key "ScriptDropCreate" is ignored by the BatchBackup application. Only the interactive application seems to use it. This is an issue for me because I'm using BatchBackup and BatchUpl...

Id #7734 | Release: None | Updated: Jan 14 at 8:14 PM by ghuey | Created: Jan 14 at 12:44 PM by amontgomery

<Null> values converted to zero

I have an interesting discovery, when publishing to Azure I find that on some fields that are involved in calculated columns, if the existing value is <null> it is transposed to a zero after publis...

Id #7715 | Release: None | Updated: Dec 22, 2013 at 3:25 AM by ghuey | Created: Dec 21, 2013 at 5:43 PM by javamarket

Invalid schema generation in Azure Federation databases

There seems to be a bug when generating CREATE TABLE clauses in federated databases. Example: CREATE TABLE [dbo].[Table]( ... )FEDERATED ON (...) FEDERATED ON (...) As you can see, the "FEDE...

Id #7666 | Release: None | Updated: Nov 15, 2013 at 5:20 PM by ghuey | Created: Nov 11, 2013 at 9:41 AM by jarete

False positive on UpdateText

When running the analyzer against one of my databases, I get a UpdateText is not supported in the current version of SQL Azure I don't use UpdateText but have a stored procedure named uspUpdateT...

Id #7638 | Release: None | Updated: Oct 21, 2013 at 1:55 PM by ghuey | Created: Oct 20, 2013 at 9:59 AM by Hahndorf

Copying of null floats

Hello, We have a table that contains a float column that allows nulls. When copying to azure the result is that the null float columns are converted in to the value 0. I can't see this happening ...

Id #7630 | Release: None | Updated: Mar 20 at 7:06 PM by JohanDanforth | Created: Oct 14, 2013 at 7:25 AM by gerrymc_dev

Syntax error dropping database with special characters

If the database name contains special characters (like '-', ie. system-6b2d892e-34b5-4b7e-bd3f-0882c26062f6 for a federation db), the drop database command(TargetProcessor.CreateDatabase) fails w...

Id #7626 | Release: None | Updated: Feb 11 at 2:45 PM by dilettante | Created: Oct 8, 2013 at 7:54 PM by michaelaird

IndexOutOfRangeException when moving large amounts of data

Hi, We are using SQL Server 2012 with version 4.0.15. Very often when we copy somewhat large (biggest tables containing 1 to 10 million rows) databases to Azure, tool crashes with IndexOutOfRangeE...

Id #7614 | Release: None | Updated: Sep 27, 2013 at 7:40 AM by jarete | Created: Sep 26, 2013 at 10:36 AM by jarete

Method not found: 'Microsoft.SqlServer.Management.Common.DatabaseEngineType Microsoft.SqlServer.Management.Common.ConnectionManager.get_DatabaseEngineType()'.

I keep getting the above error when I run v3.9.12 to migrate MSSQL local database to Amazon RDS. Not sure what I am missing....can anyone help?

Id #7567 | Release: None | Updated: Aug 23, 2013 at 10:41 PM by Dolfintown | Created: Aug 19, 2013 at 9:24 PM by Dolfintown

Azure upload timeout

Hi, We are moving our database to SQL Azure, and I am having issues at upload. It times out after some time, which I figured out is due to batch size. I changed the batch size from 10000 to 1000, ...

Id #7535 | Release: None | Updated: Jul 25, 2013 at 8:54 PM by ghuey | Created: Jul 25, 2013 at 6:30 PM by bilalm

Missing table(s) in exported data

Hi, I've noticed that while exporting big databases (> 100 GB) from Azure it happens sometimes that there are bulk copy data missing in the output folder for some tables. It doesn't happen all the...

Id #7522 | Release: None | Updated: Mar 20 at 12:40 PM by michaelaird | Created: Jul 16, 2013 at 3:48 PM by tiny

Problem with run

I have problem with launch programm see sreenshot

Id #7518 | Release: None | Updated: Jul 11, 2013 at 7:10 PM by nim_cch | Created: Jul 10, 2013 at 12:08 PM by nim_cch

Problem with CodePage (Solved by using RAW)

There are problems with some characters like : "À" when using the default CodePage 437. This character will be transformed to "A" in destination database, so if your DB is Accent Sensitive it'll ...

Id #7488 | Release: None | Updated: Oct 26, 2013 at 1:29 AM by augustocamargo | Created: Jun 18, 2013 at 7:02 AM by visualbruno

Unable to install SQL Database Migration Wizard v3.9.12 & v4.0.15

I am having problems installing the SQL Database Migration Wizard v3.9.12 & v4.0.15 I am trying to install it in Windows 2008 R2 server, I get an error "Sorry,but dependencies for SQLAzureMW are mi...

Id #7392 | Release: None | Updated: Sep 5 at 8:07 PM by ghuey | Created: Apr 9, 2013 at 10:24 PM by techranger

Login timeout for BCP

Hi, I tried migrate a db, and it worked fine until the BCP (version 10.50.2500.0) was going to upload the data. Then it stopped after a while saying "login timeout". The structure (tables and views...

Id #7292 | Release: None | Updated: Feb 21, 2013 at 11:59 PM by prgjonas | Created: Feb 3, 2013 at 5:27 AM by prgjonas

Only schema is getting copied and no data

I am trying to copy the sql azure database to sql server. I tried sql server 2008 R2 and sql sever 2012. This utility only copies the schema over but not data. Is this a bug being worked on or I am...

Id #7218 | Release: None | Updated: Mar 13 at 2:12 PM by Maorrin | Created: Dec 1, 2012 at 9:12 PM by mvcdeveloper

Copy Azure DB -> Local Sql Server

Hi guys, as soon as I try to connect the source database to azure it fails with an index out of range exception. Please have a look at the screenshot Thx Gerhard

Id #7171 | Release: None | Updated: Feb 21, 2013 at 11:59 PM by ghuey | Created: Oct 19, 2012 at 6:08 AM by BitKFu

Not for replication not completely cleaned out

After generating the schema for a DB, I have many statements that have "NOT FOR REPLICATION"

Id #7170 | Release: None | Updated: Feb 21, 2013 at 11:59 PM by ghuey | Created: Oct 17, 2012 at 1:47 AM by Davd_Molina

Silent Failure of BCP Upload when Azure SQL DB name contains a "."

All data successfully exports out of my MS SQL database - .dat files are generated and the SQL is created. The database name was formatted as "XXXX.YY-AAAA1" I connected to my Azure SQL server an...

Id #7168 | Release: None | Updated: Jul 31, 2013 at 10:27 PM by ghuey | Created: Oct 16, 2012 at 9:17 PM by nate_leanserver

Method Not Found exception

Tested on version 3.8.9 and latest stable versions 3.9.6:   After connecting to a local instance running SQL server version 9.0.5000 and choosing a database and hitting next the following comes up ...

Id #7142 | Release: None | Updated: Feb 21, 2013 at 11:59 PM by ghuey | Created: Sep 26, 2012 at 9:45 AM by AlanSMac

Could not open connection to SQL Server Error:53 the network path was not found

i am trying to migrate database from sql server 2008 sp1 and 2012, in management studio, i am trying to connect to sql azure db, for this, Connect to database engine, enter my server name, login an...

Id #7112 | Release: None | Updated: Feb 21, 2013 at 11:59 PM by chinnarao | Created: Sep 12, 2012 at 1:19 AM by chinnarao

Crashed on last step: Scripting

On the last step where the application starts scripting it crashed,I've tried to debug the application to see what exactly is the issue and it was "Index was outside the bounds of the array." , her...

Id #7109 | Release: None | Updated: Feb 21, 2013 at 11:59 PM by ghuey | Created: Sep 11, 2012 at 8:17 AM by Alaa9jo

SQLAzureMWBatchUpload cannot work against local SQL Server

I use SQL MW to download databazes from cloud locally from command line. When I try to use SQLAzureMWBatchUpload.exe in order to "upload" data to local SQL Server, I get the following error:   SQLA...

Id #7078 | Release: None | Updated: Feb 21, 2013 at 11:59 PM by tiny | Created: Aug 16, 2012 at 2:43 PM by tiny

SQLAzureMWBatchBackup Failed to connect to server

I run SQLAzureMWBatchBackup.exe successfully by SqlAzure's admin user, but when I changed the user which I created by myself, it shows "Failed to connect to server". I solved it by add same user in...

Id #7048 | Release: None | Updated: Feb 21, 2013 at 11:59 PM by madloo | Created: Jul 30, 2012 at 2:58 AM by madloo

Cannot connect to SQL Azure with Migration Wizard.

I am trying to migrate a Microsoft Access 2010 database to SQL Azure, and am getting the following error from the wizard:   "Connection to SQL Azure Failed. A network-related or instance-specific ...

Id #7047 | Release: None | Updated: Feb 21, 2013 at 11:59 PM by wkelliott | Created: Jul 29, 2012 at 7:11 PM by wkelliott

Failed to connect to Database when connect to sqlazure

I saw one issue has exactly same problem. (http://sqlazuremw.codeplex.com/workitem/6987)   what i want to do is generate script.   it works good if i migrate sql server to sql azure.   but when i w...

Id #7014 | Release: None | Updated: Feb 21, 2013 at 11:59 PM by samluo001 | Created: Jun 28, 2012 at 7:06 AM by bobaman

Failed to migrate 'filtered index', which caused data migrate failure

Running SQL Azure Migration Wizard version 3.8.9.0 to migrate a database from SQL 2008 R2 (10.50.2500) - I started with a completely empty target Azure database, so both the schema script was run a...

Id #7001 | Release: None | Updated: Feb 21, 2013 at 11:59 PM by gresziu | Created: Jun 20, 2012 at 7:42 PM by jmanning

Migration Wizard crashed on last step (logging into SQL Azure)

Reason: Usage of ";" in logon password   Resolution: Change logon password Can be done with SQL Server Management Studio ALTER LOGIN [AdminName] WITH PASSWORD = '[1234567!]'   Use Characters That...

Id #6995 | Release: None | Updated: Feb 11 at 9:32 PM by ghuey | Created: Jun 15, 2012 at 11:55 PM by saeynico

Failed to connect to Database

I've been using the SQL Azure Migration Wizard for a long time now, been working great. But today all of a sudden, it stopped working right. I can connect fine to the server, but when I try to choo...

Id #6987 | Release: None | Updated: Jun 24, 2013 at 2:28 AM by thavo | Created: Jun 11, 2012 at 12:15 AM by michaelyd

Original text encoding changed

Analyze TSQL file changes the text encoding in the target. For example,   Mykolaïvs changed to Mykolaïvs

Id #6938 | Release: None | Updated: Feb 21, 2013 at 11:59 PM by ghuey | Created: May 10, 2012 at 10:33 PM by Giavinh

Incorrectly remove comments

When I analyzed the TSQL script, the tool incorrectly removed the comments which contains TSQL statements inside the comment.   /* USE [MyDatabase]; IF EXISTS (SELECT * FROM sys.objects WHERE obje...

Id #6937 | Release: None | Updated: Feb 21, 2013 at 11:59 PM by ghuey | Created: May 10, 2012 at 8:50 PM by Giavinh

"SELECT INTO statement is not supported": regex pattern match issue

If an SQL statement uses a CTE that contains an MERGE/INSERT INTO clause the regex fails. Using SQLAzureMW 3.8.6 with the pattern "SELECT[\w\W][^;]*\sINTO" against a statement such as ";WITH cte AS...

Id #6907 | Release: None | Updated: May 26 at 3:30 PM by ghuey | Created: Apr 24, 2012 at 9:08 AM by AndyKrafft

Changing index to a clustered index does not remove INCLUDE columns

When SQLAzureMW forces a change of an index to a clustered one (because it detects that there is no such index on a table; mandatory in Azure) it scripts the CREATE INDEX statement with the CLUSTER...

Id #6906 | Release: None | Updated: Feb 21, 2013 at 11:59 PM by ghuey | Created: Apr 24, 2012 at 8:49 AM by AndyKrafft

Operand type clash: image is incompatible with geography

Hi   I have SQL 2008 Express R2 SP1 using SQLAzureMW v3.8.2.   When running the migration the code is generated fine, but when I execute the script against the SQL Azure server I get the error:   S...

Id #6891 | Release: None | Updated: Feb 21, 2013 at 11:59 PM by JamesEinTech | Created: Apr 13, 2012 at 11:23 AM by JamesEinTech

Could not load file or assembly

I get this error right after I select Analyze / Migrate "SQL Database" and hit the next button.

Id #6825 | Release: None | Updated: Feb 21, 2013 at 11:59 PM by ghuey | Created: Mar 7, 2012 at 3:38 PM by fdbaird

Make more robust sample database

To create tests we need more records, various fields' types, different types of relationships between entities and different types of federation keys.

Id #6804 | Release: None | Updated: Feb 21, 2013 at 11:59 PM by ghuey | Created: Feb 24, 2012 at 4:08 PM by mglukhankov

Data Difference after export

I noticed a data discrepancy after I migrated from SQL 2008 r2 to windows SQL azure. The error is with primary key 2099. It did have three dots at the end of the search_code field and after the mig...

Id #6794 | Release: None | Updated: Feb 21, 2013 at 11:59 PM by ghuey | Created: Feb 22, 2012 at 3:35 AM by mattdone

Doesn't run on Compute

I tried to run the wizard on my compute instance but it doesn't start - checked the event log and got:   Log Name: Application Source: Application Error Date: 2/21/2012 2:20:49...

Id #6792 | Release: None | Updated: Feb 21, 2013 at 11:59 PM by ghuey | Created: Feb 21, 2012 at 1:27 PM by ben555

Does not run on Windows 8

The migration wizard does not run on Windows 8, even in compatibility mode.

Id #6784 | Release: None | Updated: Feb 21, 2013 at 11:59 PM by aeinbu | Created: Feb 18, 2012 at 6:20 PM by timheuer

Will not run on Windows 8

After downloading this, the migration wizard will not run on Windows 8 client.

Id #6783 | Release: None | Updated: Feb 21, 2013 at 11:59 PM by timheuer | Created: Feb 18, 2012 at 6:17 PM by timheuer

Tables with an ! crash Azure MW when BCP'ing data into SQL Azure

We recently had an issue with migrating a client's database to SQL Azure for an acceleration lab. The database had ~230 tables and kept crashing at some point in the BCP process.   We eventually tr...

Id #6726 | Release: None | Updated: Feb 21, 2013 at 11:59 PM by ghuey | Created: Jan 25, 2012 at 4:33 PM by IQCloud

No function export with SQLAzureMWBatchBackup

I'm using the command line backup tool to export my local sql server database (2008 R2 Standard) to sql azure, but user defined functions are not created in the generated .sql file, even if the "Sc...

Id #6712 | Release: None | Updated: Feb 21, 2013 at 11:59 PM by Liu79 | Created: Jan 13, 2012 at 12:43 PM by Liu79

Output Folder of BatchBackup

Hey,   i currently try to use the command line tools in our automatic build system. sadly i can only define the root folder for the output of the BatchBackup, but the files are layed into a subfold...

Id #6705 | Release: None | Updated: Feb 21, 2013 at 11:59 PM by ghuey | Created: Jan 5, 2012 at 3:26 PM by SeriousM

Index Out of Bounds Error for SQL Azure Connections...

Getting an "Index Out of Bounds" error when I attempt to connect to a basic SQL Azure database... Not sure what the error is.   If there are issues with the connection string, then the UI tooling s...

Id #6599 | Release: None | Updated: Feb 21, 2013 at 11:59 PM by BrianABird | Created: Nov 10, 2011 at 7:47 PM by Aaronontheweb

Shutdown column name in Stored Procedure

The migration wizard will not script a stored procedure that contains a column named with "WSShutdown".   Error from script generator StoredProcedure [dbo].[WorkstationBootGet] -- Shutdown is not s...

Id #6511 | Release: None | Updated: Feb 21, 2013 at 11:59 PM by achopp | Created: Sep 29, 2011 at 4:38 PM by achopp

3.7.7 Introduces Bug w/ Non Default Collation

We have SQL_Latin1_General_CP1_CS_AS collation on one of our tables that seems to be ignored during migration.   The subsequent BCP insertions then trigger errors as they're in violation of the uni...

Id #6510 | Release: None | Updated: Feb 21, 2013 at 11:59 PM by ghuey | Created: Sep 29, 2011 at 2:31 PM by auspicious

Cannot Connect to SQL Azure

Previous versions (IE 3.7.4) worked great. This version will not connect to SQL Azure after running the analysis and migration scripts. I really need this to work since there isn't any other viable...

Id #6504 | Release: None | Updated: Feb 21, 2013 at 11:59 PM by mneerincx | Created: Sep 28, 2011 at 1:56 PM by mikewiegand007

Cannot Launch

hi i just downloaded 3.7.7 on windows 7. But i am being unable to launch the app. as soon as i clcik the exe file i get windows error "the program is not responding" not sure whats going on but i c...

Id #6498 | Release: None | Updated: Feb 21, 2013 at 11:59 PM by ghuey | Created: Sep 22, 2011 at 5:40 PM by hasmu

Ignore "collate statements"

Hi,   Is it possible to add an option to ignore "collate" statements please ?   Thanks !

Id #6495 | Release: None | Updated: Feb 21, 2013 at 11:59 PM by rodbeck | Created: Sep 22, 2011 at 1:30 PM by rodbeck

Error connecting to a valid SQL Azure server

I am finding that the database collection contains no elements after logging into the "Target" SQL Azure step. The Migration Tool worked fine for me a few days ago and I verified my SQL Azure accou...

Id #6470 | Release: None | Updated: Feb 21, 2013 at 11:59 PM by ghuey | Created: Sep 11, 2011 at 4:12 AM by thm99

Can't migrate tables containing geography or geometry spatial columns

When scripting data from a SQL Server 2008 R2 (SP1) table that contains a column of geography or geometry datatype under SQLAzureMW 3.7.7, the results summary produces a warning: "Either the object...

Id #6415 | Release: None | Updated: Feb 21, 2013 at 11:59 PM by tanoshimi | Created: Aug 31, 2011 at 6:51 AM by tanoshimi

Disabled foreign key constraints not generated properly by Wizard in output scripts

T-SQL scripts generated by the SQL Azure Migration Wizard v3.7.7 do not generate ALTER TABLE ... NOCHECK statements for disabled foreign key constraints at the right point in the output script. Th...

Id #6411 | Release: None | Updated: Feb 21, 2013 at 11:59 PM by ghuey | Created: Aug 30, 2011 at 3:58 PM by jjkdevster

Migration excludes Synonyms

Hi,   I have synonyms defined on my on premise database. They are lost after the migration.

Id #6366 | Release: None | Updated: Jul 2 at 9:19 PM by AggieEric | Created: Aug 9, 2011 at 12:35 PM by r0dbeck

Program Crashes on Data Migration From Azure to Local New Database, fix included

I was trying to copy my Azure database to localhost the other day, and the program just crashed. I repeated the process with the same result. I downloaded the source, and was able to trace the erro...

Id #6246 | Release: None | Updated: Feb 21, 2013 at 11:59 PM by ghuey | Created: Jun 30, 2011 at 10:27 PM by Gleno

BCP failed if table name contains Japanese characters

Tryign to migrate one of my databases to SQL Azure yet it failed with the below,   SQLState = S0002, NativeError = 208 Error = [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object n...

Id #6212 | Release: None | Updated: Feb 21, 2013 at 11:59 PM by ghuey | Created: Jun 14, 2011 at 6:30 PM by jcyang75

Unable to resolve column level collations - on any table with XML column

I get an error on 4 of my tables which have (non indexed) xml columns when analysing and migrating - data does not copy.   SQLState = S1000, NativeError = 0 Error = [Microsoft][ODBC SQL Server Driv...

Id #6171 | Release: None | Updated: Feb 21, 2013 at 11:59 PM by kcshot | Created: May 31, 2011 at 5:57 PM by kcshot

ALTER TABLE [tableName] SET (LOCK_ESCALATION = AUTO) not supported in sql azure

ALTER TABLE [tableName] SET (LOCK_ESCALATION = AUTO) is not detected as not supported by SQL Server.

Id #5945 | Release: None | Updated: Feb 22, 2013 at 12:00 AM by ghuey | Created: Mar 16, 2011 at 3:13 PM by nclerc

ALTER TABLE [tableName] SET (LOCK_ESCALATION = AUTO) not supported in sql azure

ALTER TABLE [tableName] SET (LOCK_ESCALATION = AUTO) is not detected as not supported by SQL Server.

Id #5944 | Release: None | Updated: Feb 22, 2013 at 12:00 AM by nclerc | Created: Mar 16, 2011 at 3:12 PM by nclerc

DATA_COMPRESSION = PAGE not detected as unsupporter

option ", DATA_COMPRESSION = PAGE" on CREATE WITH is not supported in SQL Azure

Id #5943 | Release: None | Updated: Feb 22, 2013 at 12:00 AM by nclerc | Created: Mar 16, 2011 at 2:59 PM by nclerc

undocumented sp_MSForEachTable stored proc not detected as missing in SQL Azure

The use of undocumented stored proc sp_MSForEachTable (and sp_MSforeachdb) are not detected/corrected. Although this function are undocumented, i've found it in many customer project, so it could b...

Id #5939 | Release: None | Updated: Feb 22, 2013 at 12:00 AM by nclerc | Created: Mar 15, 2011 at 4:53 PM by nclerc

SELECT FROM [server].[dbo].tableName not corrected/detected

the following syntax : IF EXISTS(Select 1 from [myServerName].[dbo].myTable WHERE Scol=''Fleet'') generate in sql azure : Error #: 40515 -- Reference to database and/or server name in 'Optiplant.d...

Id #5937 | Release: None | Updated: Aug 19, 2013 at 12:07 PM by Jsalichos | Created: Mar 15, 2011 at 3:58 PM by nclerc

SWITCH keyword not detected/corrected

the following syntax is not detected : ALTER TABLE MyTable SWITCH PARTITION @partitionNum TO Table_Historique and generate in sql azure : --> Error #: 40517 -- Keyword or statement option 'SWITCH' ...

Id #5936 | Release: None | Updated: Feb 22, 2013 at 12:00 AM by nclerc | Created: Mar 15, 2011 at 3:51 PM by nclerc

"ALTER PARTITION FUNCTION" not detected/corrected

the following statement is not detected : ALTER PARTITION FUNCTION PFN_Functionname and generate in sql azure : Error #: 40510 -- Statement 'ALTER PARTITION FUNCTION' is not supported in this versi...

Id #5935 | Release: None | Updated: Feb 22, 2013 at 12:00 AM by nclerc | Created: Mar 15, 2011 at 3:47 PM by nclerc

DBCC CHECKIDENT Syntax not detected or corrected

the following syntax DBCC CHECKIDENT(tableName, RESEED, 0) failed to execute   and generate "Error #: 40518 -- DBCC command 'CHECKIDENT' is not supported in this version of SQL Server." when runiin...

Id #5934 | Release: None | Updated: Feb 22, 2013 at 12:41 PM by ondravondra | Created: Mar 15, 2011 at 3:42 PM by nclerc

FROM OPENXML syntax not corrected/detected

the following syntax are not detected/corrected INSERT into #tempTable SELECT c1, c2 , ModifiedDataValue = NULL, 0 FROM OPENXML(@xmlDoc, ''DataValues/DataValue'', 2) WITH DataValue and generate ...

Id #5933 | Release: None | Updated: Feb 22, 2013 at 12:00 AM by nclerc | Created: Mar 15, 2011 at 3:33 PM by nclerc

xp_create_subdir not detected

the following syntax are not corrected/detected : EXEC master.dbo.xp_create_subdir @PathWithFolder and generate the error "Reference to database and/or server name in 'master.dbo.xp_create_subdir' ...

Id #5932 | Release: None | Updated: Feb 22, 2013 at 12:00 AM by nclerc | Created: Mar 15, 2011 at 3:29 PM by nclerc

xp_create_subdir not detected

the following syntax are not corrected/detected : EXEC master.dbo.xp_create_subdir @PathWithFolder and generate the error "Reference to database and/or server name in 'master.dbo.xp_create_subdir' ...

Id #5931 | Release: None | Updated: Feb 22, 2013 at 12:00 AM by nclerc | Created: Mar 15, 2011 at 3:29 PM by nclerc

sp_detach_db still in migrated sql

the following syntax are not migrated by SQLAzureMW : EXEC @CR = master.dbo.sp_detach_db @dbname = @ArchName

Id #5930 | Release: None | Updated: Feb 22, 2013 at 12:00 AM by nclerc | Created: Mar 15, 2011 at 3:20 PM by nclerc

String literals as column aliases

Hi, I'm using the tool to migrate the DNN database to Azure, and I'm finding that some old store procedures are using "String literals as columns aliases". i.e. SELECT 'Total users'=1. This is not ...

Id #5760 | Release: None | Updated: Aug 5 at 4:36 AM by jmathis | Created: Feb 9, 2011 at 10:49 AM by davidjrh

Errors On Migrate From Azure

Multiple errors Creating Script from Azure (Schema only To start)   [dbo].[aspnet_AnyDataInTables] not scripted --> Property TextHeader is not available for StoredProcedure '[dbo].[aspnet_AnyDataIn...

Id #5713 | Release: None | Updated: Feb 22, 2013 at 12:00 AM by ghuey | Created: Jan 31, 2011 at 7:00 PM by hurricanepkt

hangs idefinitely on 'sorting objects by dependency...'

was trying to export FROM sql azure (Sitefinity community edition database) to SQL Server 2005 (on domain.com)

Id #5648 | Release: None | Updated: Feb 22, 2013 at 12:00 AM by ghuey | Created: Jan 9, 2011 at 4:37 AM by JDPeckham

PAD_INDEX with Azure to Azure

When migrating from Azure Database to Azure Database, the generated script has an error: In CREATE TABLE statement is generated with "PAD_INDEX = OFF". That doesn't work on Azure Databases   I Have...

Id #5562 | Release: None | Updated: Feb 22, 2013 at 12:00 AM by ChrisJobson | Created: Dec 16, 2010 at 3:32 PM by nissenvelten

Built-in function 'has_dbaccess' is not supported in this version of SQL Server.

Hi All,   I am getting this error when trying to connect to my SQL Azure Database. I need to migrate from SQLAzure US to SQL Azure EU. I am using SQL Express 2008 SP1, does the software need SQL 20...

Id #5298 | Release: None | Updated: Feb 22, 2013 at 12:00 AM by ghuey | Created: Oct 14, 2010 at 11:00 AM by smsroster

Global Temp Issue

The analyze process reports that "Global Temp Tables Are Not Valid" when it finds two sequential ##'s in code. The issue is that the code could be remarked out, or used in an insert statement. I.E....

Id #5262 | Release: None | Updated: Feb 22, 2013 at 12:00 AM by DeanShoultz | Created: Oct 8, 2010 at 8:47 PM by DeanShoultz

sp_addrolemember, sp_droprolemember

I think that the analyze process reports that sp_addrole and sp_droprole are not valid (which is true) whenever it encounters sp_addrolemember, sp_droprolemember, which are valid.

Id #5261 | Release: None | Updated: Feb 22, 2013 at 12:00 AM by DeanShoultz | Created: Oct 8, 2010 at 8:45 PM by DeanShoultz

Problem with the sintax of bcp "bcp.exe: unknown option d"

this occurs because this parameter is obsolete

Id #5075 | Release: None | Updated: Feb 22, 2013 at 12:00 AM by ghuey | Created: Aug 25, 2010 at 2:35 PM by vpatrinhani

Missing sqlncli.msi

HI! I just installed SAMW v3.3.3 and ran into a "The program can't start because sqlncli.dll is missing..." bug. The previous version worked fine so I'm not quite sure what's happening. Just to ...

Id #4943 | Release: None | Updated: Feb 22, 2013 at 12:00 AM by ghuey | Created: Jul 26, 2010 at 2:41 PM by lsberman

Migrating FROM SQL Azure

I had to alter the BCPArgsOut to get the prgram to Extract data FROM a SQL Azure database because the -d switch was not being recognised.   This is what worked for me: value="{2}.{0} out {1} -E -n

Id #4934 | Release: None | Updated: Feb 22, 2013 at 12:00 AM by ghuey | Created: Jul 24, 2010 at 3:15 AM by btmi

No detection of mandatory "WITH" when specifying table hints

In SQL azure SELECT * FROM t0 (NOLOCK) is illegal and should be rewritten explicitating "WITH", SELECT * FROM t0 WITH (nolock). Apparently other hints must also be specified using "WITH".   Thi...

Id #4857 | Release: None | Updated: Feb 22, 2013 at 12:00 AM by mdikov | Created: Jul 16, 2010 at 6:52 AM by faester

Missing detection of invalid alias specification

Reverse aliasing: In the legacy database we ported reverse alias specifications had been used a few places like: "SELECT 'aliasName' = expr ". This had to be rewritten as "SELECT expr AS aliasName...

Id #4856 | Release: None | Updated: Feb 22, 2013 at 12:00 AM by ghuey | Created: Jul 16, 2010 at 6:51 AM by faester

Crash when changing codepage for bcp

I have the problem that Euro currency Symbol (€) contained in a varchar column in one of my tables gets converted to underscore (_) when using SQL Azure Migration Wizzard. So I changed the codepage...

Id #4727 | Release: None | Updated: Feb 22, 2013 at 12:00 AM by frank83 | Created: Jul 7, 2010 at 11:10 AM by frank83

Should use schema names when checking for constraints

It looks like foreign_keys was implemented correctly IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'----->[cf_team]<----,[FK_USER_TEAM_TAG_XREF_USER_TEAMS]') AND parent_o...

Id #4659 | Release: None | Updated: Feb 22, 2013 at 12:00 AM by kevindwolf | Created: Jun 19, 2010 at 11:34 AM by kevindwolf

Unable to connect to SQLAzure

Hi, I need to migrated the database from sql Azure to SQL Server(on premise). I am using the SQL Migration Wizard for it. I run the exe. I selected teh option Migration without analysing. Gave the ...

Id #4473 | Release: None | Updated: Feb 22, 2013 at 12:00 AM by ghuey | Created: May 10, 2010 at 10:14 AM by hemavasudevan

  • 1-90 of 90 Work Items
    • Previous
    • 1
    • Next