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: Apr 30 at 8:40 AM by Duality | Created: Apr 9 at 10:24 PM by techranger
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 at 11:59 PM by prgjonas | Created: Feb 3 at 5:27 AM by prgjonas
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: Feb 21 at 11:59 PM by ghuey | Created: Dec 1, 2012 at 9:12 PM by mvcdeveloper
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 at 11:59 PM by ghuey | Created: Oct 19, 2012 at 6:08 AM by BitKFu
After generating the schema for a DB, I have many statements that have "NOT FOR REPLICATION"
Id #7170 | Release:
None
| Updated: Feb 21 at 11:59 PM by ghuey | Created: Oct 17, 2012 at 1:47 AM by Davd_Molina
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: Feb 21 at 11:59 PM by nate_leanserver | Created: Oct 16, 2012 at 9:17 PM by nate_leanserver
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 at 11:59 PM by ghuey | Created: Sep 26, 2012 at 9:45 AM by AlanSMac
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 at 11:59 PM by chinnarao | Created: Sep 12, 2012 at 1:19 AM by chinnarao
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 at 11:59 PM by ghuey | Created: Sep 11, 2012 at 8:17 AM by Alaa9jo
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 at 11:59 PM by tiny | Created: Aug 16, 2012 at 2:43 PM by tiny
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 at 11:59 PM by madloo | Created: Jul 30, 2012 at 2:58 AM by madloo
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 at 11:59 PM by wkelliott | Created: Jul 29, 2012 at 7:11 PM by wkelliott
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 at 11:59 PM by samluo001 | Created: Jun 28, 2012 at 7:06 AM by bobaman
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 at 11:59 PM by gresziu | Created: Jun 20, 2012 at 7:42 PM by jmanning
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 21 at 11:59 PM by ghuey | Created: Jun 15, 2012 at 11:55 PM by saeynico
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: Feb 21 at 11:59 PM by ghuey | Created: Jun 11, 2012 at 12:15 AM by michaelyd
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 at 11:59 PM by ghuey | Created: May 10, 2012 at 10:33 PM by Giavinh
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 at 11:59 PM by ghuey | Created: May 10, 2012 at 8:50 PM by Giavinh
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: Feb 21 at 11:59 PM by ghuey | Created: Apr 24, 2012 at 9:08 AM by AndyKrafft
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 at 11:59 PM by ghuey | Created: Apr 24, 2012 at 8:49 AM by AndyKrafft
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 at 11:59 PM by JamesEinTech | Created: Apr 13, 2012 at 11:23 AM by JamesEinTech
I get this error right after I select Analyze / Migrate "SQL Database" and hit the next button.
Id #6825 | Release:
None
| Updated: Feb 21 at 11:59 PM by ghuey | Created: Mar 7, 2012 at 3:38 PM by fdbaird
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 at 11:59 PM by ghuey | Created: Feb 24, 2012 at 4:08 PM by mglukhankov
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 at 11:59 PM by ghuey | Created: Feb 22, 2012 at 3:35 AM by mattdone
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 at 11:59 PM by ghuey | Created: Feb 21, 2012 at 1:27 PM by ben555
The migration wizard does not run on Windows 8, even in compatibility mode.
Id #6784 | Release:
None
| Updated: Feb 21 at 11:59 PM by aeinbu | Created: Feb 18, 2012 at 6:20 PM by timheuer
After downloading this, the migration wizard will not run on Windows 8 client.
Id #6783 | Release:
None
| Updated: Feb 21 at 11:59 PM by timheuer | Created: Feb 18, 2012 at 6:17 PM by timheuer
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 at 11:59 PM by ghuey | Created: Jan 25, 2012 at 4:33 PM by IQCloud
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 at 11:59 PM by Liu79 | Created: Jan 13, 2012 at 12:43 PM by Liu79
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 at 11:59 PM by ghuey | Created: Jan 5, 2012 at 3:26 PM by SeriousM
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 at 11:59 PM by BrianABird | Created: Nov 10, 2011 at 7:47 PM by Aaronontheweb
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 at 11:59 PM by achopp | Created: Sep 29, 2011 at 4:38 PM by achopp
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 at 11:59 PM by ghuey | Created: Sep 29, 2011 at 2:31 PM by auspicious
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 at 11:59 PM by mneerincx | Created: Sep 28, 2011 at 1:56 PM by mikewiegand007
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 at 11:59 PM by ghuey | Created: Sep 22, 2011 at 5:40 PM by hasmu
Hi,
Is it possible to add an option to ignore "collate" statements please ?
Thanks !
Id #6495 | Release:
None
| Updated: Feb 21 at 11:59 PM by rodbeck | Created: Sep 22, 2011 at 1:30 PM by rodbeck
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 at 11:59 PM by ghuey | Created: Sep 11, 2011 at 4:12 AM by thm99
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 at 11:59 PM by tanoshimi | Created: Aug 31, 2011 at 6:51 AM by tanoshimi
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 at 11:59 PM by ghuey | Created: Aug 30, 2011 at 3:58 PM by jjkdevster
Hi,
I have synonyms defined on my on premise database. They are lost after the migration.
Id #6366 | Release:
None
| Updated: Feb 21 at 11:59 PM by ghuey | Created: Aug 9, 2011 at 12:35 PM by r0dbeck
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 at 11:59 PM by ghuey | Created: Jun 30, 2011 at 10:27 PM by Gleno
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 at 11:59 PM by ghuey | Created: Jun 14, 2011 at 6:30 PM by jcyang75
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 at 11:59 PM by kcshot | Created: May 31, 2011 at 5:57 PM by kcshot
ALTER TABLE [tableName] SET (LOCK_ESCALATION = AUTO) is not detected as not supported by SQL Server.
Id #5945 | Release:
None
| Updated: Feb 22 at 12:00 AM by ghuey | Created: Mar 16, 2011 at 3:13 PM by nclerc
ALTER TABLE [tableName] SET (LOCK_ESCALATION = AUTO) is not detected as not supported by SQL Server.
Id #5944 | Release:
None
| Updated: Feb 22 at 12:00 AM by nclerc | Created: Mar 16, 2011 at 3:12 PM by nclerc
option ", DATA_COMPRESSION = PAGE" on CREATE WITH is not supported in SQL Azure
Id #5943 | Release:
None
| Updated: Feb 22 at 12:00 AM by nclerc | Created: Mar 16, 2011 at 2:59 PM by nclerc
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 at 12:00 AM by nclerc | Created: Mar 15, 2011 at 4:53 PM by nclerc
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: Feb 22 at 12:00 AM by nclerc | Created: Mar 15, 2011 at 3:58 PM by nclerc
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 at 12:00 AM by nclerc | Created: Mar 15, 2011 at 3:51 PM by nclerc
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 at 12:00 AM by nclerc | Created: Mar 15, 2011 at 3:47 PM by nclerc
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 at 12:41 PM by ondravondra | Created: Mar 15, 2011 at 3:42 PM by nclerc
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 at 12:00 AM by nclerc | Created: Mar 15, 2011 at 3:33 PM by nclerc
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 at 12:00 AM by nclerc | Created: Mar 15, 2011 at 3:29 PM by nclerc
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 at 12:00 AM by nclerc | Created: Mar 15, 2011 at 3:29 PM by nclerc
the following syntax are not migrated by SQLAzureMW :
EXEC @CR = master.dbo.sp_detach_db @dbname = @ArchName
Id #5930 | Release:
None
| Updated: Feb 22 at 12:00 AM by nclerc | Created: Mar 15, 2011 at 3:20 PM by nclerc
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: Feb 22 at 12:00 AM by ghuey | Created: Feb 9, 2011 at 10:49 AM by davidjrh
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 at 12:00 AM by ghuey | Created: Jan 31, 2011 at 7:00 PM by hurricanepkt
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 at 12:00 AM by ghuey | Created: Jan 9, 2011 at 4:37 AM by JDPeckham
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 at 12:00 AM by ChrisJobson | Created: Dec 16, 2010 at 3:32 PM by nissenvelten
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 at 12:00 AM by ghuey | Created: Oct 14, 2010 at 11:00 AM by smsroster
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 at 12:00 AM by DeanShoultz | Created: Oct 8, 2010 at 8:47 PM by DeanShoultz
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 at 12:00 AM by DeanShoultz | Created: Oct 8, 2010 at 8:45 PM by DeanShoultz
this occurs because this parameter is obsolete
Id #5075 | Release:
None
| Updated: Feb 22 at 12:00 AM by ghuey | Created: Aug 25, 2010 at 2:35 PM by vpatrinhani
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 at 12:00 AM by ghuey | Created: Jul 26, 2010 at 2:41 PM by lsberman
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 at 12:00 AM by ghuey | Created: Jul 24, 2010 at 3:15 AM by btmi
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 at 12:00 AM by mdikov | Created: Jul 16, 2010 at 6:52 AM by faester
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 at 12:00 AM by ghuey | Created: Jul 16, 2010 at 6:51 AM by faester
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 at 12:00 AM by frank83 | Created: Jul 7, 2010 at 11:10 AM by frank83
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 at 12:00 AM by kevindwolf | Created: Jun 19, 2010 at 11:34 AM by kevindwolf
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 at 12:00 AM by ghuey | Created: May 10, 2010 at 10:14 AM by hemavasudevan